Spatial Data (geography) not automatically added in Edmx
I had to add geography data type in one of my stored procedure and pull this in visual studio using entity framework (EF). Unfortunately this was not add automatically.
For normal datatype like string, date, integer this not a problem.
To manually add this in visual studio.
- Click on edmx files. Do a right click and choose modal browser
- Goto Modal Browser -> click under complex types. Choose scalar property and add Geography
- Make sure name as same as in storage procedure. In my case It was geolocation
- Run your stored procedure and it should be able to populate the data