I've tried and tried with this but support still seems laughably broken. The 2 options for a .NET Core supported implementation I can see are:
- NetTopologySuite.IO.SqlServerBytes
- 3rd Party Microsoft.SqlServer.Types library
NetTopologySuite works for a narrow set of cases, you can read a Geometry from a DataReader, but DataReader.GetFieldType is broken, which in turn completely breaks DataAdapter.Fill.
The 3rd Party libraries seem to suffer from all kinds of loading issues and null references.
I understand that Microsoft seem to have abandoned getting this to work, but there must be some kind of solution out there?