I used this tutorial to create ASP .NET MVC Site which manages table of Persons. Now, I want to add another table (with controller) which manage a table with SQLGeography type. EF 4.3 don't support SQLGeography, so if I use in the model It can't genrate all the add,update,delete forms and methods. The way I see it, I have two alternatives:
- Create temproary table, Which VS knows how to generate (longitude and latitude as two doubles). Then, add trigger to the DB when Add/Update occurs to update it in the main table. (I use the SQLGeography as WebAPI therefore I don't care it will be shows as two doubles).
- Don't use EF. If this is the right way, How should I do it? I Create Empty controller, and then use ADO .NET to add/update/delete?
I hope my question is understood, I'm have a hard time with SQLGeography.
Thank you!