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" });


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


About the Author

Jaime Olivares
Architect Freelance (
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.
Follow on   LinkedIn

Comments and Discussions

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