Chuyển tới nội dung
Home » Nuget Entity Framework Core Sql Server | Get Entity Framework Core

Nuget Entity Framework Core Sql Server | Get Entity Framework Core

Setup MS SQL in ASP.NET Core with Entity Framework

Upgrading to the latest EF Core

  • Any time we release a new version of EF Core, we also release a new version of the providers that are part of the EF Core project, like Microsoft.EntityFrameworkCore.SqlServer, Microsoft.EntityFrameworkCore.Sqlite, Microsoft.EntityFrameworkCore.Cosmos, and Microsoft.EntityFrameworkCore.InMemory. You can just upgrade to the new version of the provider to get all the improvements.

  • If you need to update an application that is using a third-party database provider, always check for an update of the provider that is compatible with the version of EF Core you want to use. For example, database providers for version 1.0 are not compatible with version 2.0 of the EF Core runtime, and so on.

  • Third-party providers for EF Core usually don’t release patch versions alongside the EF Core runtime. To upgrade an application that uses a third-party provider to a patch version of EF Core, you may need to add a direct reference to individual EF Core runtime components, most notably Microsoft.EntityFrameworkCore, and Microsoft.EntityFrameworkCore.Relational.

Extension packages

\n

There are many extensions for EF Core published both by Microsoft and third parties as NuGet packages. Commonly used packages include:

\n\n\n\nFunctionality\nPackage\nAdditional dependencies\n\n\n\n\nProxies for lazy-loading and change tracking\n

Microsoft.EntityFrameworkCore.Proxies

\n

Castle.Core

\n\n\nSpatial support for SQL Server\n

Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite

\n

NetTopologySuite

and

NetTopologySuite.IO.SqlServerBytes

\n\n\nSpatial support for SQLite\n

Microsoft.EntityFrameworkCore.Sqlite.NetTopologySuite

\n

NetTopologySuite

and

NetTopologySuite.IO.SpatiaLite

\n\n\nSpatial support for PostgreSQL\n

Npgsql.EntityFrameworkCore.PostgreSQL.NetTopologySuite

\n

NetTopologySuite

and

NetTopologySuite.IO.PostGIS

(via

Npgsql.NetTopologySuite

)\n\n\nSpatial support for MySQL\n

Pomelo.EntityFrameworkCore.MySql.NetTopologySuite

\n

NetTopologySuite

\n\n\n\n

Setup MS SQL in ASP.NET Core with Entity Framework
Setup MS SQL in ASP.NET Core with Entity Framework

Prerequisites

  • EF requires the most recent .NET SDK.

    • At runtime, EF Core requires a recent version of .NET. See EF Core releases to find the minimal .NET version needed for the version of EF Core that you want to use.
  • You can use EF Core to develop applications on Windows using Visual Studio. The latest version of Visual Studio is recommended.

Tools

\n

Use of tooling for EF Core migrations and reverse engineering (scaffolding) from an existing database requires installation of the appropriate tooling package:

\n

\n

See Entity Framework Core Tools Reference for more information on using EF Core tooling, including how to correctly install the

dotnet-ef

tool in a project or globally.

\n

Tip

By default, the Microsoft.EntityFrameworkCore.Design package is installed in such a way that it will not be deployed with your application. This also means that its types cannot be transitively used in other projects. Use a normal

PackageReference

in your

.csproj

file or equivalent if you need access to the types in this package. See Design-time services for more information.

\n

\n

Entity Framework with MySql
Entity Framework with MySql

Prerequisites

  • EF requires the most recent .NET SDK.

    • At runtime, EF Core requires a recent version of .NET. See EF Core releases to find the minimal .NET version needed for the version of EF Core that you want to use.
  • You can use EF Core to develop applications on Windows using Visual Studio. The latest version of Visual Studio is recommended.

Packages for database provider testing

\n

The following packages are used to test database providers built in external GitHub repositories. See

efcore.pg

and

Pomelo.EntityFrameworkCore.MySql

for examples. Applications should not install these packages.

\n\n\n\nFunctionality\nPackage\n\n\n\n\nTests for any database provider\n

Microsoft.EntityFrameworkCore.Specification.Tests

\n\n\nTests for relational database providers\n

Microsoft.EntityFrameworkCore.Relational.Specification.Tests

\n\n\n\n

Install entity framework core in visual studio
Install entity framework core in visual studio

Obsolete packages

\n

Do

not

install the following obsolete packages, and remove them if they are currently installed in your projects:

\n

    \n

  • Microsoft.EntityFrameworkCore.Relational.Design
  • \n

  • Microsoft.EntityFrameworkCore.Tools.DotNet
  • \n

  • Microsoft.EntityFrameworkCore.SqlServer.Design
  • \n

  • Microsoft.EntityFrameworkCore.Sqlite.Design
  • \n

  • Microsoft.EntityFrameworkCore.Relational.Design.Specification.Tests
  • \n

\n

