declare @h HIERARCHYID = '/1/1/'
select
[Binary] = @h.GetDescendant('/1/1/3/', '/1/1/4/'),
[String] = @h.GetDescendant('/1/1/3/', '/1/1/4/').ToString()

Binary		String
0x5AE058	/1/1/3.1/

var newId = HierarchyId.Parse("/1/1/").GetDescendant(HierarchyId.Parse("/1/1/3/"), HierarchyId.Parse("/1/1/4/"));

using (var ms = new MemoryStream())
using (var binWriter = new BinaryWriter(ms))
{
    newId.Write(binWriter);
    var byteString = BitConverter.ToString(ms.ToArray()).Replace("-", "");
    var result = String.Format("0x{0}", byteString);
}

// Result = 0x5AE0B0

<Project Sdk="Microsoft.NET.Sdk">

    <PropertyGroup>
        <TargetFramework>netcoreapp3.1</TargetFramework>
        <LangVersion>latest</LangVersion>
        <Nullable>enable</Nullable>
        <IsPackable>false</IsPackable>
    </PropertyGroup>

    <ItemGroup>
        <PackageReference Include="Microsoft.NET.Test.Sdk" Version="16.7.1" />
        <PackageReference Include="xunit" Version="2.4.1" />
        <PackageReference Include="EntityFrameworkCore.SqlServer.HierarchyId" Version="1.1.0" />
        <PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="3.1.7" />
    </ItemGroup>
</Project>

using System.Threading.Tasks;
using Microsoft.EntityFrameworkCore;
using Xunit;

namespace HierarchyIdRetry
{
    public class TestEntity
    {
        public TestEntity(string id, HierarchyId position)
        {
            Id = id;
            Position = position;
        }

        public string Id { get; }
        public HierarchyId Position { get; }
    }

    public class TestDbContext : DbContext
    {
        public TestDbContext(DbContextOptions<TestDbContext> options)
            : base(options)
        {
        }

        public virtual DbSet<TestEntity> Entities { get; set; } = default!;

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<TestEntity>(entity =>
            {
                entity.HasKey(e => new { e.Id });
                entity.Property(e => e.Position);
            });
        }
    }

    public class FixtureRetryOnFailure
    {
        public const string ConnectionString = "Data Source=localhost;Initial Catalog=HierarchyId;Integrated Security=True";

        [Theory]
        [InlineData(false)]
        [InlineData(true)]
        public async Task TestRetryOnFailure(bool enableRetryOnFailure)
        {
            var optionsBuilder = new DbContextOptionsBuilder<TestDbContext>()
                .UseSqlServer(ConnectionString, o =>
                {
                    o.UseHierarchyId();
                    if (enableRetryOnFailure)
                    {
                        o.EnableRetryOnFailure(10);
                    }
                });

            await using var dbContext = new TestDbContext(optionsBuilder.Options);

            await dbContext.Database.EnsureDeletedAsync();
            await dbContext.Database.EnsureCreatedAsync();

            await dbContext.Entities.AddAsync(new TestEntity("Hello", HierarchyId.GetRoot()));
            await dbContext.SaveChangesAsync();

            var loaded = await dbContext.Entities.FirstAsync(e => e.Id == "Hello");
            Assert.Equal(HierarchyId.GetRoot(), loaded.Position);
        }
    }
}

System.ArgumentException
Expression of type 'System.Object' cannot be used for parameter of type 'System.Data.SqlTypes.SqlBytes' 
of method 'Microsoft.EntityFrameworkCore.HierarchyId fromProvider(System.Data.SqlTypes.SqlBytes)' (Parameter 'arg0')

 public class DocumentStore
  {
    [Column("stream_id")]
    public Guid StreamId { get; set; }

    [Column("file_stream")]
    public byte[]? FileStream { get; set; }

    [Column("name")]
    [StringLength(255)]
    public string Name { get; set; }

    [Column("path_locator")]
    public HierarchyId PathLocator { get; set; }

    [Column("parent_path_locator")]
    public HierarchyId? ParentPathLocator { get; set; }
    ...
    ...
  }

