Skip to content

README.md

Latest commit

 

History

History
29 lines (19 loc) · 873 Bytes

README.md

File metadata and controls

29 lines (19 loc) · 873 Bytes

Microsoft.SqlServer.Types

a .NET Standard implementation of the spatial types in Microsoft.SqlServer.Types

Usage

Input parameter

Assigning SqlGeometry or SqlGeography to a command parameter:

   command.Parameters.AddWithValue("@GeographyColumn", mySqlGeography);
   command.Parameters["@GeometryColumn"].UdtTypeName = "Geography";

   command.Parameters.AddWithValue("@GeographyColumn", mySqlGeometry);
   command.Parameters["@GeometryColumn"].UdtTypeName = "Geometry"

The geometry will automatically be correctly serialized.

Reading geometry and geography

Due to the "real" Microsoft.SqlServer.Types assembly isn't available, the types won't be deserialized automatically. Instead you'll need to use the Deserialize method:

   var binvalue = reader.GetSqlBytes(rowid);
   var geometry = SqlGeometry.Deserialize(binvalue);