How to read / write geography data using C#, Entity Framework and SQL Server 2008?

c# sql-server-2008 entity-framework gis geography
Filip Filipović picture Filip Filipović · May 18, 2012 · Viewed 21.6k times · Source

I have a form from which the user will be able to enter the latitude and longitude of a certain point on the map. The data will be input as string values. I did some research and found out from various sources that the Entity Framework doesn't support geography data types.

  • How can I parse and/or save the string data to a geography column in a database?
  • How can I access it and reparse it as string once it is stored?

Thanks in advance!

Answer

Pawel picture Pawel · May 18, 2012

In fact Entity Framework 5 components that are shipped with .NET Framework 4.5 do support spatial types. Take a look at this walkthrough.

EDIT With EF6 you can use spatial types on both .NET Framework 4 and .NET Framework 4.5

Related questions

Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column 'Id', table 'FileStore'; column does not allow nulls

I have an entity with primary key "Id" which is Guid: public class FileStore { public Guid Id { get; set; } public string Name { get; set; } public string Path { get; set; } } And some configuration: protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity&…

Read More
conversion of a datetime2 data type to a datetime data type error with EF Code first?

I'm using EF Code first with my asp.net mvc application. here is my code: Request.RequestDate = DateTime.Now; the type of RequestDate is datetime in my database. and this is error that occurred when i use the above code!: …

Read More
Entity Framework query performance differs extrem with raw SQL execution

I have a question about Entity Framework query execution performance. Schema: I have a table structure like this: CREATE TABLE [dbo].[DataLogger] ( [ID] [bigint] IDENTITY(1,1) NOT NULL, [ProjectID] [bigint] NULL, CONSTRAINT [PrimaryKey1] PRIMARY KEY CLUSTERED ( [ID] ASC ) ) CREATE TABLE [dbo].[…

Read More