System.InvalidCastException: No pattern found for: 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000101101010110101011000100000
   at Microsoft.SqlServer.Types.SqlHierarchy.KnownPatterns.GetPatternByPrefix(BitReader bitR)
   at Microsoft.SqlServer.Types.SqlHierarchyId.Read(BinaryReader r)
   at Microsoft.EntityFrameworkCore.HierarchyId.Read(BinaryReader reader)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.SqlServerHierarchyIdValueConverter.fromProvider(SqlBytes bytes)
   at lambda_method9(Closure , QueryContext , DbDataReader , ResultContext , SingleQueryResultCoordinator )
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at BrandManagement.Persistence.Repository.BrandRepository.GetDocumentStoreAsync() in C:\dev\git\product-unik_document_server\src\BrandManagement\BrandManagement.Persistence\Repository\BrandRepository.cs:line 33
   at BrandManagement.Application.Service.BrandService.GetDSAsync() in C:\dev\git\product-unik_document_server\src\BrandManagement\BrandManagement.Application\Service\BrandService.cs:line 33
   at BrandManagement.WebApi.v1.BrandController.GetDSAsync() in C:\dev\git\product-unik_document_server\src\BrandManagement\BrandManagement.WebApi\v1\BrandController.cs:line 46
   at lambda_method4(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)

System.MissingMethodException: 'Method not found: 'Void CoreTypeMappingParameters..ctor(System.Type, Microsoft.EntityFrameworkCore.Storage.ValueConversion.ValueConverter, Microsoft.EntityFrameworkCore.ChangeTracking.ValueComparer, Microsoft.EntityFrameworkCore.ChangeTracking.ValueComparer, System.Func`3<Microsoft.EntityFrameworkCore.Metadata.IProperty,Microsoft.EntityFrameworkCore.Metadata.IEntityType,Microsoft.EntityFrameworkCore.ValueGeneration.ValueGenerator>)'.'



   at Microsoft.EntityFrameworkCore.SqlServer.Storage.SqlServerHierarchyIdTypeMapping.CreateRelationalTypeMappingParameters(String storeType, Type clrType)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.SqlServerHierarchyIdTypeMappingSourcePlugin.FindMapping(RelationalTypeMappingInfo& mappingInfo)
   at Microsoft.EntityFrameworkCore.Storage.RelationalTypeMappingSource.FindMapping(RelationalTypeMappingInfo& mappingInfo)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerTypeMappingSource.FindMapping(RelationalTypeMappingInfo& mappingInfo)
   at Microsoft.EntityFrameworkCore.Storage.RelationalTypeMappingSource.<FindMappingWithConversion>b__8_0(ValueTuple`3 k)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Microsoft.EntityFrameworkCore.Storage.RelationalTypeMappingSource.FindMapping(Type type, IModel model)
   at Microsoft.EntityFrameworkCore.Metadata.Internal.MemberClassifier.IsCandidateNavigationPropertyType(Type targetType, MemberInfo memberInfo, Model model, Nullable`1& shouldBeOwned)
   at Microsoft.EntityFrameworkCore.Metadata.Internal.MemberClassifier.FindCandidateNavigationPropertyType(MemberInfo memberInfo, IConventionModel model, Nullable`1& shouldBeOwned)
   at Microsoft.EntityFrameworkCore.Metadata.Internal.MemberClassifier.GetNavigationCandidates(IConventionEntityType entityType)
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.RelationshipDiscoveryConvention.FindRelationshipCandidates(IConventionEntityTypeBuilder entityTypeBuilder, HashSet`1 otherInverseCandidateTypes)
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.RelationshipDiscoveryConvention.DiscoverRelationships(IConventionEntityTypeBuilder entityTypeBuilder, IConventionContext context, HashSet`1 otherInverseCandidateTypes)
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.ImmediateConventionScope.OnEntityTypeAdded(IConventionEntityTypeBuilder entityTypeBuilder)
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.OnEntityTypeAddedNode.Run(ConventionDispatcher dispatcher)
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.DelayedConventionScope.Run(ConventionDispatcher dispatcher)
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.ConventionBatch.Run()
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.ConventionBatch.Dispose()
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.ImmediateConventionScope.OnModelInitialized(IConventionModelBuilder modelBuilder)
   at Microsoft.EntityFrameworkCore.Metadata.Internal.Model..ctor(ConventionSet conventions, ModelDependencies modelDependencies, ModelConfiguration modelConfiguration)
   at Microsoft.EntityFrameworkCore.ModelBuilder..ctor(ConventionSet conventions, ModelDependencies modelDependencies, ModelConfiguration modelConfiguration)
   at Microsoft.EntityFrameworkCore.ModelConfigurationBuilder.CreateModelBuilder(ModelDependencies modelDependencies)
   at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.CreateModel(DbContext context, IConventionSetBuilder conventionSetBuilder, ModelDependencies modelDependencies)
   at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.GetModel(DbContext context, ModelCreationDependencies modelCreationDependencies, Boolean designTime)
   at Microsoft.EntityFrameworkCore.Internal.DbContextServices.CreateModel(Boolean designTime)
   at Microsoft.EntityFrameworkCore.Internal.DbContextServices.get_Model()
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite callSite, RuntimeResolverContext context)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.Resolve(ServiceCallSite callSite, ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass2_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
   at Microsoft.Extensions.DependencyInjection.ServiceProvider.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
   at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
   at Microsoft.EntityFrameworkCore.DbContext.get_ContextServices()
   at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
   at Microsoft.EntityFrameworkCore.DbContext.Set[TEntity]()

        return typeof(HierarchyId).IsAssignableFrom(clrType) || storeTypeName == SqlServerTypeName
            ? new SqlServerHierarchyIdTypeMapping(SqlServerTypeName, clrType ?? typeof(HierarchyId))
            : null;
    }

	var hier = HierarchyId.Parse("/2/");

	var h1 = HierarchyId.Parse("/2/1/");
	var h2 = HierarchyId.Parse("/2/2/");

	var h1a = hier.GetDescendant(h1, h2); // -> /2/1.1/
	var h1aa = hier.GetDescendant(h1, h1a); // -> /2/1.0/    -------- this throws exception
	var h1aaa = hier.GetDescendant(h1aa, h1a); // -> /2/1.0.1/

