SqlHierarchyId work in efcore 2 but not working in efcore3

[110vahid]

when using SqlHierarchyId in models and call insert method exeption occured.
innerexception : No mapping exists from object type Microsoft.SqlServer.Types.SqlHierarchyId to a known managed provider native type.

[ajcvickers]

@110vahid SqlHierarchyId minimally "worked" in EF Core 2.x on .NET Framework. It is not supported on .NET Core. Also, given that EF Core 5 will no longer run on .NET Framework, we are not currently prioritizing making SqlHierarchyId work in EF Core.

[110vahid]

Is there a replacement for SqlHierarchy in .net core 3?

[ajcvickers]

@110vahid Official support in .NET Core requires that the types be implemented, which is tracked by SqlClient issue #322, referenced above.
If this gets done, then #365 is tracking support in EF Core.

Issue #365 also contains discussion of and links to some community efforts to bring an equivalent type to .NET Core.

Closing this as a duplicate of #365, which we will use for potential future support of SqlHierarchyId in EF Core.