I m developing an application in C# that will use and store geographic locations using the data type "Geography" in SQL Server 2008. I was planning to use the Entity Framework but soon discovered it lacks support for spatial data. Does anyone have experience with or know of other OR mappers with spatial support?
The system will have few writes and many reads of geographical data. What is a good/preffered way to read/write spatial/Geography data from C#?