DECLARE @h HIERARCHYID;
DECLARE @h1 HIERARCHYID;
DECLARE @h2 HIERARCHYID;
DECLARE @h1a HIERARCHYID;
DECLARE @h1aa HIERARCHYID;
DECLARE @h1aaa HIERARCHYID;

SET @h = '/2/';
SET @h1 = '/2/1/';
SET @h2 = '/2/2/';
SET @h1a = @h.GetDescendant(@h1, @h2);
SET @h1aa = @h.GetDescendant(@h1, @h1a);
SET @h1aaa = @h.GetDescendant(@h1aa, @h1a);

SELECT @h1aa.ToString()   --/2/1.0/
SELECT @h1aaa.ToString() --/2/1.0.1/

public class Comment
{
    public long CommentId { get; set; }
    public HierarchyId CommentHierarchyId { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string Email { get; set; }
    public string Content { get; set; }
    public DateTimeOffset DateCreated { get; set; } = DateTimeOffset.Now;
    public DateTimeOffset DateModified { get; set; } = DateTimeOffset.Now;
}

public record CreateCommentDto
{
    [HiddenInput]
    public long ParentId { get; init; }
    public string FirstName { get; init; }
    public string LastName { get; init; }
    public string Email { get; init; }
    public string Content { get; init; }
}

Comment newComment = new()
{
    Email = createCommentDto.Email,
    FirstName = createCommentDto.FirstName,
    LastName = createCommentDto.LastName,
    Content = createCommentDto.Content,
};

if (createCommentDto.ParentId > 0)
{
    Comment parentComment = await _db.Comments.FindAsync(createCommentDto.ParentId);


    newComment.CommentHierarchyId =  parentComment.CommentHierarchyId.GetDescendant(null,null);
 /* I think these above line need to change. */
}
else
{
   newComment.CommentHierarchyId = HierarchyId.GetRoot();
}

await _db.Comments.AddAsync(newComment);
await _db.SaveChangesAsync();
return RedirectToAction(nameof(Index));

HierarchyId nullHid = null;
HierarchyId root = HierarchyId.GetRoot();

if (root == nullHid || root.Equals(nullHid) || Equals(root, nullHid) || nullHid == root || Equals(nullHid, root)) {
    Console.WriteLine("Wrong");
}

HierarchyId nullHid = null;
HierarchyId root = HierarchyId.GetRoot();

if (root < nullHid || nullHid > root) {
    Console.WriteLine("Wrong");
}

using System;
using System.IO;
using Microsoft.SqlServer.Types;

namespace Microsoft.EntityFrameworkCore
{
    /// <summary>
    /// Represents a position in a hierarchical structure, specifying depth and breadth.
    /// </summary>
    public class HierarchyId : IComparable
    {
        private SqlHierarchyId _value;

        private HierarchyId(SqlHierarchyId value)
        {
            if (value.IsNull)
                throw new ArgumentNullException(nameof(value));

            _value = value;
        }

