sql geography to dbgeography?

by

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!

More Related Contents:

  1. SQL Server 2008 Spatial: find a point in polygon
  2. Bulk insert with text qualifier in SQL Server
  3. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  4. How do I use cascade delete with SQL Server?
  5. How can foreign key constraints be temporarily disabled using T-SQL?
  6. An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
  7. How to add Active Directory user group as login in SQL Server
  8. Maximum size of a varchar(max) variable
  9. How to update large table with millions of rows in SQL Server?
  10. How to Use UTF-8 Collation in SQL Server database?
  11. How do you specify a different port number in SQL Management Studio?
  12. How Do I Split a Delimited String in SQL Server Without Creating a Function?
  13. What’s the longest possible worldwide phone number I should consider in SQL varchar(length) for phone
  14. Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
  15. Should every User Table have a Clustered Index?
  16. Sequence as default value for a column
  17. Aggregate bitwise-OR in a subquery
  18. How to connect to MS SQL Server using Inno Setup?
  19. VarBinary vs Image SQL Server Data Type to Store Binary Data?
  20. SQL count rows in a table
  21. Convert month name to month number in SQL Server
  22. Decimal values in SQL for dividing results
  23. How do I programmatically set the connection string for Entity-Framework Code-First?
  24. Need help in calculation using two Datasets using Expression SSRS
  25. SQL Server Xml query with multiple namespaces
  26. T-SQL incrementing counter based on change in a column value
  27. How can I fill a column with random numbers in SQL? I get the same value in every row
  28. The request failed or the service did not respond in a timely fashion?
  29. Bulk insert fixed width fields
  30. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”

Leave a Comment