Support for Sort using EFCore.SqlServer.HierarchyId property

Is your feature request related to a problem?

Eventual goal: Sort IQuerable collection by EFCore.SqlServer.HierarchyId property.

We have a hierarchyId (https://github.com/efcore/EFCore.SqlServer.HierarchyId) column inside a POCO object.

Alternative 1:

If HierarchyId column wasn't ignored then the following exception is thrown:

System.InvalidOperationException: 'No compatible constructor found for input type type `Microsoft.EntityFrameworkCore.HierarchyId`.
Either you have to provide a public constructor with settable properties or a public constructor that allows to pass in values for read-only properties.There was no way to set the following properties: .'

Alternative 2:

We ignored HierarchyId property and then used a resolver to expose this column. Now, data cannot be sorted by this resolved property since sorting as of now doesn't support the resolved columns.

The solution you'd like

Ability to sort by a resolved field OR ability to expose a HierarchyId column in schema.

Product

Hot Chocolate

Start at Hot Chocolate's sorting support for resolved fields and the EFCore.SqlServer.HierarchyId property described in the issue. Determine whether sorting a resolved field or exposing the HierarchyId column is the more appropriate supported path, then verify that IQueryable collections can sort by the hierarchy value and that the behavior is covered by a regression test.