Doesn't work for SqlBulkCopy

[mxcolin]

I've tried using this with SqlBulkCopy but I get the following:

System.InvalidOperationException: The given value 'System.Data.SqlTypes.SqlBytes' of type SqlBytes from the data source cannot be converted to type udt for Column 1 [GeoData] Row 1. ---> System.ArgumentException: Specified type is not registered on the target server. System.Data.SqlTypes.SqlBytes, System.Data.Common, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a.

I've tried creating the DataColumn as

DataColumn newGeometryColumn = new DataColumn("geo_column", typeof(SqlBytes));

But not sure if that's the right way to achieve this.

[bricelam]

Hmm, I'm not sure this is supported by dotnet/SqlClient. Can you file an issue there and see if they know of a way to do it?

[mxcolin]

You can do SqlBulkCopy in SqlClient but then you have to reference System.Data.SqlTypes which means it won't work on .Net Core which is why I'm using this library.