Implement SqlHierarchyId type for .NET Core

[Ansssss]

Microsoft SQL Server has a hierarchyid data type defined since SQL Server 2008. In the .NET Framework there is a nuget to support using the SqlHierarchyId struct: Microsoft.SqlServer.Types. Unfortunately that nuget is built for the .NET Framework and not .NET Core. If you add that nuget to a .NET Core project, the following compiler warning is produced:

Warning NU1701 Package 'Microsoft.SqlServer.Types 14.0.1016.290' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project.

There should be an implementation of SqlHierarchyId for .NET Core.

I tried using the Microsoft.Data.SqlClient nuget, but that does not have the SqlHierarchyId defined.
My current workaround is to use the dotMarten.Microsoft.SqlServer.Types nuget.

Related issues (which I don't think cover this same problem):

• Implement SqlGeography and SqlGeometry for Spatial Types support for .Net Core #30 - but that one only applies to the SqlGeography/spatial types (which are also currently defined in Microsoft.SqlServer.Types).
• SqlClient implementation and API is not complete in Core #17 - requests more stuff in Microsoft.Data.SqlClient, but I don't see that it would add SqlHierarchyId.

[cheenamalhotra]

Thanks for filing a separate issue on this one.
We'll consider implementing it sometime in future.

[JohnyL]

Are there any news on SqlHierarchyId?

[cheenamalhotra]

@JohnyL

This isn't in our primary targets right now. We'll get to this when we have priority support addressed and have some room.

[brumlemann]

Any update on this? It is sorely needed

[yurart]

Yeah, I also wait for this feature. Hope it will be implemented soon.

[alexey-kachalov]

Any plans to implement this?

[cheenamalhotra]

Hi guys!

Have you tried using https://www.nuget.org/packages/Microsoft.SqlServer.DACFx that now supports Microsoft.Data.SqlClient (starting from v150.4769.1) and implements SqlHierarchyId for .NET Core, .NET Framework and .NET Standard?

If you check the "Package" defined in the .NET API reference docs,, this type in Microsoft.SqlServer.Types namespace is documented from this DACFx NuGet package.

It also seems to implement SqlGeography and SqlGeometry for all .NET platforms. (as requested in #30)

[ErikEJ]

@cheenamalhotra I think it is not the cross platform package, but the old NetFX one.