“,”renderedFileInfo”:null,”shortPath”:null,”symbolsEnabled”:true,”tabSize”:8,”topBannersInfo”:{“overridingGlobalFundingFile”:false,”globalPreferredFundingPath”:null,”repoOwner”:”dotnet”,”repoName”:”EntityFramework.Docs”,”showInvalidCitationWarning”:false,”citationHelpUrl”:”https://docs.github.com/github/creating-cloning-and-archiving-repositories/creating-a-repository-on-github/about-citation-files”,”showDependabotConfigurationBanner”:false,”actionsOnboardingTip”:null},”truncated”:false,”viewable”:true,”workflowRedirectUrl”:null,”symbols”:{“timed_out”:false,”not_analyzed”:false,”symbols”:[{“name”:”EF Core NuGet Packages”,”kind”:”section_1″,”ident_start”:193,”ident_end”:215,”extent_start”:191,”extent_end”:9700,”fully_qualified_name”:”EF Core NuGet Packages”,”ident_utf16″:{“start”:{“line_number”:8,”utf16_col”:2},”end”:{“line_number”:8,”utf16_col”:24}},”extent_utf16″:{“start”:{“line_number”:8,”utf16_col”:0},”end”:{“line_number”:105,”utf16_col”:0}}},{“name”:”Package versions”,”kind”:”section_2″,”ident_start”:1283,”ident_end”:1299,”extent_start”:1280,”extent_end”:1998,”fully_qualified_name”:”Package versions”,”ident_utf16″:{“start”:{“line_number”:23,”utf16_col”:3},”end”:{“line_number”:23,”utf16_col”:19}},”extent_utf16″:{“start”:{“line_number”:23,”utf16_col”:0},”end”:{“line_number”:32,”utf16_col”:0}}},{“name”:”Database providers”,”kind”:”section_2″,”ident_start”:2001,”ident_end”:2019,”extent_start”:1998,”extent_end”:3736,”fully_qualified_name”:”Database providers”,”ident_utf16″:{“start”:{“line_number”:32,”utf16_col”:3},”end”:{“line_number”:32,”utf16_col”:21}},”extent_utf16″:{“start”:{“line_number”:32,”utf16_col”:0},”end”:{“line_number”:51,”utf16_col”:0}}},{“name”:”Tools”,”kind”:”section_2″,”ident_start”:3739,”ident_end”:3744,”extent_start”:3736,”extent_end”:5070,”fully_qualified_name”:”Tools”,”ident_utf16″:{“start”:{“line_number”:51,”utf16_col”:3},”end”:{“line_number”:51,”utf16_col”:8}},”extent_utf16″:{“start”:{“line_number”:51,”utf16_col”:0},”end”:{“line_number”:63,”utf16_col”:0}}},{“name”:”Extension packages”,”kind”:”section_2″,”ident_start”:5073,”ident_end”:5091,”extent_start”:5070,”extent_end”:7091,”fully_qualified_name”:”Extension packages”,”ident_utf16″:{“start”:{“line_number”:63,”utf16_col”:3},”end”:{“line_number”:63,”utf16_col”:21}},”extent_utf16″:{“start”:{“line_number”:63,”utf16_col”:0},”end”:{“line_number”:75,”utf16_col”:0}}},{“name”:”Other packages”,”kind”:”section_2″,”ident_start”:7094,”ident_end”:7108,”extent_start”:7091,”extent_end”:8372,”fully_qualified_name”:”Other packages”,”ident_utf16″:{“start”:{“line_number”:75,”utf16_col”:3},”end”:{“line_number”:75,”utf16_col”:17}},”extent_utf16″:{“start”:{“line_number”:75,”utf16_col”:0},”end”:{“line_number”:87,”utf16_col”:0}}},{“name”:”Packages for database provider testing”,”kind”:”section_2″,”ident_start”:8375,”ident_end”:8413,”extent_start”:8372,”extent_end”:9299,”fully_qualified_name”:”Packages for database provider testing”,”ident_utf16″:{“start”:{“line_number”:87,”utf16_col”:3},”end”:{“line_number”:87,”utf16_col”:41}},”extent_utf16″:{“start”:{“line_number”:87,”utf16_col”:0},”end”:{“line_number”:96,”utf16_col”:0}}},{“name”:”Obsolete packages”,”kind”:”section_2″,”ident_start”:9302,”ident_end”:9319,”extent_start”:9299,”extent_end”:9700,”fully_qualified_name”:”Obsolete packages”,”ident_utf16″:{“start”:{“line_number”:96,”utf16_col”:3},”end”:{“line_number”:96,”utf16_col”:20}},”extent_utf16″:{“start”:{“line_number”:96,”utf16_col”:0},”end”:{“line_number”:105,”utf16_col”:0}}}]}},”copilotInfo”:null,”copilotAccessAllowed”:false,”csrf_tokens”:{“/dotnet/EntityFramework.Docs/branches”:{“post”:”SJnlaGRDw8dlGbZ0DU5Hz9asPo7FujXoKYzo-KWu9A9HzmHjpl_shbQr5xWz5XU2sLTqUb1svI6rzznzwWIygA”},”/repos/preferences”:{“post”:”C3Kfk3ynFIQINEBQEmNC-gMk5ecd4j25lQ5GPAePKLFDW5g1v_e6WuC40ItV5EKONBEC1fZQ5DA54PjA-K9n1A”}}},”title”:”EntityFramework.Docs/entity-framework/core/what-is-new/nuget-packages.md at main · dotnet/EntityFramework.Docs”}

\n \n \n title\n description\n author\n ms.date\n uid\n \n \n \n \n

EF Core NuGet Packages

\n

Overview of the different Entity Framework Core NuGet packages

\n

ajcvickers

\n

01/21/2021

\n

core/what-is-new/nuget-packages

\n \n \n\n\n

EF Core NuGet Packages

\n

Entity Framework Core (EF Core) is shipped as

NuGet

packages. The packages needed by an application depends on:

\n

    \n

  • The type of database system being used (SQL Server, SQLite, etc.)
  • \n

  • The EF Core features needed
  • \n

\n

The usual process for installing packages is:

\n

    \n

  • Decide on a database provider and install the appropriate package (

    see below

    )
  • \n

  • Also install

    Microsoft.EntityFrameworkCore

    , and

    Microsoft.EntityFrameworkCore.Relational

    if using a relational database provider. This helps ensure that consistent versions are being used, and also means that NuGet will let you know when new package versions are shipped.
  • \n

  • Optionally, decide which kind of tooling you need and install the appropriate packages for that (

    see below

    )
  • \n

\n

See Getting started tutorial for Entity Framework Core for help getting started with EF Core.

\n

Obsolete packages

\n

Do

not

install the following obsolete packages, and remove them if they are currently installed in your projects:

\n

    \n

  • Microsoft.EntityFrameworkCore.Relational.Design
  • \n

  • Microsoft.EntityFrameworkCore.Tools.DotNet
  • \n

  • Microsoft.EntityFrameworkCore.SqlServer.Design
  • \n

  • Microsoft.EntityFrameworkCore.Sqlite.Design
  • \n

  • Microsoft.EntityFrameworkCore.Relational.Design.Specification.Tests
  • \n

\n

“,”renderedFileInfo”:null,”shortPath”:null,”symbolsEnabled”:true,”tabSize”:8,”topBannersInfo”:{“overridingGlobalFundingFile”:false,”globalPreferredFundingPath”:null,”repoOwner”:”dotnet”,”repoName”:”EntityFramework.Docs”,”showInvalidCitationWarning”:false,”citationHelpUrl”:”https://docs.github.com/github/creating-cloning-and-archiving-repositories/creating-a-repository-on-github/about-citation-files”,”showDependabotConfigurationBanner”:false,”actionsOnboardingTip”:null},”truncated”:false,”viewable”:true,”workflowRedirectUrl”:null,”symbols”:{“timed_out”:false,”not_analyzed”:false,”symbols”:[{“name”:”EF Core NuGet Packages”,”kind”:”section_1″,”ident_start”:193,”ident_end”:215,”extent_start”:191,”extent_end”:9700,”fully_qualified_name”:”EF Core NuGet Packages”,”ident_utf16″:{“start”:{“line_number”:8,”utf16_col”:2},”end”:{“line_number”:8,”utf16_col”:24}},”extent_utf16″:{“start”:{“line_number”:8,”utf16_col”:0},”end”:{“line_number”:105,”utf16_col”:0}}},{“name”:”Package versions”,”kind”:”section_2″,”ident_start”:1283,”ident_end”:1299,”extent_start”:1280,”extent_end”:1998,”fully_qualified_name”:”Package versions”,”ident_utf16″:{“start”:{“line_number”:23,”utf16_col”:3},”end”:{“line_number”:23,”utf16_col”:19}},”extent_utf16″:{“start”:{“line_number”:23,”utf16_col”:0},”end”:{“line_number”:32,”utf16_col”:0}}},{“name”:”Database providers”,”kind”:”section_2″,”ident_start”:2001,”ident_end”:2019,”extent_start”:1998,”extent_end”:3736,”fully_qualified_name”:”Database providers”,”ident_utf16″:{“start”:{“line_number”:32,”utf16_col”:3},”end”:{“line_number”:32,”utf16_col”:21}},”extent_utf16″:{“start”:{“line_number”:32,”utf16_col”:0},”end”:{“line_number”:51,”utf16_col”:0}}},{“name”:”Tools”,”kind”:”section_2″,”ident_start”:3739,”ident_end”:3744,”extent_start”:3736,”extent_end”:5070,”fully_qualified_name”:”Tools”,”ident_utf16″:{“start”:{“line_number”:51,”utf16_col”:3},”end”:{“line_number”:51,”utf16_col”:8}},”extent_utf16″:{“start”:{“line_number”:51,”utf16_col”:0},”end”:{“line_number”:63,”utf16_col”:0}}},{“name”:”Extension packages”,”kind”:”section_2″,”ident_start”:5073,”ident_end”:5091,”extent_start”:5070,”extent_end”:7091,”fully_qualified_name”:”Extension packages”,”ident_utf16″:{“start”:{“line_number”:63,”utf16_col”:3},”end”:{“line_number”:63,”utf16_col”:21}},”extent_utf16″:{“start”:{“line_number”:63,”utf16_col”:0},”end”:{“line_number”:75,”utf16_col”:0}}},{“name”:”Other packages”,”kind”:”section_2″,”ident_start”:7094,”ident_end”:7108,”extent_start”:7091,”extent_end”:8372,”fully_qualified_name”:”Other packages”,”ident_utf16″:{“start”:{“line_number”:75,”utf16_col”:3},”end”:{“line_number”:75,”utf16_col”:17}},”extent_utf16″:{“start”:{“line_number”:75,”utf16_col”:0},”end”:{“line_number”:87,”utf16_col”:0}}},{“name”:”Packages for database provider testing”,”kind”:”section_2″,”ident_start”:8375,”ident_end”:8413,”extent_start”:8372,”extent_end”:9299,”fully_qualified_name”:”Packages for database provider testing”,”ident_utf16″:{“start”:{“line_number”:87,”utf16_col”:3},”end”:{“line_number”:87,”utf16_col”:41}},”extent_utf16″:{“start”:{“line_number”:87,”utf16_col”:0},”end”:{“line_number”:96,”utf16_col”:0}}},{“name”:”Obsolete packages”,”kind”:”section_2″,”ident_start”:9302,”ident_end”:9319,”extent_start”:9299,”extent_end”:9700,”fully_qualified_name”:”Obsolete packages”,”ident_utf16″:{“start”:{“line_number”:96,”utf16_col”:3},”end”:{“line_number”:96,”utf16_col”:20}},”extent_utf16″:{“start”:{“line_number”:96,”utf16_col”:0},”end”:{“line_number”:105,”utf16_col”:0}}}]}},”copilotInfo”:null,”copilotAccessAllowed”:false,”csrf_tokens”:{“/dotnet/EntityFramework.Docs/branches”:{“post”:”SJnlaGRDw8dlGbZ0DU5Hz9asPo7FujXoKYzo-KWu9A9HzmHjpl_shbQr5xWz5XU2sLTqUb1svI6rzznzwWIygA”},”/repos/preferences”:{“post”:”C3Kfk3ynFIQINEBQEmNC-gMk5ecd4j25lQ5GPAePKLFDW5g1v_e6WuC40ItV5EKONBEC1fZQ5DA54PjA-K9n1A”}}},”title”:”EntityFramework.Docs/entity-framework/core/what-is-new/nuget-packages.md at main · dotnet/EntityFramework.Docs”}

Microsoft SQL Server database provider for Entity Framework Core.

Learn Entity Framework Core: https://www.learnentityframeworkcore.com/

Entity Framework Core Tutorial: https://entityframeworkcore.com/

Entity Framework 6 Tutorial: https://entityframework.net/

Info
Version: 9.0.0-preview.1.24081.2
Author(s): Microsoft
Last Update: Tuesday, February 13, 2024
.NET Fiddle: Online Example
Project Url: https://docs.microsoft.com/ef/core/
NuGet Url: https://www.nuget.org/packages/Microsoft.EntityFrameworkCore.SqlServer
Install


Install-Package Microsoft.EntityFrameworkCore.SqlServer


dotnet add package Microsoft.EntityFrameworkCore.SqlServer


paket add Microsoft.EntityFrameworkCore.SqlServer


Microsoft.EntityFrameworkCore.SqlServer Download (Unzip the "nupkg" after downloading)

Dependencies
  • Microsoft.EntityFrameworkCore.Relational(>= 5.0.2)
  • Microsoft.Data.SqlClient(>= 2.0.1)
Tags
  • Core
  • Data
  • EF
  • EFCore
  • Entity
  • EntityFramework
  • EntityFrameworkCore
  • entity-framework-core
  • Framework
  • O/RM
  • SQL
  • Server
Getting Started with Entity Framework Core [1 of 5] | Entity Framework Core for Beginners
Getting Started with Entity Framework Core [1 of 5] | Entity Framework Core for Beginners

Other packages

\n

Other EF Core packages are pulled in as dependencies of the database provider package. However, you may want to add explicit package references for these packages so that NuGet will provide notifications when new versions are released.

\n\n\n\nFunctionality\nPackage\n\n\n\n\nEF Core basic functionality\n

Microsoft.EntityFrameworkCore

\n\n\nCommon relational database functionality\n

Microsoft.EntityFrameworkCore.Relational

\n\n\nLightweight package for EF Core attributes, etc.\n

Microsoft.EntityFrameworkCore.Abstractions

\n\n\nRoslyn code analyzers for EF Core usage\n

Microsoft.EntityFrameworkCore.Analyzers

\n\n\nEF Core SQLite provider without a native SQLite dependency\n

Microsoft.EntityFrameworkCore.Sqlite.Core

\n\n\n\n

Package versions

\n

Make sure to install the same version of all EF Core packages shipped by Microsoft. For example, if version 5.0.3 of Microsoft.EntityFrameworkCore.SqlServer is installed, then all other Microsoft.EntityFrameworkCore.* packages must also be at 5.0.3.

\n

Also make sure that any external packages are compatible with the version of EF Core being used. In particular, check that external database provider supports the version of EF Core you are using. New major versions of EF Core usually require an updated database provider.

\n

Warning

NuGet does not enforce consistent package versions. Always carefully check which package versions you are referencing in your

.csproj

file or equivalent.

\n

\n

.NET 7 & Entity Framework 7: Mastering ALL Database Relationships (1:1, 1:n, n:n) with SQL Server 🚀
.NET 7 & Entity Framework 7: Mastering ALL Database Relationships (1:1, 1:n, n:n) with SQL Server 🚀

Extension packages

\n

There are many extensions for EF Core published both by Microsoft and third parties as NuGet packages. Commonly used packages include:

\n\n\n\nFunctionality\nPackage\nAdditional dependencies\n\n\n\n\nProxies for lazy-loading and change tracking\n

Microsoft.EntityFrameworkCore.Proxies

\n

Castle.Core

\n\n\nSpatial support for SQL Server\n

Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite

\n

NetTopologySuite

and

NetTopologySuite.IO.SqlServerBytes

\n\n\nSpatial support for SQLite\n

Microsoft.EntityFrameworkCore.Sqlite.NetTopologySuite

\n

NetTopologySuite

and

NetTopologySuite.IO.SpatiaLite

\n\n\nSpatial support for PostgreSQL\n

Npgsql.EntityFrameworkCore.PostgreSQL.NetTopologySuite

\n

NetTopologySuite

and

NetTopologySuite.IO.PostGIS

(via

Npgsql.NetTopologySuite

)\n\n\nSpatial support for MySQL\n

Pomelo.EntityFrameworkCore.MySql.NetTopologySuite

\n

NetTopologySuite

\n\n\n\n

Get Entity Framework Core

EF Core is shipped as NuGet packages. To add EF Core to an application, install the NuGet package for the database provider you want to use. See Providers for a list of the database providers available.

To install or update NuGet packages, you can use the .NET Core command-line interface (CLI), the Visual Studio Package Manager Dialog, or the Visual Studio Package Manager Console.

.NET Core CLI

  • Use the following .NET Core CLI command from the operating system’s command line to install or update the EF Core SQL Server provider:


    dotnet add package Microsoft.EntityFrameworkCore.SqlServer

  • You can indicate a specific version in the


    dotnet add package

    command, using the

    -v

    modifier. For example, to install EF Core 6.0.14 packages, append

    -v 6.0.14

    to the command.

For more information, see .NET command-line interface (CLI) tools.

Visual Studio NuGet Package Manager Dialog

  • From the Visual Studio menu, select Project > Manage NuGet Packages

  • Click on the Browse or the Updates tab

  • To install or update the SQL Server provider, select the


    Microsoft.EntityFrameworkCore.SqlServer

    package, and confirm.

For more information, see NuGet Package Manager Dialog.

Visual Studio NuGet Package Manager Console

  • From the Visual Studio menu, select Tools > NuGet Package Manager > Package Manager Console

  • To install the SQL Server provider, run the following command in the Package Manager Console:


    Install-Package Microsoft.EntityFrameworkCore.SqlServer

  • To update the provider, use the


    Update-Package

    command.

  • To specify a specific version, use the


    -Version

    modifier. For example, to install EF Core 6.0.14 packages, append

    -Version 6.0.14

    to the commands

For more information, see Package Manager Console.

Asp.Net Core 6: Connect To Sql Server Database With Entity Framework Using C#
Asp.Net Core 6: Connect To Sql Server Database With Entity Framework Using C#

Package versions

\n

Make sure to install the same version of all EF Core packages shipped by Microsoft. For example, if version 5.0.3 of Microsoft.EntityFrameworkCore.SqlServer is installed, then all other Microsoft.EntityFrameworkCore.* packages must also be at 5.0.3.

\n

Also make sure that any external packages are compatible with the version of EF Core being used. In particular, check that external database provider supports the version of EF Core you are using. New major versions of EF Core usually require an updated database provider.

\n

Warning

NuGet does not enforce consistent package versions. Always carefully check which package versions you are referencing in your

.csproj

file or equivalent.

\n

\n

Database providers

\n

EF Core supports different database systems through the use of \”database providers\”. Each system has its own database provider, which is shipped as NuGet package. Applications should install one or more of these provider packages.

\n

Common database providers are listed in the table below. See database providers for a more comprehensive list of available providers.

\n\n\n\nDatabase system\nPackage\n\n\n\n\nSQL Server and SQL Azure\n

Microsoft.EntityFrameworkCore.SqlServer

\n\n\nSQLite\n

Microsoft.EntityFrameworkCore.Sqlite

\n\n\nAzure Cosmos DB\n

Microsoft.EntityFrameworkCore.Cosmos

\n\n\nPostgreSQL\n

Npgsql.EntityFrameworkCore.PostgreSQL

*\n\n\nMySQL\n

Pomelo.EntityFrameworkCore.MySql

*\n\n\nEF Core in-memory database**\n

Microsoft.EntityFrameworkCore.InMemory

\n\n\n\n

*These are popular, high quality, open-source providers developed and shipped by the community. The other providers listed are shipped by Microsoft.

\n

**Carefully consider whether to use the in-memory provider. It is not designed for production use, and also may not be the best solution for testing.

\n

Execute store procedure and SQL queries in entity framework core 7.0 | SP handling in EF Core 7.0
Execute store procedure and SQL queries in entity framework core 7.0 | SP handling in EF Core 7.0

Other packages

\n

Other EF Core packages are pulled in as dependencies of the database provider package. However, you may want to add explicit package references for these packages so that NuGet will provide notifications when new versions are released.

\n\n\n\nFunctionality\nPackage\n\n\n\n\nEF Core basic functionality\n

Microsoft.EntityFrameworkCore

\n\n\nCommon relational database functionality\n

Microsoft.EntityFrameworkCore.Relational

\n\n\nLightweight package for EF Core attributes, etc.\n

Microsoft.EntityFrameworkCore.Abstractions

\n\n\nRoslyn code analyzers for EF Core usage\n

Microsoft.EntityFrameworkCore.Analyzers

\n\n\nEF Core SQLite provider without a native SQLite dependency\n

Microsoft.EntityFrameworkCore.Sqlite.Core

\n\n\n\n

Get the Entity Framework Core tools

You can install tools to carry out EF Core-related tasks in your project, like creating and applying database migrations, or creating an EF Core model based on an existing database.

Two sets of tools are available:

  • The .NET Core command-line interface (CLI) tools can be used on Windows, Linux, or macOS. These commands begin with


    dotnet ef

    .

  • The Package Manager Console (PMC) tools run in Visual Studio on Windows. These commands start with a verb, for example


    Add-Migration

    ,

    Update-Database

    .

Get the .NET Core CLI tools

.NET Core CLI tools require the .NET Core SDK, mentioned earlier in Prerequisites.


  • dotnet ef

    must be installed as a global or local tool. Most developers prefer installing

    dotnet ef

    as a global tool using the following command:

    dotnet tool install --global dotnet-ef


    dotnet ef

    can also be used as a local tool. To use it as a local tool, restore the dependencies of a project that declares it as a tooling dependency using a tool manifest file.
  • To update the tools, use the


    dotnet tool update

    command.

  • Install the latest


    Microsoft.EntityFrameworkCore.Design

    package.

    dotnet add package Microsoft.EntityFrameworkCore.Design

Important

Always use the version of the tools package that matches the major version of the runtime packages.

Get the Package Manager Console tools

To get the Package Manager Console tools for EF Core, install the

Microsoft.EntityFrameworkCore.Tools

package. For example, from Visual Studio:


Install-Package Microsoft.EntityFrameworkCore.Tools

.NET 8 Web API & Entity Framework 🚀 Full CRUD Course (with Code-First Migrations & SQL Server)
.NET 8 Web API & Entity Framework 🚀 Full CRUD Course (with Code-First Migrations & SQL Server)

Database providers

\n

EF Core supports different database systems through the use of \”database providers\”. Each system has its own database provider, which is shipped as NuGet package. Applications should install one or more of these provider packages.

\n

Common database providers are listed in the table below. See database providers for a more comprehensive list of available providers.

\n\n\n\nDatabase system\nPackage\n\n\n\n\nSQL Server and SQL Azure\n

Microsoft.EntityFrameworkCore.SqlServer

\n\n\nSQLite\n

Microsoft.EntityFrameworkCore.Sqlite

\n\n\nAzure Cosmos DB\n

Microsoft.EntityFrameworkCore.Cosmos

\n\n\nPostgreSQL\n

Npgsql.EntityFrameworkCore.PostgreSQL

*\n\n\nMySQL\n

Pomelo.EntityFrameworkCore.MySql

*\n\n\nEF Core in-memory database**\n

Microsoft.EntityFrameworkCore.InMemory

\n\n\n\n

*These are popular, high quality, open-source providers developed and shipped by the community. The other providers listed are shipped by Microsoft.

\n

**Carefully consider whether to use the in-memory provider. It is not designed for production use, and also may not be the best solution for testing.

\n

Tools

\n

Use of tooling for EF Core migrations and reverse engineering (scaffolding) from an existing database requires installation of the appropriate tooling package:

\n

\n

See Entity Framework Core Tools Reference for more information on using EF Core tooling, including how to correctly install the

dotnet-ef

tool in a project or globally.

\n

Tip

By default, the Microsoft.EntityFrameworkCore.Design package is installed in such a way that it will not be deployed with your application. This also means that its types cannot be transitively used in other projects. Use a normal

PackageReference

in your

.csproj

file or equivalent if you need access to the types in this package. See Design-time services for more information.

\n

\n

How to implement Entity Framework Core and Stored procedure CRUD Operation in ASP.NET Core
How to implement Entity Framework Core and Stored procedure CRUD Operation in ASP.NET Core

Microsoft.EntityFrameworkCore.SqlServer

8.0.2

See the version list below for details.

Requires NuGet 3.6 or higher.

dotnet add package Microsoft.EntityFrameworkCore.SqlServer –version 8.0.2

NuGet\Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 8.0.2

paket add Microsoft.EntityFrameworkCore.SqlServer –version 8.0.2

#r “nuget: Microsoft.EntityFrameworkCore.SqlServer, 8.0.2”

// Install Microsoft.EntityFrameworkCore.SqlServer as a Cake Addin #addin nuget:?package=Microsoft.EntityFrameworkCore.SqlServer&version=8.0.2 // Install Microsoft.EntityFrameworkCore.SqlServer as a Cake Tool #tool nuget:?package=Microsoft.EntityFrameworkCore.SqlServer&version=8.0.2

Microsoft SQL Server database provider for Entity Framework Core.

Product Versions 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.
  • net8.0
    • Microsoft.Data.SqlClient (>= 5.1.4)
    • Microsoft.EntityFrameworkCore.Relational (>= 8.0.2)

NuGet packages (3.1K)

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

Package Downloads
Microsoft.AspNetCore.App

Provides a default set of APIs for building an ASP.NET Core application. This package requires the ASP.NET Core runtime. This runtime is installed by the .NET Core SDK, or can be acquired separately using installers available at https://aka.ms/dotnet-download.

Microsoft.AspNetCore.All

Provides a default set of APIs for building an ASP.NET Core application, and also includes API for third-party integrations with ASP.NET Core. This package requires the ASP.NET Core runtime. This runtime is installed by the .NET Core SDK, or can be acquired separately using installers available at https://aka.ms/dotnet-download.

Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite

NetTopologySuite support for the Microsoft SQL Server database provider for Entity Framework Core.

EntityFrameworkCore.SqlServer.HierarchyId

Adds hierarchyid support to the SQL Server EF Core provider

Microsoft.EntityFrameworkCore.SqlServer.Design

Design-time Entity Framework Core Functionality for Microsoft SQL Server.

GitHub repositories (542)

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

Repository Stars
dotnet/aspnetcore

ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.

DapperLib/Dapper

Dapper – a simple object mapper for .Net

jasontaylordev/CleanArchitecture

Clean Architecture Solution Template for ASP.NET Core

ardalis/CleanArchitecture

Clean Architecture Solution Template: A starting point for Clean Architecture with ASP.NET Core

bitwarden/server

The core infrastructure backend (API, database, Docker, etc).

Version Downloads Last updated
9.0.0-preview.1.24081.2 1,381 2/13/2024
8.0.2 63,295 2/13/2024
8.0.1 1,353,199 1/9/2024
8.0.0 2,391,697 11/14/2023
8.0.0-rc.2.23480.1 80,475 10/10/2023
8.0.0-rc.1.23419.6 53,139 9/12/2023
8.0.0-preview.7.23375.4 37,528 8/8/2023
8.0.0-preview.6.23329.4 48,711 7/11/2023
8.0.0-preview.5.23280.1 40,016 6/13/2023
8.0.0-preview.4.23259.3 29,705 5/16/2023
8.0.0-preview.3.23174.2 43,460 4/11/2023
8.0.0-preview.2.23128.3 78,228 3/14/2023
8.0.0-preview.1.23111.4 30,905 2/21/2023
7.0.16 19,521 2/13/2024
7.0.15 429,668 1/9/2024
7.0.14 1,209,093 11/14/2023
7.0.13 1,622,128 10/24/2023
7.0.12 1,209,886 10/10/2023
7.0.11 2,492,615 9/12/2023
7.0.10 3,138,156 8/8/2023
7.0.9 2,669,781 7/11/2023
7.0.8 1,795,502 6/22/2023
7.0.7 1,616,976 6/13/2023
7.0.5 7,488,764 4/11/2023
7.0.4 3,290,558 3/14/2023
7.0.3 4,142,214 2/14/2023
7.0.2 4,563,757 1/10/2023
7.0.1 2,768,449 12/13/2022
7.0.0 6,008,394 11/7/2022
7.0.0-rc.2.22472.11 87,815 10/11/2022
7.0.0-rc.1.22426.7 122,425 9/14/2022
7.0.0-preview.7.22376.2 30,550 8/9/2022
7.0.0-preview.6.22329.4 29,657 7/12/2022
7.0.0-preview.5.22302.2 23,277 6/14/2022
7.0.0-preview.4.22229.2 29,514 5/10/2022
7.0.0-preview.3.22175.1 42,519 4/13/2022
7.0.0-preview.2.22153.1 20,703 3/14/2022
7.0.0-preview.1.22076.6 23,916 2/17/2022
6.0.27 14,957 2/13/2024
6.0.26 311,423 1/9/2024
6.0.25 657,592 11/14/2023
6.0.24 429,763 10/24/2023
6.0.23 354,145 10/10/2023
6.0.22 688,803 9/12/2023
6.0.21 1,015,185 8/8/2023
6.0.20 886,951 7/11/2023
6.0.19 807,530 6/22/2023
6.0.18 404,848 6/13/2023
6.0.16 2,602,376 4/11/2023
6.0.15 1,598,983 3/14/2023
6.0.14 1,719,683 2/14/2023
6.0.13 2,869,613 1/10/2023
6.0.12 2,053,355 12/13/2022
6.0.11 4,182,546 11/7/2022
6.0.10 6,967,000 10/11/2022
6.0.9 6,638,798 9/13/2022
6.0.8 7,367,873 8/9/2022
6.0.7 7,083,696 7/12/2022
6.0.6 5,393,377 6/14/2022
6.0.5 7,680,129 5/10/2022
6.0.4 5,542,933 4/11/2022
6.0.3 7,610,757 3/8/2022
6.0.2 5,952,760 2/8/2022
6.0.1 12,793,509 12/14/2021
6.0.0 11,655,462 11/8/2021
6.0.0-rc.2.21480.5 128,641 10/12/2021
6.0.0-rc.1.21452.10 62,015 9/14/2021
6.0.0-preview.7.21378.4 33,386 8/10/2021
6.0.0-preview.6.21352.1 21,505 7/14/2021
6.0.0-preview.5.21301.9 81,851 6/15/2021
6.0.0-preview.4.21253.1 23,032 5/24/2021
6.0.0-preview.3.21201.2 43,120 4/8/2021
6.0.0-preview.2.21154.2 20,667 3/11/2021
6.0.0-preview.1.21102.2 49,715 2/12/2021
5.0.17 2,446,784 5/10/2022
5.0.16 727,765 4/11/2022
5.0.15 911,544 3/8/2022
5.0.14 753,131 2/8/2022
5.0.13 1,821,754 12/14/2021
5.0.12 2,164,239 11/7/2021
5.0.11 3,768,779 10/12/2021
5.0.10 4,215,603 9/14/2021
5.0.9 4,368,807 8/10/2021
5.0.8 4,259,701 7/13/2021
5.0.7 5,055,150 6/8/2021
5.0.6 3,803,479 5/11/2021
5.0.5 4,929,873 4/6/2021
5.0.4 3,556,734 3/9/2021
5.0.3 3,969,604 2/9/2021
5.0.2 3,825,475 1/12/2021
5.0.1 3,548,287 12/8/2020
5.0.0 6,077,481 11/9/2020
5.0.0-rc.2.20475.6 119,156 10/13/2020
5.0.0-rc.1.20451.13 124,226 9/14/2020
5.0.0-preview.8.20407.4 51,608 8/25/2020
5.0.0-preview.7.20365.15 45,715 7/21/2020
5.0.0-preview.6.20312.4 40,896 6/25/2020
5.0.0-preview.5.20278.2 29,614 6/10/2020
5.0.0-preview.4.20220.10 42,908 5/18/2020
5.0.0-preview.3.20181.2 50,641 4/23/2020
5.0.0-preview.2.20159.4 25,773 4/2/2020
5.0.0-preview.2.20120.8 22,980 3/16/2020
3.1.32 1,383,524 12/13/2022
3.1.31 364,580 11/8/2022
3.1.30 249,424 10/11/2022
3.1.29 506,372 9/13/2022
3.1.28 387,449 8/9/2022
3.1.27 337,161 7/12/2022
3.1.26 286,444 6/14/2022
3.1.25 522,322 5/10/2022
3.1.24 307,255 4/11/2022
3.1.23 555,763 3/8/2022
3.1.22 1,586,535 12/14/2021
3.1.21 1,408,825 11/7/2021
3.1.20 696,707 10/11/2021
3.1.19 882,893 9/14/2021
3.1.18 2,228,963 8/10/2021
3.1.17 1,044,196 7/13/2021
3.1.16 1,365,177 6/8/2021
3.1.15 1,462,517 5/11/2021
3.1.14 1,544,200 4/6/2021
3.1.13 1,739,979 3/9/2021
3.1.12 1,595,339 2/9/2021
3.1.11 1,813,349 1/12/2021
3.1.10 4,669,232 11/9/2020
3.1.9 6,779,794 10/13/2020
3.1.8 8,562,297 9/8/2020
3.1.7 5,180,411 8/11/2020
3.1.6 4,777,889 7/14/2020
3.1.5 5,727,440 6/9/2020
3.1.4 5,266,934 5/12/2020
3.1.3 8,913,713 3/24/2020
3.1.2 6,203,010 2/19/2020
3.1.1 6,042,472 1/14/2020
3.1.0 7,572,227 12/3/2019
3.1.0-preview3.19554.8 40,867 11/13/2019
3.1.0-preview2.19525.5 17,961 11/1/2019
3.1.0-preview1.19506.2 475,031 10/15/2019
3.0.3 69,642 2/19/2020
3.0.2 35,498 1/14/2020
3.0.1 717,601 11/18/2019
3.0.0 5,875,499 9/23/2019
3.0.0-rc1.19456.14 33,820 9/16/2019
3.0.0-preview9.19423.6 40,463 9/4/2019
3.0.0-preview8.19405.11 55,780 8/13/2019
3.0.0-preview7.19362.6 39,890 7/23/2019
3.0.0-preview6.19304.10 112,678 6/12/2019
3.0.0-preview5.19227.1 63,910 5/6/2019
3.0.0-preview4.19216.3 11,309 4/18/2019
3.0.0-preview3.19153.1 35,337 3/6/2019
3.0.0-preview.19074.3 14,561 1/29/2019
3.0.0-preview.18572.1 15,982 12/3/2018
2.2.6 18,665,259 7/9/2019
2.2.4 10,278,209 4/9/2019
2.2.3 3,259,171 3/11/2019
2.2.2 3,672,058 2/12/2019
2.2.1 3,681,652 1/8/2019
2.2.0 11,628,417 12/3/2018
2.2.0-preview3-35497 110,259 10/17/2018
2.2.0-preview2-35157 84,556 9/12/2018
2.2.0-preview1-35029 15,557 8/22/2018
2.1.14 2,443,518 11/18/2019
2.1.11 2,197,076 5/14/2019
2.1.8 2,494,294 2/12/2019
2.1.4 8,919,714 10/1/2018
2.1.3 3,719,384 9/11/2018
2.1.2 2,882,689 8/21/2018
2.1.1 10,426,225 6/18/2018
2.1.0 5,642,306 5/29/2018
2.1.0-rc1-final 99,201 5/6/2018
2.1.0-preview2-final 141,451 4/10/2018
2.1.0-preview1-final 205,284 2/26/2018
2.0.3 4,029,091 5/7/2018
2.0.2 4,955,285 3/13/2018
2.0.1 6,418,347 11/14/2017
2.0.0 7,557,776 8/11/2017
2.0.0-preview2-final 62,780 6/28/2017
2.0.0-preview1-final 104,366 5/10/2017
1.1.6 985,108 7/10/2018
1.1.5 429,816 12/12/2017
1.1.4 30,605 11/14/2017
1.1.3 84,086 9/20/2017
1.1.2 1,384,097 5/9/2017
1.1.1 846,891 3/6/2017
1.1.0 685,842 11/16/2016
1.1.0-preview1-final 17,776 10/24/2016
1.0.6 18,962 11/14/2017
1.0.5 13,234 9/20/2017
1.0.4 26,331 5/9/2017
1.0.3 350,717 3/6/2017
1.0.2 33,774 12/12/2016
1.0.1 1,670,262 9/13/2016
1.0.0 509,692 6/27/2016
1.0.0-rc2-final 55,141 5/16/2016

Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite

8.0.2

See the version list below for details.

Requires NuGet 3.6 or higher.

dotnet add package Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite –version 8.0.2

NuGet\Install-Package Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite -Version 8.0.2

paket add Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite –version 8.0.2

#r “nuget: Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite, 8.0.2”

// Install Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite as a Cake Addin #addin nuget:?package=Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite&version=8.0.2 // Install Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite as a Cake Tool #tool nuget:?package=Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite&version=8.0.2

NetTopologySuite support for the Microsoft SQL Server database provider for Entity Framework Core.

Product Versions 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.
  • net8.0
    • Microsoft.EntityFrameworkCore.SqlServer (>= 8.0.2)
    • NetTopologySuite (>= 2.5.0)
    • NetTopologySuite.IO.SqlServerBytes (>= 2.1.0)

NuGet packages (72)

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

Package Downloads
EFCore.BulkExtensions

EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite

NanoCore

The project is inspired by years of tedious repetitions, continuously re-writing similar code-snippets and libraries, to handle common functionality, not related to the business domain, such as logging, data persistence, message queuing, documentation, validation and similar.

EntityFrameworkCore.BootKit

EntityFrameworkCore Boot Kit (EFBK) is a quick start database connecter for using EntityFrameworkCore. Support variety of databases such as Sqlite, MySql, SqlServer, PostgreSql, MongoDb, Amazon Redshift, AWS Aurora and Memory database.

Amelia

Package Description

NeuroSpeech.EntityAccessControl

Entity Access Control List framework over Entity Framework Core with Audit and Typed Events.

GitHub repositories (8)

Showing the top 5 popular GitHub repositories that depend on Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite:

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

ErikEJ/EFCorePowerTools

Entity Framework Core Power Tools – reverse engineering, migrations and model visualization in Visual Studio & CLI

enkodellc/blazorboilerplate

Blazor Boilerplate / Starter Template with MudBlazor

Coldairarrow/EFCore.Sharding

Database Sharding For EFCore

sjh37/EntityFramework-Reverse-POCO-Code-First-Generator

EntityFramework Reverse POCO Code First Generator – Beautifully generated code that is fully customisable. This generator creates code as if you reverse engineered a database and lovingly created the code by hand. It is free to academics (you need a .edu or a .ac email address), not free for commercial use. Obtain your licence from

Version Downloads Last updated
9.0.0-preview.1.24081.2 81 2/13/2024
8.0.2 2,410 2/13/2024
8.0.1 47,589 1/9/2024
8.0.0 263,253 11/14/2023
8.0.0-rc.2.23480.1 1,441 10/10/2023
8.0.0-rc.1.23419.6 12,894 9/12/2023
8.0.0-preview.7.23375.4 723 8/8/2023
8.0.0-preview.6.23329.4 1,220 7/11/2023
8.0.0-preview.5.23280.1 1,080 6/13/2023
8.0.0-preview.4.23259.3 1,277 5/16/2023
8.0.0-preview.3.23174.2 1,032 4/11/2023
8.0.0-preview.2.23128.3 961 3/14/2023
8.0.0-preview.1.23111.4 1,163 2/21/2023
7.0.16 4,210 2/13/2024
7.0.15 72,197 1/9/2024
7.0.14 83,595 11/14/2023
7.0.13 53,379 10/24/2023
7.0.12 47,210 10/10/2023
7.0.11 248,431 9/12/2023
7.0.10 552,797 8/8/2023
7.0.9 255,203 7/11/2023
7.0.8 278,432 6/22/2023
7.0.7 28,163 6/13/2023
7.0.5 1,149,712 4/11/2023
7.0.4 95,592 3/14/2023
7.0.3 222,647 2/14/2023
7.0.2 753,069 1/10/2023
7.0.1 100,031 12/13/2022
7.0.0 156,968 11/7/2022
7.0.0-rc.2.22472.11 1,387 10/11/2022
7.0.0-rc.1.22426.7 1,365 9/14/2022
7.0.0-preview.7.22376.2 551 8/9/2022
7.0.0-preview.6.22329.4 3,014 7/12/2022
7.0.0-preview.5.22302.2 328 6/14/2022
7.0.0-preview.4.22229.2 481 5/10/2022
7.0.0-preview.3.22175.1 467 4/13/2022
7.0.0-preview.2.22153.1 841 3/14/2022
7.0.0-preview.1.22076.6 416 2/17/2022
6.0.27 604 2/13/2024
6.0.26 10,241 1/9/2024
6.0.25 39,819 11/14/2023
6.0.24 12,258 10/24/2023
6.0.23 5,931 10/10/2023
6.0.22 33,982 9/12/2023
6.0.21 128,002 8/8/2023
6.0.20 38,735 7/11/2023
6.0.19 234,386 6/22/2023
6.0.18 7,425 6/13/2023
6.0.16 274,356 4/11/2023
6.0.15 68,727 3/14/2023
6.0.14 125,779 2/14/2023
6.0.13 373,943 1/10/2023
6.0.12 106,600 12/13/2022
6.0.11 833,361 11/7/2022
6.0.10 204,832 10/11/2022
6.0.9 681,123 9/13/2022
6.0.8 242,432 8/9/2022
6.0.7 291,745 7/12/2022
6.0.6 244,768 6/14/2022
6.0.5 184,343 5/10/2022
6.0.4 141,701 4/11/2022
6.0.3 526,811 3/8/2022
6.0.2 160,428 2/8/2022
6.0.1 408,972 12/14/2021
6.0.0 248,268 11/8/2021
6.0.0-rc.2.21480.5 4,455 10/12/2021
6.0.0-rc.1.21452.10 674 9/14/2021
6.0.0-preview.7.21378.4 648 8/10/2021
6.0.0-preview.6.21352.1 964 7/14/2021
6.0.0-preview.5.21301.9 6,439 6/15/2021
6.0.0-preview.4.21253.1 411 5/24/2021
6.0.0-preview.3.21201.2 683 4/8/2021
6.0.0-preview.2.21154.2 392 3/11/2021
6.0.0-preview.1.21102.2 453 2/12/2021
5.0.17 112,727 5/10/2022
5.0.16 8,701 4/11/2022
5.0.15 35,146 3/8/2022
5.0.14 19,400 2/8/2022
5.0.13 79,898 12/14/2021
5.0.12 26,738 11/7/2021
5.0.11 154,282 10/12/2021
5.0.10 142,851 9/14/2021
5.0.9 159,045 8/10/2021
5.0.8 210,045 7/13/2021
5.0.7 227,891 6/8/2021
5.0.6 253,993 5/11/2021
5.0.5 158,186 4/6/2021
5.0.4 97,391 3/9/2021
5.0.3 79,414 2/9/2021
5.0.2 135,608 1/12/2021
5.0.1 84,075 12/8/2020
5.0.0 122,713 11/9/2020
5.0.0-rc.2.20475.6 2,163 10/13/2020
5.0.0-rc.1.20451.13 5,523 9/14/2020
5.0.0-preview.8.20407.4 3,296 8/25/2020
5.0.0-preview.7.20365.15 1,262 7/21/2020
5.0.0-preview.6.20312.4 631 6/25/2020
5.0.0-preview.5.20278.2 517 6/10/2020
5.0.0-preview.4.20220.10 7,978 5/18/2020
5.0.0-preview.3.20181.2 4,963 4/23/2020
5.0.0-preview.2.20159.4 724 4/2/2020
5.0.0-preview.2.20120.8 1,221 3/16/2020
3.1.32 34,819 12/13/2022
3.1.31 3,652 11/8/2022
3.1.30 23,552 10/11/2022
3.1.29 12,021 9/13/2022
3.1.28 5,571 8/9/2022
3.1.27 12,506 7/12/2022
3.1.26 10,132 6/14/2022
3.1.25 24,963 5/10/2022
3.1.24 19,303 4/11/2022
3.1.23 41,873 3/8/2022
3.1.22 101,273 12/14/2021
3.1.21 98,417 11/7/2021
3.1.20 20,023 10/11/2021
3.1.19 7,082 9/14/2021
3.1.18 56,437 8/10/2021
3.1.17 39,601 7/13/2021
3.1.16 139,449 6/8/2021
3.1.15 69,708 5/11/2021
3.1.14 119,435 4/6/2021
3.1.13 52,508 3/9/2021
3.1.12 46,366 2/9/2021
3.1.11 162,732 1/12/2021
3.1.10 192,050 11/9/2020
3.1.9 333,922 10/13/2020
3.1.8 234,084 9/8/2020
3.1.7 281,803 8/11/2020
3.1.6 178,857 7/14/2020
3.1.5 141,906 6/9/2020
3.1.4 103,409 5/12/2020
3.1.3 319,029 3/24/2020
3.1.2 256,510 2/19/2020
3.1.1 144,006 1/14/2020
3.1.0 169,439 12/3/2019
3.1.0-preview3.19554.8 941 11/13/2019
3.1.0-preview2.19525.5 430 11/1/2019
3.1.0-preview1.19506.2 408 10/15/2019
3.0.3 3,345 2/19/2020
3.0.2 1,336 1/14/2020
3.0.1 13,853 11/18/2019
3.0.0 93,022 9/23/2019
3.0.0-rc1.19456.14 714 9/16/2019
3.0.0-preview9.19423.6 1,021 9/4/2019
3.0.0-preview8.19405.11 1,751 8/13/2019
3.0.0-preview7.19362.6 1,216 7/23/2019
3.0.0-preview6.19304.10 710 6/12/2019
3.0.0-preview5.19227.1 584 5/6/2019
3.0.0-preview4.19216.3 835 4/18/2019
3.0.0-preview3.19153.1 1,603 3/6/2019
3.0.0-preview.19074.3 1,261 1/29/2019
3.0.0-preview.18572.1 617 12/3/2018
2.2.6 454,446 7/9/2019
2.2.4 301,016 4/9/2019
2.2.3 74,737 3/11/2019
2.2.2 77,911 2/12/2019
2.2.1 51,031 1/8/2019
2.2.0 110,071 12/3/2018
2.2.0-preview3-35497 4,525 10/17/2018
2.2.0-preview2-35157 6,252 9/12/2018

Microsoft SQL Server EF Core Database Provider

This database provider allows Entity Framework Core to be used with Microsoft SQL Server (including Azure SQL Database). The provider is maintained as part of the Entity Framework Core Project.

Feedback

Submit and view feedback for

Microsoft.EntityFrameworkCore

6.0.0

See the version list below for details.

Requires NuGet 3.6 or higher.

dotnet add package Microsoft.EntityFrameworkCore –version 6.0.0

NuGet\Install-Package Microsoft.EntityFrameworkCore -Version 6.0.0

paket add Microsoft.EntityFrameworkCore –version 6.0.0

#r “nuget: Microsoft.EntityFrameworkCore, 6.0.0”

// Install Microsoft.EntityFrameworkCore as a Cake Addin #addin nuget:?package=Microsoft.EntityFrameworkCore&version=6.0.0 // Install Microsoft.EntityFrameworkCore as a Cake Tool #tool nuget:?package=Microsoft.EntityFrameworkCore&version=6.0.0

Entity Framework Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations. EF Core works with SQL Server, Azure SQL Database, SQLite, Azure Cosmos DB, MySQL, PostgreSQL, and other databases through a provider plugin API.Commonly Used Types:Microsoft.EntityFrameworkCore.DbContextMicrosoft.EntityFrameworkCore.DbSet

Product Versions Compatible and additional computed target framework versions.
.NET net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. 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.
  • net6.0
    • Microsoft.EntityFrameworkCore.Abstractions (>= 6.0.0)
    • Microsoft.EntityFrameworkCore.Analyzers (>= 6.0.0)
    • Microsoft.Extensions.Caching.Memory (>= 6.0.0)
    • Microsoft.Extensions.DependencyInjection (>= 6.0.0)
    • Microsoft.Extensions.Logging (>= 6.0.0)
    • System.Collections.Immutable (>= 6.0.0)
    • System.Diagnostics.DiagnosticSource (>= 6.0.0)

NuGet packages (7.2K)

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

Package Downloads
Microsoft.EntityFrameworkCore.Relational

Shared Entity Framework Core components for relational database providers.

Microsoft.EntityFrameworkCore.InMemory

In-memory database provider for Entity Framework Core (to be used for testing purposes).

Npgsql.EntityFrameworkCore.PostgreSQL

PostgreSQL/Npgsql provider for Entity Framework Core.

Microsoft.EntityFrameworkCore.Proxies

Lazy loading proxies for Entity Framework Core.

Microsoft.AspNetCore.App

Provides a default set of APIs for building an ASP.NET Core application. This package requires the ASP.NET Core runtime. This runtime is installed by the .NET Core SDK, or can be acquired separately using installers available at https://aka.ms/dotnet-download.

GitHub repositories (526)

Showing the top 5 popular GitHub repositories that depend on Microsoft.EntityFrameworkCore:

Repository Stars
jasontaylordev/CleanArchitecture

Clean Architecture Solution Template for ASP.NET Core

dotnet/AspNetCore.Docs

Documentation for ASP.NET Core

abpframework/abp

Open Source Web Application Framework for ASP.NET Core. Offers an opinionated architecture to build enterprise software solutions with best practices on top of the .NET and the ASP.NET Core platforms. Provides the fundamental infrastructure, production-ready startup templates, application modules, UI themes, tooling, guides and documentation.

aspnetboilerplate/aspnetboilerplate

ASP.NET Boilerplate – Web Application Framework

kgrzybek/modular-monolith-with-ddd

Full Modular Monolith application with Domain-Driven Design approach.

Version Downloads Last updated
9.0.0-preview.1.24081.2 2,397 2/13/2024
8.0.2 101,127 2/13/2024
8.0.1 2,122,057 1/9/2024
8.0.0 4,349,751 11/14/2023
8.0.0-rc.2.23480.1 277,177 10/10/2023
8.0.0-rc.1.23419.6 104,091 9/12/2023
8.0.0-preview.7.23375.4 60,517 8/8/2023
8.0.0-preview.6.23329.4 94,357 7/11/2023
8.0.0-preview.5.23280.1 91,848 6/13/2023
8.0.0-preview.4.23259.3 92,201 5/16/2023
8.0.0-preview.3.23174.2 122,737 4/11/2023
8.0.0-preview.2.23128.3 128,075 3/14/2023
8.0.0-preview.1.23111.4 116,641 2/21/2023
7.0.16 35,272 2/13/2024
7.0.15 792,632 1/9/2024
7.0.14 2,403,021 11/14/2023
7.0.13 3,041,106 10/24/2023
7.0.12 2,398,324 10/10/2023
7.0.11 6,210,490 9/12/2023
7.0.10 5,805,422 8/8/2023
7.0.9 5,104,322 7/11/2023
7.0.8 3,600,216 6/22/2023
7.0.7 2,554,085 6/13/2023
7.0.5 16,872,391 4/11/2023
7.0.4 7,045,375 3/14/2023
7.0.3 9,688,693 2/14/2023
7.0.2 12,192,705 1/10/2023
7.0.1 7,353,843 12/13/2022
7.0.0 15,943,676 11/7/2022
7.0.0-rc.2.22472.11 183,816 10/11/2022
7.0.0-rc.1.22426.7 190,343 9/14/2022
7.0.0-preview.7.22376.2 80,868 8/9/2022
7.0.0-preview.6.22329.4 59,940 7/12/2022
7.0.0-preview.5.22302.2 55,114 6/14/2022
7.0.0-preview.4.22229.2 69,014 5/10/2022
7.0.0-preview.3.22175.1 69,807 4/13/2022
7.0.0-preview.2.22153.1 80,545 3/14/2022
7.0.0-preview.1.22076.6 48,801 2/17/2022
6.0.27 22,388 2/13/2024
6.0.26 498,717 1/9/2024
6.0.25 1,134,946 11/14/2023
6.0.24 763,534 10/24/2023
6.0.23 615,051 10/10/2023
6.0.22 1,453,492 9/12/2023
6.0.21 1,751,970 8/8/2023
6.0.20 1,599,616 7/11/2023
6.0.19 1,263,553 6/22/2023
6.0.18 783,212 6/13/2023
6.0.16 4,648,080 4/11/2023
6.0.15 2,814,023 3/14/2023
6.0.14 3,438,429 2/14/2023
6.0.13 4,842,120 1/10/2023
6.0.12 6,833,039 12/13/2022
6.0.11 7,185,042 11/7/2022
6.0.10 12,850,307 10/11/2022
6.0.9 11,613,357 9/13/2022
6.0.8 13,790,202 8/9/2022
6.0.7 35,316,983 7/12/2022
6.0.6 11,450,156 6/14/2022
6.0.5 17,511,946 5/10/2022
6.0.4 13,901,094 4/11/2022
6.0.3 18,194,332 3/8/2022
6.0.2 15,985,944 2/8/2022
6.0.1 25,705,550 12/14/2021
6.0.0 44,138,288 11/8/2021
6.0.0-rc.2.21480.5 295,504 10/12/2021
6.0.0-rc.1.21452.10 175,239 9/14/2021
6.0.0-preview.7.21378.4 85,353 8/10/2021
6.0.0-preview.6.21352.1 40,726 7/14/2021
6.0.0-preview.5.21301.9 166,613 6/15/2021
6.0.0-preview.4.21253.1 69,907 5/24/2021
6.0.0-preview.3.21201.2 88,802 4/8/2021
6.0.0-preview.2.21154.2 61,975 3/11/2021
6.0.0-preview.1.21102.2 89,065 2/12/2021
5.0.17 5,315,663 5/10/2022
5.0.16 1,251,887 4/11/2022
5.0.15 1,906,204 3/8/2022
5.0.14 2,129,285 2/8/2022
5.0.13 3,839,728 12/14/2021
5.0.12 4,273,044 11/7/2021
5.0.11 7,406,417 10/12/2021
5.0.10 11,778,259 9/14/2021
5.0.9 9,231,186 8/10/2021
5.0.8 8,342,415 7/13/2021
5.0.7 12,802,879 6/8/2021
5.0.6 7,399,671 5/11/2021
5.0.5 10,200,832 4/6/2021
5.0.4 7,590,816 3/9/2021
5.0.3 7,559,243 2/9/2021
5.0.2 9,811,500 1/12/2021
5.0.1 14,250,627 12/8/2020
5.0.0 22,250,913 11/9/2020
5.0.0-rc.2.20475.6 362,874 10/13/2020
5.0.0-rc.1.20451.13 311,669 9/14/2020
5.0.0-preview.8.20407.4 192,957 8/25/2020
5.0.0-preview.7.20365.15 109,645 7/21/2020
5.0.0-preview.6.20312.4 61,027 6/25/2020
5.0.0-preview.5.20278.2 44,732 6/10/2020
5.0.0-preview.4.20220.10 70,036 5/18/2020
5.0.0-preview.3.20181.2 90,030 4/23/2020
5.0.0-preview.2.20159.4 58,619 4/2/2020
5.0.0-preview.2.20120.8 44,709 3/16/2020
3.1.32 2,155,156 12/13/2022
3.1.31 501,150 11/8/2022
3.1.30 501,453 10/11/2022
3.1.29 703,563 9/13/2022
3.1.28 582,073 8/9/2022
3.1.27 563,334 7/12/2022
3.1.26 489,389 6/14/2022
3.1.25 873,939 5/10/2022
3.1.24 556,889 4/11/2022
3.1.23 885,425 3/8/2022
3.1.22 2,647,559 12/14/2021
3.1.21 2,146,797 11/7/2021
3.1.20 1,193,756 10/11/2021
3.1.19 2,057,491 9/14/2021
3.1.18 4,577,140 8/10/2021
3.1.17 1,658,194 7/13/2021
3.1.16 2,060,092 6/8/2021
3.1.15 2,399,300 5/11/2021
3.1.14 2,829,554 4/6/2021
3.1.13 4,058,669 3/9/2021
3.1.12 2,735,363 2/9/2021
3.1.11 4,941,993 1/12/2021
3.1.10 7,783,899 11/9/2020
3.1.9 11,166,914 10/13/2020
3.1.8 16,638,570 9/8/2020
3.1.7 9,025,652 8/11/2020
3.1.6 9,984,380 7/14/2020
3.1.5 11,833,304 6/9/2020
3.1.4 16,550,471 5/12/2020
3.1.3 25,389,978 3/24/2020
3.1.2 11,072,971 2/19/2020
3.1.1 17,676,131 1/14/2020
3.1.0 30,044,314 12/3/2019
3.1.0-preview3.19554.8 157,008 11/13/2019
3.1.0-preview2.19525.5 31,477 11/1/2019
3.1.0-preview1.19506.2 686,591 10/15/2019
3.0.3 167,346 2/19/2020
3.0.2 72,518 1/14/2020
3.0.1 1,317,822 11/18/2019
3.0.0 16,987,744 9/23/2019
3.0.0-rc1.19456.14 45,370 9/16/2019
3.0.0-preview9.19423.6 1,291,174 9/4/2019
3.0.0-preview8.19405.11 383,413 8/13/2019
3.0.0-preview7.19362.6 86,014 7/23/2019
3.0.0-preview6.19304.10 155,839 6/12/2019
3.0.0-preview5.19227.1 625,964 5/6/2019
3.0.0-preview4.19216.3 21,882 4/18/2019
3.0.0-preview3.19153.1 191,579 3/6/2019
3.0.0-preview.19074.3 29,948 1/29/2019
3.0.0-preview.18572.1 46,024 12/3/2018
2.2.6 29,224,000 7/9/2019
2.2.4 18,412,464 4/9/2019
2.2.3 5,105,651 3/11/2019
2.2.2 6,092,545 2/12/2019
2.2.1 6,559,832 1/8/2019
2.2.0 19,047,814 12/3/2018
2.2.0-preview3-35497 177,374 10/17/2018
2.2.0-preview2-35157 135,373 9/12/2018
2.2.0-preview1-35029 75,437 8/22/2018
2.1.14 3,554,521 11/18/2019
2.1.11 3,575,041 5/14/2019
2.1.8 3,408,080 2/12/2019
2.1.4 14,823,293 10/1/2018
2.1.3 4,731,897 9/11/2018
2.1.2 7,829,454 8/21/2018
2.1.1 13,502,386 6/18/2018
2.1.0 12,122,710 5/29/2018
2.1.0-rc1-final 202,808 5/6/2018
2.1.0-preview2-final 175,879 4/10/2018
2.1.0-preview1-final 293,580 2/26/2018
2.0.3 4,972,893 5/7/2018
2.0.2 6,241,085 3/13/2018
2.0.1 11,692,997 11/14/2017
2.0.0 23,303,333 8/11/2017
2.0.0-preview2-final 85,109 6/28/2017
2.0.0-preview1-final 1,048,459 5/10/2017
1.1.6 4,749,958 7/10/2018
1.1.5 1,158,082 12/12/2017
1.1.4 204,190 11/14/2017
1.1.3 290,491 9/20/2017
1.1.2 4,208,732 5/9/2017
1.1.1 2,727,512 3/6/2017
1.1.0 5,625,280 11/16/2016
1.1.0-preview1-final 40,087 10/24/2016
1.0.6 44,480 11/14/2017
1.0.5 34,507 9/20/2017
1.0.4 48,886 5/9/2017
1.0.3 544,728 3/6/2017
1.0.2 72,662 12/12/2016
1.0.1 605,425 9/13/2016
1.0.0 1,206,867 6/27/2016
1.0.0-rc2-final 123,595 5/16/2016

Microsoft.EntityFrameworkCore.SqlServer

8.0.2

See the version list below for details.

Requires NuGet 3.6 or higher.

dotnet add package Microsoft.EntityFrameworkCore.SqlServer –version 8.0.2

NuGet\Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 8.0.2

paket add Microsoft.EntityFrameworkCore.SqlServer –version 8.0.2

#r “nuget: Microsoft.EntityFrameworkCore.SqlServer, 8.0.2”

// Install Microsoft.EntityFrameworkCore.SqlServer as a Cake Addin #addin nuget:?package=Microsoft.EntityFrameworkCore.SqlServer&version=8.0.2 // Install Microsoft.EntityFrameworkCore.SqlServer as a Cake Tool #tool nuget:?package=Microsoft.EntityFrameworkCore.SqlServer&version=8.0.2

Microsoft SQL Server database provider for Entity Framework Core.

Product Versions 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.
  • net8.0
    • Microsoft.Data.SqlClient (>= 5.1.4)
    • Microsoft.EntityFrameworkCore.Relational (>= 8.0.2)

NuGet packages (3.1K)

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

Package Downloads
Microsoft.AspNetCore.App

Provides a default set of APIs for building an ASP.NET Core application. This package requires the ASP.NET Core runtime. This runtime is installed by the .NET Core SDK, or can be acquired separately using installers available at https://aka.ms/dotnet-download.

Microsoft.AspNetCore.All

Provides a default set of APIs for building an ASP.NET Core application, and also includes API for third-party integrations with ASP.NET Core. This package requires the ASP.NET Core runtime. This runtime is installed by the .NET Core SDK, or can be acquired separately using installers available at https://aka.ms/dotnet-download.

Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite

NetTopologySuite support for the Microsoft SQL Server database provider for Entity Framework Core.

EntityFrameworkCore.SqlServer.HierarchyId

Adds hierarchyid support to the SQL Server EF Core provider

Microsoft.EntityFrameworkCore.SqlServer.Design

Design-time Entity Framework Core Functionality for Microsoft SQL Server.

GitHub repositories (542)

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

Repository Stars
dotnet/aspnetcore

ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.

DapperLib/Dapper

Dapper – a simple object mapper for .Net

jasontaylordev/CleanArchitecture

Clean Architecture Solution Template for ASP.NET Core

ardalis/CleanArchitecture

Clean Architecture Solution Template: A starting point for Clean Architecture with ASP.NET Core

bitwarden/server

The core infrastructure backend (API, database, Docker, etc).

Version Downloads Last updated
9.0.0-preview.1.24081.2 1,381 2/13/2024
8.0.2 63,295 2/13/2024
8.0.1 1,353,199 1/9/2024
8.0.0 2,391,697 11/14/2023
8.0.0-rc.2.23480.1 80,475 10/10/2023
8.0.0-rc.1.23419.6 53,139 9/12/2023
8.0.0-preview.7.23375.4 37,528 8/8/2023
8.0.0-preview.6.23329.4 48,711 7/11/2023
8.0.0-preview.5.23280.1 40,016 6/13/2023
8.0.0-preview.4.23259.3 29,705 5/16/2023
8.0.0-preview.3.23174.2 43,460 4/11/2023
8.0.0-preview.2.23128.3 78,228 3/14/2023
8.0.0-preview.1.23111.4 30,905 2/21/2023
7.0.16 19,521 2/13/2024
7.0.15 429,668 1/9/2024
7.0.14 1,209,093 11/14/2023
7.0.13 1,622,128 10/24/2023
7.0.12 1,209,886 10/10/2023
7.0.11 2,492,615 9/12/2023
7.0.10 3,138,156 8/8/2023
7.0.9 2,669,781 7/11/2023
7.0.8 1,795,502 6/22/2023
7.0.7 1,616,976 6/13/2023
7.0.5 7,488,764 4/11/2023
7.0.4 3,290,558 3/14/2023
7.0.3 4,142,214 2/14/2023
7.0.2 4,563,757 1/10/2023
7.0.1 2,768,449 12/13/2022
7.0.0 6,008,394 11/7/2022
7.0.0-rc.2.22472.11 87,815 10/11/2022
7.0.0-rc.1.22426.7 122,425 9/14/2022
7.0.0-preview.7.22376.2 30,550 8/9/2022
7.0.0-preview.6.22329.4 29,657 7/12/2022
7.0.0-preview.5.22302.2 23,277 6/14/2022
7.0.0-preview.4.22229.2 29,514 5/10/2022
7.0.0-preview.3.22175.1 42,519 4/13/2022
7.0.0-preview.2.22153.1 20,703 3/14/2022
7.0.0-preview.1.22076.6 23,916 2/17/2022
6.0.27 14,957 2/13/2024
6.0.26 311,423 1/9/2024
6.0.25 657,592 11/14/2023
6.0.24 429,763 10/24/2023
6.0.23 354,145 10/10/2023
6.0.22 688,803 9/12/2023
6.0.21 1,015,185 8/8/2023
6.0.20 886,951 7/11/2023
6.0.19 807,530 6/22/2023
6.0.18 404,848 6/13/2023
6.0.16 2,602,376 4/11/2023
6.0.15 1,598,983 3/14/2023
6.0.14 1,719,683 2/14/2023
6.0.13 2,869,613 1/10/2023
6.0.12 2,053,355 12/13/2022
6.0.11 4,182,546 11/7/2022
6.0.10 6,967,000 10/11/2022
6.0.9 6,638,798 9/13/2022
6.0.8 7,367,873 8/9/2022
6.0.7 7,083,696 7/12/2022
6.0.6 5,393,377 6/14/2022
6.0.5 7,680,129 5/10/2022
6.0.4 5,542,933 4/11/2022
6.0.3 7,610,757 3/8/2022
6.0.2 5,952,760 2/8/2022
6.0.1 12,793,509 12/14/2021
6.0.0 11,655,462 11/8/2021
6.0.0-rc.2.21480.5 128,641 10/12/2021
6.0.0-rc.1.21452.10 62,015 9/14/2021
6.0.0-preview.7.21378.4 33,386 8/10/2021
6.0.0-preview.6.21352.1 21,505 7/14/2021
6.0.0-preview.5.21301.9 81,851 6/15/2021
6.0.0-preview.4.21253.1 23,032 5/24/2021
6.0.0-preview.3.21201.2 43,120 4/8/2021
6.0.0-preview.2.21154.2 20,667 3/11/2021
6.0.0-preview.1.21102.2 49,715 2/12/2021
5.0.17 2,446,784 5/10/2022
5.0.16 727,765 4/11/2022
5.0.15 911,544 3/8/2022
5.0.14 753,131 2/8/2022
5.0.13 1,821,754 12/14/2021
5.0.12 2,164,239 11/7/2021
5.0.11 3,768,779 10/12/2021
5.0.10 4,215,603 9/14/2021
5.0.9 4,368,807 8/10/2021
5.0.8 4,259,701 7/13/2021
5.0.7 5,055,150 6/8/2021
5.0.6 3,803,479 5/11/2021
5.0.5 4,929,873 4/6/2021
5.0.4 3,556,734 3/9/2021
5.0.3 3,969,604 2/9/2021
5.0.2 3,825,475 1/12/2021
5.0.1 3,548,287 12/8/2020
5.0.0 6,077,481 11/9/2020
5.0.0-rc.2.20475.6 119,156 10/13/2020
5.0.0-rc.1.20451.13 124,226 9/14/2020
5.0.0-preview.8.20407.4 51,608 8/25/2020
5.0.0-preview.7.20365.15 45,715 7/21/2020
5.0.0-preview.6.20312.4 40,896 6/25/2020
5.0.0-preview.5.20278.2 29,614 6/10/2020
5.0.0-preview.4.20220.10 42,908 5/18/2020
5.0.0-preview.3.20181.2 50,641 4/23/2020
5.0.0-preview.2.20159.4 25,773 4/2/2020
5.0.0-preview.2.20120.8 22,980 3/16/2020
3.1.32 1,383,524 12/13/2022
3.1.31 364,580 11/8/2022
3.1.30 249,424 10/11/2022
3.1.29 506,372 9/13/2022
3.1.28 387,449 8/9/2022
3.1.27 337,161 7/12/2022
3.1.26 286,444 6/14/2022
3.1.25 522,322 5/10/2022
3.1.24 307,255 4/11/2022
3.1.23 555,763 3/8/2022
3.1.22 1,586,535 12/14/2021
3.1.21 1,408,825 11/7/2021
3.1.20 696,707 10/11/2021
3.1.19 882,893 9/14/2021
3.1.18 2,228,963 8/10/2021
3.1.17 1,044,196 7/13/2021
3.1.16 1,365,177 6/8/2021
3.1.15 1,462,517 5/11/2021
3.1.14 1,544,200 4/6/2021
3.1.13 1,739,979 3/9/2021
3.1.12 1,595,339 2/9/2021
3.1.11 1,813,349 1/12/2021
3.1.10 4,669,232 11/9/2020
3.1.9 6,779,794 10/13/2020
3.1.8 8,562,297 9/8/2020
3.1.7 5,180,411 8/11/2020
3.1.6 4,777,889 7/14/2020
3.1.5 5,727,440 6/9/2020
3.1.4 5,266,934 5/12/2020
3.1.3 8,913,713 3/24/2020
3.1.2 6,203,010 2/19/2020
3.1.1 6,042,472 1/14/2020
3.1.0 7,572,227 12/3/2019
3.1.0-preview3.19554.8 40,867 11/13/2019
3.1.0-preview2.19525.5 17,961 11/1/2019
3.1.0-preview1.19506.2 475,031 10/15/2019
3.0.3 69,642 2/19/2020
3.0.2 35,498 1/14/2020
3.0.1 717,601 11/18/2019
3.0.0 5,875,499 9/23/2019
3.0.0-rc1.19456.14 33,820 9/16/2019
3.0.0-preview9.19423.6 40,463 9/4/2019
3.0.0-preview8.19405.11 55,780 8/13/2019
3.0.0-preview7.19362.6 39,890 7/23/2019
3.0.0-preview6.19304.10 112,678 6/12/2019
3.0.0-preview5.19227.1 63,910 5/6/2019
3.0.0-preview4.19216.3 11,309 4/18/2019
3.0.0-preview3.19153.1 35,337 3/6/2019
3.0.0-preview.19074.3 14,561 1/29/2019
3.0.0-preview.18572.1 15,982 12/3/2018
2.2.6 18,665,259 7/9/2019
2.2.4 10,278,209 4/9/2019
2.2.3 3,259,171 3/11/2019
2.2.2 3,672,058 2/12/2019
2.2.1 3,681,652 1/8/2019
2.2.0 11,628,417 12/3/2018
2.2.0-preview3-35497 110,259 10/17/2018
2.2.0-preview2-35157 84,556 9/12/2018
2.2.0-preview1-35029 15,557 8/22/2018
2.1.14 2,443,518 11/18/2019
2.1.11 2,197,076 5/14/2019
2.1.8 2,494,294 2/12/2019
2.1.4 8,919,714 10/1/2018
2.1.3 3,719,384 9/11/2018
2.1.2 2,882,689 8/21/2018
2.1.1 10,426,225 6/18/2018
2.1.0 5,642,306 5/29/2018
2.1.0-rc1-final 99,201 5/6/2018
2.1.0-preview2-final 141,451 4/10/2018
2.1.0-preview1-final 205,284 2/26/2018
2.0.3 4,029,091 5/7/2018
2.0.2 4,955,285 3/13/2018
2.0.1 6,418,347 11/14/2017
2.0.0 7,557,776 8/11/2017
2.0.0-preview2-final 62,780 6/28/2017
2.0.0-preview1-final 104,366 5/10/2017
1.1.6 985,108 7/10/2018
1.1.5 429,816 12/12/2017
1.1.4 30,605 11/14/2017
1.1.3 84,086 9/20/2017
1.1.2 1,384,097 5/9/2017
1.1.1 846,891 3/6/2017
1.1.0 685,842 11/16/2016
1.1.0-preview1-final 17,776 10/24/2016
1.0.6 18,962 11/14/2017
1.0.5 13,234 9/20/2017
1.0.4 26,331 5/9/2017
1.0.3 350,717 3/6/2017
1.0.2 33,774 12/12/2016
1.0.1 1,670,262 9/13/2016
1.0.0 509,692 6/27/2016
1.0.0-rc2-final 55,141 5/16/2016
\n \n \n title\n description\n author\n ms.date\n uid\n \n \n \n \n

EF Core NuGet Packages

\n

Overview of the different Entity Framework Core NuGet packages

\n

ajcvickers

\n

01/21/2021

\n

core/what-is-new/nuget-packages

\n \n \n\n\n

EF Core NuGet Packages

\n

Entity Framework Core (EF Core) is shipped as

NuGet

packages. The packages needed by an application depends on:

\n

    \n

  • The type of database system being used (SQL Server, SQLite, etc.)
  • \n

  • The EF Core features needed
  • \n

\n

The usual process for installing packages is:

\n

    \n

  • Decide on a database provider and install the appropriate package (

    see below

    )
  • \n

  • Also install

    Microsoft.EntityFrameworkCore

    , and

    Microsoft.EntityFrameworkCore.Relational

    if using a relational database provider. This helps ensure that consistent versions are being used, and also means that NuGet will let you know when new package versions are shipped.
  • \n

  • Optionally, decide which kind of tooling you need and install the appropriate packages for that (

    see below

    )
  • \n

\n

See Getting started tutorial for Entity Framework Core for help getting started with EF Core.

\n

Entity Framework - Relationships: One-to-One, Many-to-Many, One-to-Many
Entity Framework – Relationships: One-to-One, Many-to-Many, One-to-Many

Install

Install the Microsoft.EntityFrameworkCore.SqlServer NuGet package.


dotnet add package Microsoft.EntityFrameworkCore.SqlServer

Note

The provider references Microsoft.Data.SqlClient (not System.Data.SqlClient). If your project takes a direct dependency on SqlClient, make sure it references the Microsoft.Data.SqlClient package.

Tip

The Microsoft.Data.SqlClient package ships more frequently than the EF Core provider. If you would like to take advantage of new features and bug fixes, you can add a direct package reference to the latest version of Microsoft.Data.SqlClient.

Warning

The async implementation of Microsoft.Data.SqlClient unfortunately has some known issues (e.g. #593, #601, and others). If you’re seeing unexpected performance problems, try using sync command execution instead, especially when dealing with large text or binary values.

Get the Entity Framework Core tools

You can install tools to carry out EF Core-related tasks in your project, like creating and applying database migrations, or creating an EF Core model based on an existing database.

Two sets of tools are available:

  • The .NET Core command-line interface (CLI) tools can be used on Windows, Linux, or macOS. These commands begin with


    dotnet ef

    .

  • The Package Manager Console (PMC) tools run in Visual Studio on Windows. These commands start with a verb, for example


    Add-Migration

    ,

    Update-Database

    .

Get the .NET Core CLI tools

.NET Core CLI tools require the .NET Core SDK, mentioned earlier in Prerequisites.


  • dotnet ef

    must be installed as a global or local tool. Most developers prefer installing

    dotnet ef

    as a global tool using the following command:

    dotnet tool install --global dotnet-ef


    dotnet ef

    can also be used as a local tool. To use it as a local tool, restore the dependencies of a project that declares it as a tooling dependency using a tool manifest file.
  • To update the tools, use the


    dotnet tool update

    command.

  • Install the latest


    Microsoft.EntityFrameworkCore.Design

    package.

    dotnet add package Microsoft.EntityFrameworkCore.Design

Important

Always use the version of the tools package that matches the major version of the runtime packages.

Get the Package Manager Console tools

To get the Package Manager Console tools for EF Core, install the

Microsoft.EntityFrameworkCore.Tools

package. For example, from Visual Studio:


Install-Package Microsoft.EntityFrameworkCore.Tools

.NET 7.0 Web API Full course with CRUD actions, Authentication, FileHandling & IIS Deployment - 2023
.NET 7.0 Web API Full course with CRUD actions, Authentication, FileHandling & IIS Deployment – 2023

Get Entity Framework Core

EF Core is shipped as NuGet packages. To add EF Core to an application, install the NuGet package for the database provider you want to use. See Providers for a list of the database providers available.

To install or update NuGet packages, you can use the .NET Core command-line interface (CLI), the Visual Studio Package Manager Dialog, or the Visual Studio Package Manager Console.

.NET Core CLI

  • Use the following .NET Core CLI command from the operating system’s command line to install or update the EF Core SQL Server provider:


    dotnet add package Microsoft.EntityFrameworkCore.SqlServer

  • You can indicate a specific version in the


    dotnet add package

    command, using the

    -v

    modifier. For example, to install EF Core 6.0.14 packages, append

    -v 6.0.14

    to the command.

For more information, see .NET command-line interface (CLI) tools.

Visual Studio NuGet Package Manager Dialog

  • From the Visual Studio menu, select Project > Manage NuGet Packages

  • Click on the Browse or the Updates tab

  • To install or update the SQL Server provider, select the


    Microsoft.EntityFrameworkCore.SqlServer

    package, and confirm.

For more information, see NuGet Package Manager Dialog.

Visual Studio NuGet Package Manager Console

  • From the Visual Studio menu, select Tools > NuGet Package Manager > Package Manager Console

  • To install the SQL Server provider, run the following command in the Package Manager Console:


    Install-Package Microsoft.EntityFrameworkCore.SqlServer

  • To update the provider, use the


    Update-Package

    command.

  • To specify a specific version, use the


    -Version

    modifier. For example, to install EF Core 6.0.14 packages, append

    -Version 6.0.14

    to the commands

For more information, see Package Manager Console.

Phản hồi

Gửi và xem ý kiến phản hồi dành cho

Context

  • Creating an Entity Framework data layer (experience with Hibernate)
  • Connecting to SQL Server Express
  • Client is a simple desktop application
  • I can’t use Entity Framework CORE

Details

I’ve been working through Entity Framework 6’s docs here as well as some other resources. Everything I’ve found in regards to EF6 is quite dated. Case in point it “says” it’ll add things to the config file when you install via nuget manager but doesn’t…

The entityFramework section was automatically added to the configuration file of your project when you installed the EntityFramework NuGet package.

Frustrating but I can work around that, not my first

app.config

.

However what confuses me further down in the Entity Framework docs is the provider registration. Nuget was supposed to install a reference to

EntityFramework.SqlServer

, but it never did. I could also not install it via nuget package manager. I managed to find it in nuget.org but is unlisted and hasn’t been updated since 2015

Question

Do I still even need

EntityFramework.SqlServer

? I can easily add it in if I have too but is this the correct approach? Do people still use this old .dll out in the real world/prod?

I am curious to see how one with more experience with ET 6 would configure a fresh project.

UPDATE – DEC-9-2019

So digging into a little more, this behaviour doesn’t work if you’re installing Nuget packages with PackageReference rather than Package.config. You can change it by navigating to Tools –> Options–> Nuget Package Manager –> General –> Default package management format

Here we will install Entity Framework Core 7 in the .NET 7 (also known as .NET Core 7) console application. EF Core 7 is the latest version of Entity Framework as of this writing. You can install EF Core 6.0 which has a long term support in the same way.

EF Core 6/7 is not included as a default package in .NET 7. We need to install it via the NuGet package.

The

Microsoft.EntityFrameworkCore

is the base package for all the basic operations of EF Core.
However, you have to install a database provider package from NuGet for the database you use in your project.
For example, to use the MS SQL Server database, you need to install

Microsoft.EntityframeworkCore.SqlServer

package.

The database provider package of EF Core includes all the other dependent packages it needs. So, it includes

Microsoft.EntityFrameworkCore

too. So, no need to install it separately.

EF Core supports the following database providers.

Database DB Provider Package
MS SQL Server Microsoft.EntityframeworkCore.SqlServer
SQLite Microsoft.EntityFrameworkCore.Sqlite
Cosmos Microsoft.EntityFrameworkCore.Cosmos
In-Memory Microsoft.EntityFrameworkCore.InMemory
MySQL MySql.EntityFrameworkCore https://www.nuget.org/packages/MySql.EntityFrameworkCore/
PostgreSQL Npgsql.EntityFrameworkCore.PostgreSQL

Here we will use the local SQL Server database in the following .NET 7 console application, so we will install the

Microsoft.EntityframeworkCore.SqlServer

NuGet package. If you use different database, then you can install related NuGet package in the same way.

You can install EF Core NuGet package in your project using the following ways:

To install EF Core 6/7 package using NPM, go to the Project menu and click on “Manage NuGet Packages..â€.

This will open Nuget Package Manager, as shown below.

Click on the Browser tab and search for “entityframeworkcore” in the search box. It will display all the packages related to EF Core, as shown below.

We are going to use SQL Server for our project, so select the

Microsoft.EntityFrameworkCore.SqlServer

package and click on the Install button in the right pane.

Accept the license agreement to install the package in your project. Once installed, you will see the package is listed as a dependency package in the solution explorer, as shown below.

You can also see it in the .csproj file by double-clicking on your project name “EFCoreTutorialsConsoleâ€.

EF Core 6/7 can also be installed using Package Manager Console. To open the Package Manager Console. Go to Tools > NuGet Package Manager > Package Manager Console.

This will open the package manager console, as shown below.

Use the Install-Package command followed by the package name to install any NuGet package in your project. Make sure that it points to a project where you want to install the project.

To install the EF Core database provider for SQL Server, execute the following command:

Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 7.0.11

This will install EF Core SQL Server provider and all its dependencies to your project.

To install EF Core using the .NET CLI (Command Line Interface), open your terminal or command prompt and navigate to your project directory. This should be the directory that contains your project’s .csproj file.

Install the EF Core package for SQL Server using the following command.

dotnet add package Microsoft.EntityFrameworkCore.SqlServer –version 7.0.11

This will install the package in your project.

To install EF Core DB provider for SQL Server, open the PowerShell terminal in Visual Studio 2022 by right-clicking on the project and clicking “Open Terminal†from the context menu. It will point to your project directory by default, as shown below.

You can use .NET CLI command here. Use the dotnet add package command to install any NuGet package in your project. To install EF Core DB provider for SQL Server, execute the following command.

dotnet add package Microsoft.EntityFrameworkCore.SqlServer –version 7.0.11

This will install the package in your project.

You can simply add the package reference in your .csproj file. Double-click on your project name in Visual Studio to open .csproj file.

Now, add an

ItemGroup

element after

PropertyGroup

. In the

ItemGroup

element, add a

PackageReference

element and specify the PackageId as

"Microsoft.EntityFrameworkCore.SqlServer"

and specify the

Version

attribute to the desired version, in this case “7.0.11”, as shown below.

Save the file and you will see that the package is automatically added to your project dependencies.

Thus, you can install EF Core package in different ways as per your convenience.

After installing EF Core DB provider for SQL Server, let’s create entities next.

Microsoft.EntityFrameworkCore

8.0.2

See the version list below for details.

Requires NuGet 3.6 or higher.

dotnet add package Microsoft.EntityFrameworkCore –version 8.0.2

NuGet\Install-Package Microsoft.EntityFrameworkCore -Version 8.0.2

paket add Microsoft.EntityFrameworkCore –version 8.0.2

#r “nuget: Microsoft.EntityFrameworkCore, 8.0.2”

// Install Microsoft.EntityFrameworkCore as a Cake Addin #addin nuget:?package=Microsoft.EntityFrameworkCore&version=8.0.2 // Install Microsoft.EntityFrameworkCore as a Cake Tool #tool nuget:?package=Microsoft.EntityFrameworkCore&version=8.0.2

Entity Framework Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations. EF Core works with SQL Server, Azure SQL Database, SQLite, Azure Cosmos DB, MySQL, PostgreSQL, and other databases through a provider plugin API.Commonly Used Types:Microsoft.EntityFrameworkCore.DbContextMicrosoft.EntityFrameworkCore.DbSet

Product Versions 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.
  • net8.0
    • Microsoft.EntityFrameworkCore.Abstractions (>= 8.0.2)
    • Microsoft.EntityFrameworkCore.Analyzers (>= 8.0.2)
    • Microsoft.Extensions.Caching.Memory (>= 8.0.0)
    • Microsoft.Extensions.Logging (>= 8.0.0)

NuGet packages (7.2K)

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

Package Downloads
Microsoft.EntityFrameworkCore.Relational

Shared Entity Framework Core components for relational database providers.

Microsoft.EntityFrameworkCore.InMemory

In-memory database provider for Entity Framework Core (to be used for testing purposes).

Npgsql.EntityFrameworkCore.PostgreSQL

PostgreSQL/Npgsql provider for Entity Framework Core.

Microsoft.EntityFrameworkCore.Proxies

Lazy loading proxies for Entity Framework Core.

Microsoft.AspNetCore.App

Provides a default set of APIs for building an ASP.NET Core application. This package requires the ASP.NET Core runtime. This runtime is installed by the .NET Core SDK, or can be acquired separately using installers available at https://aka.ms/dotnet-download.

GitHub repositories (526)

Showing the top 5 popular GitHub repositories that depend on Microsoft.EntityFrameworkCore:

Repository Stars
jasontaylordev/CleanArchitecture

Clean Architecture Solution Template for ASP.NET Core

dotnet/AspNetCore.Docs

Documentation for ASP.NET Core

abpframework/abp

Open Source Web Application Framework for ASP.NET Core. Offers an opinionated architecture to build enterprise software solutions with best practices on top of the .NET and the ASP.NET Core platforms. Provides the fundamental infrastructure, production-ready startup templates, application modules, UI themes, tooling, guides and documentation.

aspnetboilerplate/aspnetboilerplate

ASP.NET Boilerplate – Web Application Framework

kgrzybek/modular-monolith-with-ddd

Full Modular Monolith application with Domain-Driven Design approach.

Version Downloads Last updated
9.0.0-preview.1.24081.2 2,397 2/13/2024
8.0.2 101,127 2/13/2024
8.0.1 2,122,057 1/9/2024
8.0.0 4,349,751 11/14/2023
8.0.0-rc.2.23480.1 277,177 10/10/2023
8.0.0-rc.1.23419.6 104,091 9/12/2023
8.0.0-preview.7.23375.4 60,517 8/8/2023
8.0.0-preview.6.23329.4 94,357 7/11/2023
8.0.0-preview.5.23280.1 91,848 6/13/2023
8.0.0-preview.4.23259.3 92,201 5/16/2023
8.0.0-preview.3.23174.2 122,737 4/11/2023
8.0.0-preview.2.23128.3 128,075 3/14/2023
8.0.0-preview.1.23111.4 116,641 2/21/2023
7.0.16 35,272 2/13/2024
7.0.15 792,632 1/9/2024
7.0.14 2,403,021 11/14/2023
7.0.13 3,041,106 10/24/2023
7.0.12 2,398,324 10/10/2023
7.0.11 6,210,490 9/12/2023
7.0.10 5,805,422 8/8/2023
7.0.9 5,104,322 7/11/2023
7.0.8 3,600,216 6/22/2023
7.0.7 2,554,085 6/13/2023
7.0.5 16,872,391 4/11/2023
7.0.4 7,045,375 3/14/2023
7.0.3 9,688,693 2/14/2023
7.0.2 12,192,705 1/10/2023
7.0.1 7,353,843 12/13/2022
7.0.0 15,943,676 11/7/2022
7.0.0-rc.2.22472.11 183,816 10/11/2022
7.0.0-rc.1.22426.7 190,343 9/14/2022
7.0.0-preview.7.22376.2 80,868 8/9/2022
7.0.0-preview.6.22329.4 59,940 7/12/2022
7.0.0-preview.5.22302.2 55,114 6/14/2022
7.0.0-preview.4.22229.2 69,014 5/10/2022
7.0.0-preview.3.22175.1 69,807 4/13/2022
7.0.0-preview.2.22153.1 80,545 3/14/2022
7.0.0-preview.1.22076.6 48,801 2/17/2022
6.0.27 22,388 2/13/2024
6.0.26 498,717 1/9/2024
6.0.25 1,134,946 11/14/2023
6.0.24 763,534 10/24/2023
6.0.23 615,051 10/10/2023
6.0.22 1,453,492 9/12/2023
6.0.21 1,751,970 8/8/2023
6.0.20 1,599,616 7/11/2023
6.0.19 1,263,553 6/22/2023
6.0.18 783,212 6/13/2023
6.0.16 4,648,080 4/11/2023
6.0.15 2,814,023 3/14/2023
6.0.14 3,438,429 2/14/2023
6.0.13 4,842,120 1/10/2023
6.0.12 6,833,039 12/13/2022
6.0.11 7,185,042 11/7/2022
6.0.10 12,850,307 10/11/2022
6.0.9 11,613,357 9/13/2022
6.0.8 13,790,202 8/9/2022
6.0.7 35,316,983 7/12/2022
6.0.6 11,450,156 6/14/2022
6.0.5 17,511,946 5/10/2022
6.0.4 13,901,094 4/11/2022
6.0.3 18,194,332 3/8/2022
6.0.2 15,985,944 2/8/2022
6.0.1 25,705,550 12/14/2021
6.0.0 44,138,288 11/8/2021
6.0.0-rc.2.21480.5 295,504 10/12/2021
6.0.0-rc.1.21452.10 175,239 9/14/2021
6.0.0-preview.7.21378.4 85,353 8/10/2021
6.0.0-preview.6.21352.1 40,726 7/14/2021
6.0.0-preview.5.21301.9 166,613 6/15/2021
6.0.0-preview.4.21253.1 69,907 5/24/2021
6.0.0-preview.3.21201.2 88,802 4/8/2021
6.0.0-preview.2.21154.2 61,975 3/11/2021
6.0.0-preview.1.21102.2 89,065 2/12/2021
5.0.17 5,315,663 5/10/2022
5.0.16 1,251,887 4/11/2022
5.0.15 1,906,204 3/8/2022
5.0.14 2,129,285 2/8/2022
5.0.13 3,839,728 12/14/2021
5.0.12 4,273,044 11/7/2021
5.0.11 7,406,417 10/12/2021
5.0.10 11,778,259 9/14/2021
5.0.9 9,231,186 8/10/2021
5.0.8 8,342,415 7/13/2021
5.0.7 12,802,879 6/8/2021
5.0.6 7,399,671 5/11/2021
5.0.5 10,200,832 4/6/2021
5.0.4 7,590,816 3/9/2021
5.0.3 7,559,243 2/9/2021
5.0.2 9,811,500 1/12/2021
5.0.1 14,250,627 12/8/2020
5.0.0 22,250,913 11/9/2020
5.0.0-rc.2.20475.6 362,874 10/13/2020
5.0.0-rc.1.20451.13 311,669 9/14/2020
5.0.0-preview.8.20407.4 192,957 8/25/2020
5.0.0-preview.7.20365.15 109,645 7/21/2020
5.0.0-preview.6.20312.4 61,027 6/25/2020
5.0.0-preview.5.20278.2 44,732 6/10/2020
5.0.0-preview.4.20220.10 70,036 5/18/2020
5.0.0-preview.3.20181.2 90,030 4/23/2020
5.0.0-preview.2.20159.4 58,619 4/2/2020
5.0.0-preview.2.20120.8 44,709 3/16/2020
3.1.32 2,155,156 12/13/2022
3.1.31 501,150 11/8/2022
3.1.30 501,453 10/11/2022
3.1.29 703,563 9/13/2022
3.1.28 582,073 8/9/2022
3.1.27 563,334 7/12/2022
3.1.26 489,389 6/14/2022
3.1.25 873,939 5/10/2022
3.1.24 556,889 4/11/2022
3.1.23 885,425 3/8/2022
3.1.22 2,647,559 12/14/2021
3.1.21 2,146,797 11/7/2021
3.1.20 1,193,756 10/11/2021
3.1.19 2,057,491 9/14/2021
3.1.18 4,577,140 8/10/2021
3.1.17 1,658,194 7/13/2021
3.1.16 2,060,092 6/8/2021
3.1.15 2,399,300 5/11/2021
3.1.14 2,829,554 4/6/2021
3.1.13 4,058,669 3/9/2021
3.1.12 2,735,363 2/9/2021
3.1.11 4,941,993 1/12/2021
3.1.10 7,783,899 11/9/2020
3.1.9 11,166,914 10/13/2020
3.1.8 16,638,570 9/8/2020
3.1.7 9,025,652 8/11/2020
3.1.6 9,984,380 7/14/2020
3.1.5 11,833,304 6/9/2020
3.1.4 16,550,471 5/12/2020
3.1.3 25,389,978 3/24/2020
3.1.2 11,072,971 2/19/2020
3.1.1 17,676,131 1/14/2020
3.1.0 30,044,314 12/3/2019
3.1.0-preview3.19554.8 157,008 11/13/2019
3.1.0-preview2.19525.5 31,477 11/1/2019
3.1.0-preview1.19506.2 686,591 10/15/2019
3.0.3 167,346 2/19/2020
3.0.2 72,518 1/14/2020
3.0.1 1,317,822 11/18/2019
3.0.0 16,987,744 9/23/2019
3.0.0-rc1.19456.14 45,370 9/16/2019
3.0.0-preview9.19423.6 1,291,174 9/4/2019
3.0.0-preview8.19405.11 383,413 8/13/2019
3.0.0-preview7.19362.6 86,014 7/23/2019
3.0.0-preview6.19304.10 155,839 6/12/2019
3.0.0-preview5.19227.1 625,964 5/6/2019
3.0.0-preview4.19216.3 21,882 4/18/2019
3.0.0-preview3.19153.1 191,579 3/6/2019
3.0.0-preview.19074.3 29,948 1/29/2019
3.0.0-preview.18572.1 46,024 12/3/2018
2.2.6 29,224,000 7/9/2019
2.2.4 18,412,464 4/9/2019
2.2.3 5,105,651 3/11/2019
2.2.2 6,092,545 2/12/2019
2.2.1 6,559,832 1/8/2019
2.2.0 19,047,814 12/3/2018
2.2.0-preview3-35497 177,374 10/17/2018
2.2.0-preview2-35157 135,373 9/12/2018
2.2.0-preview1-35029 75,437 8/22/2018
2.1.14 3,554,521 11/18/2019
2.1.11 3,575,041 5/14/2019
2.1.8 3,408,080 2/12/2019
2.1.4 14,823,293 10/1/2018
2.1.3 4,731,897 9/11/2018
2.1.2 7,829,454 8/21/2018
2.1.1 13,502,386 6/18/2018
2.1.0 12,122,710 5/29/2018
2.1.0-rc1-final 202,808 5/6/2018
2.1.0-preview2-final 175,879 4/10/2018
2.1.0-preview1-final 293,580 2/26/2018
2.0.3 4,972,893 5/7/2018
2.0.2 6,241,085 3/13/2018
2.0.1 11,692,997 11/14/2017
2.0.0 23,303,333 8/11/2017
2.0.0-preview2-final 85,109 6/28/2017
2.0.0-preview1-final 1,048,459 5/10/2017
1.1.6 4,749,958 7/10/2018
1.1.5 1,158,082 12/12/2017
1.1.4 204,190 11/14/2017
1.1.3 290,491 9/20/2017
1.1.2 4,208,732 5/9/2017
1.1.1 2,727,512 3/6/2017
1.1.0 5,625,280 11/16/2016
1.1.0-preview1-final 40,087 10/24/2016
1.0.6 44,480 11/14/2017
1.0.5 34,507 9/20/2017
1.0.4 48,886 5/9/2017
1.0.3 544,728 3/6/2017
1.0.2 72,662 12/12/2016
1.0.1 605,425 9/13/2016
1.0.0 1,206,867 6/27/2016
1.0.0-rc2-final 123,595 5/16/2016

Installing Entity Framework Core

.Net Core Web API + EF Core + PostgreSQL  - CRUD API | Core Knowledge Sharing
.Net Core Web API + EF Core + PostgreSQL – CRUD API | Core Knowledge Sharing

Upgrading to the latest EF Core

  • Any time we release a new version of EF Core, we also release a new version of the providers that are part of the EF Core project, like Microsoft.EntityFrameworkCore.SqlServer, Microsoft.EntityFrameworkCore.Sqlite, Microsoft.EntityFrameworkCore.Cosmos, and Microsoft.EntityFrameworkCore.InMemory. You can just upgrade to the new version of the provider to get all the improvements.

  • If you need to update an application that is using a third-party database provider, always check for an update of the provider that is compatible with the version of EF Core you want to use. For example, database providers for version 1.0 are not compatible with version 2.0 of the EF Core runtime, and so on.

  • Third-party providers for EF Core usually don’t release patch versions alongside the EF Core runtime. To upgrade an application that uses a third-party provider to a patch version of EF Core, you may need to add a direct reference to individual EF Core runtime components, most notably Microsoft.EntityFrameworkCore, and Microsoft.EntityFrameworkCore.Relational.

Packages for database provider testing

\n

The following packages are used to test database providers built in external GitHub repositories. See

efcore.pg

and

Pomelo.EntityFrameworkCore.MySql

for examples. Applications should not install these packages.

\n\n\n\nFunctionality\nPackage\n\n\n\n\nTests for any database provider\n

Microsoft.EntityFrameworkCore.Specification.Tests

\n\n\nTests for relational database providers\n

Microsoft.EntityFrameworkCore.Relational.Specification.Tests

\n\n\n\n

Working with an Existing Database [2 of 5] | Entity Framework Core for Beginners
Working with an Existing Database [2 of 5] | Entity Framework Core for Beginners

Keywords searched by users: nuget entity framework core sql server

Nuget Gallery | Microsoft.Entityframeworkcore.Sqlserver 8.0.2
Nuget Gallery | Microsoft.Entityframeworkcore.Sqlserver 8.0.2
Installing Entity Framework Core
Installing Entity Framework Core
Install Entity Framework Core
Install Entity Framework Core
How To Get Entity Framework Core
How To Get Entity Framework Core
Install Entity Framework Core
Install Entity Framework Core
Visual Studio - Can'T Install Microsoft.Entityframeworkcore.Sqlserver For A  .Net 4.7.2 Framework Project - Stack Overflow
Visual Studio – Can’T Install Microsoft.Entityframeworkcore.Sqlserver For A .Net 4.7.2 Framework Project – Stack Overflow
Sql Server - Learn Ef Core 8
Sql Server – Learn Ef Core 8
How To Install Entity Framework Core | Freecode Spot
How To Install Entity Framework Core | Freecode Spot
Working With Data Using Entity Framework Core
Working With Data Using Entity Framework Core
Exploring Entity Framework Core 5
Exploring Entity Framework Core 5
How To Get Entity Framework Core
How To Get Entity Framework Core
Net - Installing Microsoft.Entityframeworkcore.Tools - Stack Overflow
Net – Installing Microsoft.Entityframeworkcore.Tools – Stack Overflow
Nuget Gallery | Pomelo.Entityframeworkcore.Lolita.Sqlserver 6.0.5
Nuget Gallery | Pomelo.Entityframeworkcore.Lolita.Sqlserver 6.0.5
Entity Framework Core | Complete Guide To Entity Framework Core
Entity Framework Core | Complete Guide To Entity Framework Core

See more here: kientrucannam.vn

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *