SQL Server DataReader.GetField return null instead of geography data

Costas

Administrator
Staff member
fix via NuGet (1.6mb)

Microsoft.SqlServer.Types is a library you can add to your .NET project to work with SQL Server geography and geometry data types in your .NET project.

https://www.nuget.org/packages/Microsoft.SqlServer.Types/

ref - https://stackoverflow.com/q/55466593

NuGet analyzed contains :
-.NET Wrapper (383kb)
-msvcr120.dll (VC++ runtime - 963kb)
-SqlServerSpatial140.dll (native - 732kb)

--

w/o NuGet, you can cast the field as

JavaScript:
SELECT cast(GeoLocation as VARCHAR(max)) FROM table
--or
SELECT cast(GeoLocation as VARBINARY(max)) FROM table
 
Top