When using Microsoft.Data.SqlClient an InvalidCastException will be thrown

[yorek]

When using Microsoft.Data.SqlClient 2.0.1 the following exception will be generated

[System.InvalidCastException] Unable to cast object of type 'Microsoft.SqlServer.Types.SqlHierarchyId' to type 'Microsoft.Data.SqlClient.Server.IBinarySerialize'.
once proper assembly redirection is in place

 if (assemblyName.FullName == "Microsoft.SqlServer.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91")
            {
                var a = typeof(SqlGeography).Assembly;
                _logger.Info("Rebinding to " + a.FullName);
                return a;
            }

[dotMorten]

Microsoft.Data.SqlClient isn't supported. Likely duplicate of: #29
Fixing that would be a major breaking change, so would have to be a separate build/package

[yorek]

I understand...I've submitted a PR to make it work with Microsoft.Data.SqlClient. It probably make sense to keep support to both, even if the newer Microsoft.Data.SqlClient is the preferred library (as per https://devblogs.microsoft.com/dotnet/introducing-the-new-microsoftdatasqlclient/)

[dotMorten]

Fixed in #69