sql geography to dbgeography?

sql-server c#-4.0 gis geospatial spatial
Eric picture Eric · Feb 27, 2013 · Viewed 9k times · Source

Maybe I'm missing something. I have a sql server column of the "Geography" datatype.

I want to use the DbGeography type in my c# code. Any way to cast or convert from sql's geography to dbgeography?

Answer

Jon Bellamy picture Jon Bellamy · Apr 18, 2013

Sorry for the late response - but saw this whilst searching for something else.

Simply do the following:

SqlGeography theGeography;
int srid = 4326; // or alternative

DbGeography newGeography = DbGeography.FromText(theGeography.ToString(), srid);

To reverse it:

DbGeography theGeography;
SqlGeography newGeography = SqlGeography.Parse(theGeography.AsText()).MakeValid();

Hope that helps!

Related questions

Return an output parameter from SQL Server via a stored procedure and c#

I am having a devil of a time getting an output value from SQL Server. Here is my stored procedure: ALTER PROCEDURE [dbo].[Insert_UnknownCustomer_Quote_Document] -- Add the parameters for the stored procedure here @NewDocumentFileName nvarchar(100), @NewDocumentWordCount int, @…

Read More
Fastest way of performing Bulk Update in C# / .NET

I'm trying to figure out whats the best possible way to perform a bulk update via my mini console application in SQL server. I have written my own way of bulk update like following: SqlCommand command = new SqlCommand(); command.Connection = …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More