        /// <summary>
        /// Gets the root node of the hierarchy.
        /// </summary>
        /// <returns>The root node of the hierarchy.</returns>
        public static HierarchyId GetRoot()
            => new HierarchyId(SqlHierarchyId.GetRoot());

        /// <summary>
        /// Converts the canonical string representation of a node to a <see cref="HierarchyId"/> value.
        /// </summary>
        /// <param name="input">The string representation of a node.</param>
        /// <returns>A <see cref="HierarchyId"/> value.</returns>
        public static HierarchyId Parse(string input)
            => Wrap(SqlHierarchyId.Parse(input));

        /// <summary>
        /// Reads a <see cref="HierarchyId"/> value from the specified reader.
        /// </summary>
        /// <param name="reader">The reader.</param>
        /// <returns>A <see cref="HierarchyId"/> value.</returns>
        public static HierarchyId Read(BinaryReader reader)
        {
            var hid = new SqlHierarchyId();
            hid.Read(reader);
            return Wrap(hid);
        }

        /// <summary>
        /// Writes this <see cref="HierarchyId"/> value to the specified writer.
        /// </summary>
        /// <param name="writer">The writer.</param>
        public void Write(BinaryWriter writer)
        {
            _value.Write(writer);
        }

        /// <inheritdoc/>
        public int CompareTo(object obj)
            => _value.CompareTo(
                    obj is HierarchyId other
                        ? other._value
                        : obj);

        /// <inheritdoc/>
        public override bool Equals(object obj)
            => _value.Equals(
                    obj is HierarchyId other
                        ? other._value
                        : obj);

        /// <summary>
        /// Gets the node <paramref name="n"/> levels up the hierarchical tree.
        /// </summary>
        /// <param name="n">The number of levels to ascend in the hierarchy.</param>
        /// <returns>A <see cref="HierarchyId"/> value represengint the <paramref name="n"/>th ancestor of this node or null if <paramref name="n"/> is greater than <see cref="GetLevel"/>.</returns>
        /// <exception cref="ArgumentOutOfRangeException"><paramref name="n"/> is negative.</exception>
        public HierarchyId GetAncestor(int n)
            => new HierarchyId(_value.GetAncestor(n));

        /// <summary>
        /// Gets the value of a descendant node that is greater than <paramref name="child1"/> and less than <paramref name="child2"/>.
        /// </summary>
        /// <param name="child1">The lower bound.</param>
        /// <param name="child2">The upper bound.</param>
        /// <returns>A <see cref="HierarchyId"/> value.</returns>
        public HierarchyId GetDescendant(HierarchyId child1, HierarchyId child2)
            => Wrap(_value.GetDescendant(Unwrap(child1), Unwrap(child2)));

        /// <inheritdoc/>
        public override int GetHashCode()
            => _value.GetHashCode();

        /// <summary>
        /// Gets the level of this node in the hierarchical tree.
        /// </summary>
        /// <returns>The depth of this node. The root node is level 0.</returns>
        public short GetLevel()
            => _value.GetLevel().Value;

        /// <summary>
        /// Gets a value representing the location of a new node that has a path from <paramref name="newRoot"/> equal to the path from <paramref name="oldRoot"/> to this, effectively moving this to the new location.
        /// </summary>
        /// <param name="oldRoot">An ancestor of this node specifying the endpoint of the path segment to be moved.</param>
        /// <param name="newRoot">The node that represents the new ancestor.</param>
        /// <returns>A <see cref="HierarchyId"/> value or null if <paramref name="oldRoot"/> or <paramref name="newRoot"/> is null.</returns>
        public HierarchyId GetReparentedValue(HierarchyId oldRoot, HierarchyId newRoot)
            => new HierarchyId(_value.GetReparentedValue(Unwrap(oldRoot), Unwrap(newRoot)));

        /// <summary>
        /// Gets a value indicating whether this node is a descendant of <paramref name="parent"/>.
        /// </summary>
        /// <param name="parent">The parent to test against.</param>
        /// <returns>True if this node is in the sub-tree rooted at <paramref name="parent"/>; otherwise false.</returns>
        public bool IsDescendantOf(HierarchyId parent)
        {
            if (parent == null)
                return false;

            return _value.IsDescendantOf(parent._value).Value;
        }

        /// <inheritdoc/>
        public override string ToString()
            => _value.ToString();

