Click here to Skip to main content
Click here to Skip to main content

Tagged as

TIP: Managing SqlGeography class from C#

, 4 Sep 2010 CPOL
Rate this:
Please Sign up or sign in to vote.
How to Insert or Update an SqlGeography object in SQL Server 2008 from a C# application
It took me some time to get this to work. The problem is that SqlGeography C# type, which corresponds to Geography SQL type, is considered an user-defined type (UDT) by the .net SQL library.
 
So, the proper way to insert or update a Geography field is something like this:
 
SqlGeography geo = // Get the coordinates from somewhere...

using (SqlCommand command = 
    new SqlCommand(@"UPDATE Points SET Point=@Point WHERE FeatureID='9999'", connection))
    command.Parameters.Add(new SqlParameter("@Point", geo) { UdtTypeName = "Geography" });
    command.ExecuteNonQuery();
}

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Jaime Olivares
Architect Freelance (jaimeolivares.com)
Peru Peru


Computer Electronics professional, Software Architect and senior Windows C++ and C# developer with experience in many other programming languages, platforms and application areas including communications, simulation systems, PACS/DICOM (radiology), GIS, 3D graphics and HTML5-based web applications.
Currently intensively working with Visual C# 2013 and TFS.
Can be reached at http://www.jaimeolivares.com
Follow on   LinkedIn

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web04 | 2.8.141022.1 | Last Updated 4 Sep 2010
Article Copyright 2010 by Jaime Olivares
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid