Microsoft.EntityFrameworkCore.SqlServer.HierarchyId 9.0.0

Prefix Reserved

Requires NuGet 3.6 or higher.

dotnet add package Microsoft.EntityFrameworkCore.SqlServer.HierarchyId --version 9.0.0

NuGet\Install-Package Microsoft.EntityFrameworkCore.SqlServer.HierarchyId -Version 9.0.0

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer.HierarchyId" Version="9.0.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add Microsoft.EntityFrameworkCore.SqlServer.HierarchyId --version 9.0.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Microsoft.EntityFrameworkCore.SqlServer.HierarchyId, 9.0.0"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

// Install Microsoft.EntityFrameworkCore.SqlServer.HierarchyId as a Cake Addin
#addin nuget:?package=Microsoft.EntityFrameworkCore.SqlServer.HierarchyId&version=9.0.0

// Install Microsoft.EntityFrameworkCore.SqlServer.HierarchyId as a Cake Tool
#tool nuget:?package=Microsoft.EntityFrameworkCore.SqlServer.HierarchyId&version=9.0.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

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.

Product	Compatible and additional computed target framework versions.
.NET	net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net8.0
- Microsoft.Data.SqlClient (>= 5.1.6)
- Microsoft.EntityFrameworkCore.SqlServer (>= 9.0.0)
- Microsoft.EntityFrameworkCore.SqlServer.Abstractions (>= 9.0.0)
- Microsoft.Extensions.Caching.Memory (>= 9.0.0)
- Microsoft.Extensions.Configuration.Abstractions (>= 9.0.0)
- Microsoft.Extensions.Logging (>= 9.0.0)
- Microsoft.SqlServer.Types (>= 160.1000.6)
- System.Formats.Asn1 (>= 9.0.0)
- System.Text.Json (>= 9.0.0)

NuGet packages (10)

Showing the top 5 NuGet packages that depend on Microsoft.EntityFrameworkCore.SqlServer.HierarchyId:

Package	Downloads
EFCore.BulkExtensions.SqlServer EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server	1.9M
EFCore.BulkExtensions.MIT.SqlServer EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite	113.3K
EFCore.BulkExtensions.MIT EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite	45.4K
Youshow.Ace.Data 数据模块	26.1K
EFCore.BulkExtensions.MIT.MySQL EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite	8.8K

GitHub repositories (2)

Showing the top 2 popular GitHub repositories that depend on Microsoft.EntityFrameworkCore.SqlServer.HierarchyId:

Repository	Stars
borisdj/EFCore.BulkExtensions Entity Framework EF Core efcore Bulk Batch Extensions with BulkCopy in .Net for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, MySQL, SQLite	3.7K
ErikEJ/EFCorePowerTools Entity Framework Core Power Tools - reverse engineering, migrations and model visualization in Visual Studio & CLI	2.2K