        /// <summary>
        /// Evaluates whether two nodes are equal.
        /// </summary>
        /// <param name="hid1">The first node to compare.</param>
        /// <param name="hid2">The second node to compare.</param>
        /// <returns>True if <paramref name="hid1"/> and <paramref name="hid2"/> are equal; otherwise, false.</returns>
        public static bool operator ==(HierarchyId hid1, HierarchyId hid2)
        {
            var sh1 = Unwrap(hid1);
            var sh2 = Unwrap(hid2);

            return sh1.IsNull == sh2.IsNull && sh1.CompareTo(sh2) == 0;
        }

        /// <summary>
        /// Evaluates whether two nodes are unequal.
        /// </summary>
        /// <param name="hid1">The first node to compare.</param>
        /// <param name="hid2">The second node to compare.</param>
        /// <returns>True if <paramref name="hid1"/> and <paramref name="hid2"/> are unequal; otherwise, false.</returns>
        public static bool operator !=(HierarchyId hid1, HierarchyId hid2)
        {
            var sh1 = Unwrap(hid1);
            var sh2 = Unwrap(hid2);

            return sh1.IsNull != sh2.IsNull || sh1.CompareTo(sh2) != 0;
        }

        /// <summary>
        /// Evaluates whether one node is less than another.
        /// </summary>
        /// <param name="hid1">The first node to compare.</param>
        /// <param name="hid2">The second node to compare.</param>
        /// <returns>True if <paramref name="hid1"/> is less than <paramref name="hid2"/>; otherwise, false.</returns>
        public static bool operator <(HierarchyId hid1, HierarchyId hid2)
        {
            var sh1 = Unwrap(hid1);
            var sh2 = Unwrap(hid2);

            if (sh1.IsNull == sh2.IsNull)
                return sh1.CompareTo(sh2) < 0;
            else if (sh1.IsNull)
                return true;

            return false;
        }

        /// <summary>
        /// Evaluates whether one node is greater than another.
        /// </summary>
        /// <param name="hid1">The first node to compare.</param>
        /// <param name="hid2">The second node to compare.</param>
        /// <returns>True if <paramref name="hid1"/> is greather than <paramref name="hid2"/>; otherwise, false.</returns>
        public static bool operator >(HierarchyId hid1, HierarchyId hid2)
        {
            var sh1 = Unwrap(hid1);
            var sh2 = Unwrap(hid2);

            if (sh1.IsNull == sh2.IsNull)
                return sh1.CompareTo(sh2) > 0;
            else if (sh1.IsNull)
                return false;

            return true;
        }

        /// <summary>
        /// Evaluates whether one node is less than or equal to another.
        /// </summary>
        /// <param name="hid1">The first node to compare.</param>
        /// <param name="hid2">The second node to compare.</param>
        /// <returns>True if <paramref name="hid1"/> is less than or equal to <paramref name="hid2"/>; otherwise, false.</returns>
        public static bool operator <=(HierarchyId hid1, HierarchyId hid2)
            => Unwrap(hid1).CompareTo(Unwrap(hid2)) <= 0;

        /// <summary>
        /// Evaluates whether one node is greater than or equal to another.
        /// </summary>
        /// <param name="hid1">The first node to compare.</param>
        /// <param name="hid2">The second node to compare.</param>
        /// <returns>True if <paramref name="hid1"/> is greater than or equal to <paramref name="hid2"/>; otherwise, false.</returns>
        public static bool operator >=(HierarchyId hid1, HierarchyId hid2)
            => Unwrap(hid1).CompareTo(Unwrap(hid2)) >= 0;

        private static SqlHierarchyId Unwrap(HierarchyId value)
            => value?._value ?? SqlHierarchyId.Null;

