Skip to main content
Published
Jun 10, 2025
1y ago
Total Downloads
33.8M
33,777,251

Install

dotnet add package Microsoft.EntityFrameworkCore.SqlServer.HierarchyId --version 8.0.17
ProductVersions
.NET
net8.0

README

Microsoft.EntityFrameworkCore.SqlServer.HierarchyId enables use of hierarchical data for SQL Server and Azure SQL with Entity Framework Core and NetTopologySuite.

Usage

Call UseHierarchyId inside the call to UseSqServer when configuring the SQLite database provider for your DbContext. For example:

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    => options.UseSqlServer(
        "Server=localhost;Database=MyDatabase;Trusted_Connection=True;",
        b => b.HierarchyId());

See Hierarchical Data in the SQL Server EF Core Provider for more information on HierarchyId with EF Core.

Getting started with EF Core

See Getting started with EF Core for more information about EF NuGet packages, including which to install when getting started.

Feedback

If you encounter a bug or issues with this package,you can open an Github issue. For more details, see getting support.

Changes from Previous Version

No structural changes between v8.0.16 and v8.0.17.

Adoption Assessment

A verified publisher signal is available. Assess fit from the package's supported frameworks, license and dependency graph rather than popularity alone.

Compatibility metadata lists 1 target framework; confirm the exact target used by your application.

Related Guides & Workflows

Learn how to evaluate, integrate, or audit this package in your .NET project.