Microsoft.EntityFrameworkCore 9.0.0

Entity Framework Core (EF Core) is a modern object-database mapper that lets you build a clean, portable, and high-level data access layer with .NET (C#) across a variety of databases, including SQL Server (on-premises and Azure), SQLite, MySQL, PostgreSQL, Oracle, and Azure Cosmos DB. It supports LINQ queries, change tracking, updates, and schema migrations.

Getting started

Prerequisites

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.

Usage

To use Microsoft.EntityFrameworkCore in your application, you will typically need to create a class that inherits from DbContext, which represents your database session. You can then define classes that represent your database entities, and use LINQ queries to interact with the database.

Here's an example of how you might define a database context and an entity:

using Microsoft.EntityFrameworkCore;

public class MyDbContext : DbContext
{
    public DbSet<Customer> Customers { get; set; }
}

public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
}

You can then use the MyDbContext class to interact with the database:

using var context = new MyDbContext();

// Add a new customer
context.Customers.Add(new Customer { Name = "John Doe" });
context.SaveChanges();

// Retrieve all customers
var customers = context.Customers.ToList();

Microsoft.EntityFrameworkCore supports multiple database providers, including SQL Server, MySQL, PostgreSQL, SQLite, and others. You will need to install the provider package for your chosen database. For example, to use SQL Server, you would install the Microsoft.EntityFrameworkCore.SqlServer package.

You would then configure your database context to use the SQL Server provider:

using Microsoft.EntityFrameworkCore;

public class MyDbContext : DbContext
{
    protected override void OnConfiguring(DbContextOptionsBuilder options)
        => options.UseSqlServer(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=MyDatabase");

    public DbSet<Customer> Customers { get; set; }
}

public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
}

Additional documentation

Feedback

If you have a specific question about using these projects, we encourage you to ask it on Stack Overflow. If you encounter a bug or would like to request a feature, submit an Github issue. For more details, see getting support.

Showing the top 20 packages that depend on Microsoft.EntityFrameworkCore.

Packages Downloads
DHP.Core
Package Description
96
EFCore.NamingConventions
Naming Conventions for Entity Framework Core Tables and Columns.
79
EFCore.NamingConventions
Naming Conventions for Entity Framework Core Tables and Columns.
92
EFCore.NamingConventions
Naming Conventions for Entity Framework Core Tables and Columns.
311
Microsoft.AspNetCore.DataProtection.EntityFrameworkCore
Support for storing keys using Entity Framework Core. This package was built from the source code at https://github.com/dotnet/aspnetcore/tree/b8139c5ee58f1708b0e3368a1b241400edd6cbc4
67
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
68
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
70
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
71
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
74
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
81
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
84
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
89
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
93
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
95
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
128
Npgsql.EntityFrameworkCore.PostgreSQL
PostgreSQL/Npgsql provider for Entity Framework Core.
59
Npgsql.EntityFrameworkCore.PostgreSQL
PostgreSQL/Npgsql provider for Entity Framework Core.
72
Npgsql.EntityFrameworkCore.PostgreSQL
PostgreSQL/Npgsql provider for Entity Framework Core.
94
Npgsql.EntityFrameworkCore.PostgreSQL
PostgreSQL/Npgsql provider for Entity Framework Core.
177
Npgsql.EntityFrameworkCore.PostgreSQL
PostgreSQL/Npgsql provider for Entity Framework Core.
189

