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