Menu
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#?
579
SQL Server supports two spatial data types: the geometry data type and the geography data type. The geometry type represents data in a Euclidean (flat) coordinate system. The geography type represents data in a round-earth coordinate system.
The geography spatial data type, geography, is implemented as a . NET common language runtime (CLR) data type in SQL Server. This type represents data in a round-earth coordinate system. The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.
The connecting edge between two vertices in a geometry type is a straight line. However, the connecting edge between two vertices in a geography type is a short great elliptic arc between the two vertices.
You may want to check out the following Stack Overflow post:
In addition, you might also be interested to give a look to SketchPad from the MSDN Code Library, and its blog article SketchPad: A Simple Drawing Editor.
SketchPad is a simple drawing editor that allows you to create elementary geometric shapes, and model them as entities using either the Entity Framework or LINQ to SQL. You can create, read, and delete shapes, and use the built-in spatial index to search for entities by attribute value.
161
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