        private static HierarchyId Wrap(SqlHierarchyId value)
            => value.IsNull ? null : new HierarchyId(value);
    }
}

<PropertyGroup>
  <TargetFrameworks>netstandard2.0;net461</TargetFrameworks>
</PropertyGroup>

<ItemGroup>
  <PackageReference Include="EntityFrameworkCore.SqlServer.HierarchyId" Version="1.0.0" />
</ItemGroup>

info: EfCoreHierarchyIdTest.Worker[0]
      Worker running at: 06/11/2020 16:18:11 -07:00
info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
      Entity Framework Core 3.1.5 initialized 'JupiterContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using HierarchyId
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (76ms) [Parameters=[@__guid_0='?' (DbType = Guid)], CommandType='Text', CommandTimeout='30']
      SELECT [s].[path_locator], [s].[cached_file_size], [s].[creation_time], [s].[file_stream], [s].[is_archive], [s].[is_directory], [s].[is_hidden], [s].[is_offline], [s].[is_readonly], [s].[is_system], [s].[is_temporary], [s].[last_access_time], [s].[last_write_time], [s].[name], [s].[parent_path_locator], [s].[stream_id]
      FROM [5Binaries].[StoredFileTableData] AS [s]
      WHERE [s].[stream_id] = @__guid_0
fail: Microsoft.EntityFrameworkCore.Query[10100]
      An exception occurred while iterating over the results of a query for context type 'EfCoreHierarchyIdTest.EfContext.JupiterContext'.
      System.InvalidCastException: No pattern found for: 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010100110010001001101111110000000
         at Microsoft.SqlServer.Types.SqlHierarchy.KnownPatterns.GetPatternByPrefix(BitReader bitR)
         at Microsoft.SqlServer.Types.SqlHierarchyId.Read(BinaryReader r)
         at Microsoft.EntityFrameworkCore.HierarchyId.Read(BinaryReader reader)
         at Microsoft.EntityFrameworkCore.SqlServer.Storage.SqlServerHierarchyIdValueConverter.fromProvider(SqlBytes bytes)
         at lambda_method(Closure , QueryContext , DbDataReader , ResultContext , Int32[] , ResultCoordinator )
         at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
System.InvalidCastException: No pattern found for: 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010100110010001001101111110000000
   at Microsoft.SqlServer.Types.SqlHierarchy.KnownPatterns.GetPatternByPrefix(BitReader bitR)
   at Microsoft.SqlServer.Types.SqlHierarchyId.Read(BinaryReader r)
   at Microsoft.EntityFrameworkCore.HierarchyId.Read(BinaryReader reader)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.SqlServerHierarchyIdValueConverter.fromProvider(SqlBytes bytes)
   at lambda_method(Closure , QueryContext , DbDataReader , ResultContext , Int32[] , ResultCoordinator )
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()

	public partial class StoredFileTableDatum
	{
		public Guid stream_id { get; set; }
		public byte[] file_stream { get; set; }
		public string name { get; set; }
		public HierarchyId path_locator { get; set; }
		public HierarchyId parent_path_locator { get; set; }
		public string file_type { get; }
		public long cached_file_size { get; }
		public DateTimeOffset creation_time { get; set; }
		public DateTimeOffset last_write_time { get; set; }
		public DateTimeOffset last_access_time { get; set; }
		public bool is_directory { get; set; }
		public bool is_offline { get; set; }
		public bool is_hidden { get; set; }
		public bool is_readonly { get; set; }
		public bool is_archive { get; set; }
		public bool is_system { get; set; }
		public bool is_temporary { get; set; }

		public static string ConvertGuidToHierarchyId(Guid primaryKey)
		{
			var oBytes = new List<byte>(primaryKey.ToByteArray());
			oBytes.InsertRange(0, new byte[] { 0, 0 });
			oBytes.InsertRange(8, new byte[] { 0, 0 });
			oBytes.InsertRange(16, new byte[] { 0, 0, 0, 0 });

			var b1 = oBytes.Take(8).Reverse().ToArray();
			var b2 = oBytes.Skip(8).Take(8).Reverse().ToArray();
			var b3 = oBytes.Skip(16).Take(8).Reverse().ToArray();

			var sub1 = BitConverter.ToInt64(b1, 0);
			var sub2 = BitConverter.ToInt64(b2, 0);
			var sub3 = BitConverter.ToInt64(b3, 0);

			return string.Format(CultureInfo.InvariantCulture, "/{0}.{1}.{2}/", sub1, sub2, sub3);
		}
	}

	public sealed class StoredFileTableDatumConfiguration : IEntityTypeConfiguration<StoredFileTableDatum>
	{
		public void Configure(EntityTypeBuilder<StoredFileTableDatum> entity)
		{
			entity.ToTable("StoredFileTableData", "5Binaries");

			entity.HasKey(e => e.path_locator).IsClustered(false);

			entity.Property(e => e.stream_id).IsRequired();
			entity.Property(e => e.name).HasMaxLength(255).IsRequired();
			entity.Property(e => e.path_locator).IsRequired();
			entity.Property(e => e.parent_path_locator).ValueGeneratedOnAddOrUpdate();
			entity.Property(e => e.cached_file_size).ValueGeneratedOnAddOrUpdate();
		}
	}

        var first = HierarchyId.Parse("/0/");
        var second = HierarchyId.Parse("/1/");
        var parent = first.GetAncestor(1);

        var newNode = parent.GetDescendant(first, second);