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
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
-
Microsoft.EntityFrameworkCore.Tools
for PowerShell tooling that works in the Visual Studio
Package Manager Console
-
dotnet-ef
and
Microsoft.EntityFrameworkCore.Design
for cross-platform command line tooling
\n
\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
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
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
- Microsoft.EntityFrameworkCore.Tools.DotNet
- Microsoft.EntityFrameworkCore.SqlServer.Design
- Microsoft.EntityFrameworkCore.Sqlite.Design
- Microsoft.EntityFrameworkCore.Relational.Design.Specification.Tests
\n
\n
\n
\n
\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”}
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.)
- The EF Core features needed
\n
\n
\n
The usual process for installing packages is:
\n
-
\n
-
Decide on a database provider and install the appropriate package (
see below
) -
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. -
Optionally, decide which kind of tooling you need and install the appropriate packages for that (
see below
)
\n
\n
\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
- Microsoft.EntityFrameworkCore.Tools.DotNet
- Microsoft.EntityFrameworkCore.SqlServer.Design
- Microsoft.EntityFrameworkCore.Sqlite.Design
- Microsoft.EntityFrameworkCore.Relational.Design.Specification.Tests
\n
\n
\n
\n
\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](https://i.ytimg.com/vi/SryQxUeChMc/hqdefault.jpg "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
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.
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
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
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
-
Microsoft.EntityFrameworkCore.Tools
for PowerShell tooling that works in the Visual Studio
Package Manager Console
-
dotnet-ef
and
Microsoft.EntityFrameworkCore.Design
for cross-platform command line tooling
\n
\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
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 |
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.)
- The EF Core features needed
\n
\n
\n
The usual process for installing packages is:
\n
-
\n
-
Decide on a database provider and install the appropriate package (
see below
) -
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. -
Optionally, decide which kind of tooling you need and install the appropriate packages for that (
see below
)
\n
\n
\n
\n
See Getting started tutorial for Entity Framework Core for help getting started with EF Core.
\n
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
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
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](https://i.ytimg.com/vi/DCYVfLT5_QI/hqdefault.jpg "Working with an Existing Database [2 of 5] | Entity Framework Core for Beginners")
Keywords searched by users: nuget entity framework core sql server
.png?alt=media "SQL Server - Learn EF Core 8")
See more here: kientrucannam.vn
See more: https://kientrucannam.vn/vn/