Version Downloads Last updated
9.0.0 11 11/14/2024
9.0.0-rc.2.24474.1 6 10/23/2024
9.0.0-rc.1.24451.1 6 09/19/2024
9.0.0-preview.7.24405.3 5 08/22/2024
9.0.0-preview.6.24327.4 32 07/22/2024
9.0.0-preview.5.24306.3 20 07/18/2024
9.0.0-preview.4.24267.1 35 07/22/2024
9.0.0-preview.3.24172.4 35 07/22/2024
9.0.0-preview.2.24128.4 24 07/22/2024
9.0.0-preview.1.24081.2 18 07/22/2024
8.0.11 11 11/14/2024
8.0.10 31 10/14/2024
8.0.8 43 08/22/2024
8.0.7 46 07/22/2024
8.0.6 35 06/27/2024
8.0.5 38 07/22/2024
8.0.4 76 06/27/2024
8.0.3 27 07/22/2024
8.0.2 73 02/15/2024
8.0.1 112 02/04/2024
8.0.0 75 02/04/2024
8.0.0-rc.2.23480.1 24 07/22/2024
8.0.0-rc.1.23419.6 26 07/22/2024
8.0.0-preview.7.23375.4 21 07/22/2024
8.0.0-preview.6.23329.4 28 07/22/2024
8.0.0-preview.5.23280.1 32 07/22/2024
8.0.0-preview.4.23259.3 25 07/22/2024
8.0.0-preview.3.23174.2 25 07/22/2024
8.0.0-preview.2.23128.3 28 07/22/2024
8.0.0-preview.1.23111.4 31 07/22/2024
7.0.20 39 07/22/2024
7.0.19 28 07/22/2024
7.0.18 34 07/22/2024
7.0.17 27 07/22/2024
7.0.16 38 07/22/2024
7.0.15 27 07/22/2024
7.0.14 32 07/22/2024
7.0.13 20 07/22/2024
7.0.12 29 07/22/2024
7.0.11 28 07/22/2024
7.0.10 29 07/22/2024
7.0.9 32 02/04/2024
7.0.8 25 07/22/2024
7.0.7 32 07/22/2024
7.0.5 30 07/22/2024
7.0.4 27 07/22/2024
7.0.3 86 02/04/2024
7.0.2 80 02/04/2024
7.0.1 30 07/22/2024
7.0.0 32 02/04/2024
7.0.0-rc.2.22472.11 31 07/22/2024
7.0.0-rc.1.22426.7 26 07/22/2024
7.0.0-preview.7.22376.2 30 07/22/2024
7.0.0-preview.6.22329.4 23 07/22/2024
7.0.0-preview.5.22302.2 27 07/22/2024
7.0.0-preview.4.22229.2 22 07/22/2024
7.0.0-preview.3.22175.1 39 07/20/2024
7.0.0-preview.2.22153.1 30 07/22/2024
7.0.0-preview.1.22076.6 35 07/22/2024
6.0.36 8 11/14/2024
6.0.35 5 10/23/2024
6.0.33 6 08/22/2024
6.0.32 32 07/22/2024
6.0.31 33 07/22/2024
6.0.30 29 07/22/2024
6.0.29 27 07/22/2024
6.0.28 26 07/22/2024
6.0.27 31 07/22/2024
6.0.26 35 07/22/2024
6.0.25 24 07/22/2024
6.0.24 27 07/22/2024
6.0.23 24 07/22/2024
6.0.22 30 07/22/2024
6.0.21 34 07/22/2024
6.0.20 36 07/22/2024
6.0.19 32 07/07/2024
6.0.18 28 07/22/2024
6.0.16 27 07/22/2024
6.0.15 33 07/22/2024
6.0.14 29 07/22/2024
6.0.13 29 07/22/2024
6.0.12 31 07/22/2024
6.0.11 25 07/22/2024
6.0.10 30 07/22/2024
6.0.9 27 07/22/2024
6.0.8 28 07/22/2024
6.0.7 27 04/17/2024
6.0.6 60 02/09/2024
6.0.5 28 04/17/2024
6.0.4 29 07/22/2024
6.0.3 57 02/04/2024
6.0.2 33 07/22/2024
6.0.1 69 02/04/2024
6.0.0 62 02/04/2024
6.0.0-rc.2.21480.5 28 07/22/2024
6.0.0-rc.1.21452.10 25 07/22/2024
6.0.0-preview.7.21378.4 37 07/21/2024
6.0.0-preview.6.21352.1 31 07/22/2024
6.0.0-preview.5.21301.9 30 07/22/2024
6.0.0-preview.4.21253.1 34 07/22/2024
6.0.0-preview.3.21201.2 29 07/22/2024
6.0.0-preview.2.21154.2 30 07/22/2024
6.0.0-preview.1.21102.2 28 07/22/2024
5.0.17 35 07/22/2024
5.0.16 25 07/22/2024
5.0.15 29 07/22/2024
5.0.14 30 07/22/2024
5.0.13 24 07/22/2024
5.0.12 21 07/22/2024
5.0.11 25 07/22/2024
5.0.10 35 07/22/2024
5.0.9 29 07/22/2024
5.0.8 30 07/22/2024
5.0.7 31 07/11/2024
5.0.6 30 07/22/2024
5.0.5 32 07/22/2024
5.0.4 19 07/22/2024
5.0.3 19 07/18/2024
5.0.2 36 07/22/2024
5.0.1 24 07/22/2024
5.0.0 17 07/22/2024
5.0.0-rc.2.20475.6 34 07/22/2024
5.0.0-rc.1.20451.13 26 07/22/2024
5.0.0-preview.8.20407.4 32 07/22/2024
5.0.0-preview.7.20365.15 21 07/22/2024
5.0.0-preview.6.20312.4 26 07/22/2024
5.0.0-preview.5.20278.2 35 07/22/2024
5.0.0-preview.4.20220.10 23 07/22/2024
5.0.0-preview.3.20181.2 33 07/22/2024
5.0.0-preview.2.20159.4 26 07/22/2024
5.0.0-preview.2.20120.8 26 07/22/2024
3.1.32 27 07/22/2024
3.1.31 28 07/22/2024
3.1.30 33 07/12/2024
3.1.29 28 07/22/2024
3.1.28 33 07/22/2024
3.1.27 31 07/22/2024
3.1.26 31 07/22/2024
3.1.25 35 07/22/2024
3.1.24 20 07/22/2024
3.1.23 32 07/22/2024
3.1.22 26 07/22/2024
3.1.21 24 07/22/2024
3.1.20 33 07/22/2024
3.1.19 24 07/22/2024
3.1.18 31 07/22/2024
3.1.17 32 07/22/2024
3.1.16 32 07/22/2024
3.1.15 31 07/22/2024
3.1.14 26 07/22/2024
3.1.13 30 07/22/2024
3.1.12 25 07/22/2024
3.1.11 31 07/22/2024
3.1.10 42 07/22/2024
3.1.9 28 07/22/2024
3.1.8 32 07/22/2024
3.1.7 30 07/22/2024
3.1.6 37 07/22/2024
3.1.5 33 07/22/2024
3.1.4 28 07/22/2024
3.1.3 30 07/22/2024
3.1.2 30 07/22/2024
3.1.1 28 07/22/2024
3.1.0 31 07/24/2024
3.1.0-preview3.19554.8 25 07/22/2024
3.1.0-preview2.19525.5 30 07/22/2024
3.1.0-preview1.19506.2 25 07/22/2024
3.0.3 22 07/22/2024
3.0.2 28 07/22/2024
3.0.1 28 07/22/2024
3.0.0 30 07/22/2024
3.0.0-rc1.19456.14 34 07/22/2024
3.0.0-preview9.19423.6 32 07/22/2024
3.0.0-preview8.19405.11 37 07/22/2024
3.0.0-preview7.19362.6 24 07/22/2024
3.0.0-preview6.19304.10 26 07/22/2024
3.0.0-preview5.19227.1 24 07/22/2024
3.0.0-preview4.19216.3 27 07/22/2024
3.0.0-preview3.19153.1 30 07/22/2024
3.0.0-preview.19074.3 30 07/22/2024
3.0.0-preview.18572.1 27 07/22/2024
2.2.6 27 07/22/2024
2.2.4 37 07/22/2024
2.2.3 35 07/22/2024
2.2.2 31 07/22/2024
2.2.1 40 07/22/2024
2.2.0 27 07/22/2024
2.2.0-preview3-35497 21 07/22/2024
2.2.0-preview2-35157 31 07/22/2024
2.2.0-preview1-35029 35 07/22/2024
2.1.14 37 07/22/2024
2.1.11 31 07/22/2024
2.1.8 31 07/22/2024
2.1.4 34 07/22/2024
2.1.3 34 07/22/2024
2.1.2 32 07/22/2024
2.1.1 37 07/22/2024
2.1.0 30 07/22/2024
2.1.0-rc1-final 33 07/22/2024
2.1.0-preview2-final 28 07/22/2024
2.1.0-preview1-final 36 07/22/2024
2.0.3 30 07/22/2024
2.0.2 28 07/22/2024
2.0.1 29 07/22/2024
2.0.0 42 07/22/2024
2.0.0-preview2-final 35 07/22/2024
2.0.0-preview1-final 31 07/22/2024
1.1.6 45 07/22/2024
1.1.5 40 07/22/2024
1.1.4 27 07/22/2024
1.1.3 35 07/17/2024
1.1.2 25 07/22/2024
1.1.1 37 07/22/2024
1.1.0 33 07/22/2024
1.1.0-preview1-final 24 07/22/2024
1.0.6 29 07/22/2024
1.0.5 33 07/22/2024
1.0.4 31 07/22/2024
1.0.3 41 07/22/2024
1.0.2 36 07/22/2024
1.0.1 31 07/22/2024
1.0.0 38 07/22/2024
1.0.0-rc2-final 28 07/22/2024