Microsoft.EntityFrameworkCore 8.0.8

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
EntityFrameworkCore.DataEncryption
A plugin for Microsoft.EntityFrameworkCore to add support of encrypted fields using built-in or custom encryption providers.
125
EntityFrameworkCore.DataEncryption
A plugin for Microsoft.EntityFrameworkCore to add support of encrypted fields using built-in or custom encryption providers.
229
EntityFrameworkCore.DataEncryption
A plugin for Microsoft.EntityFrameworkCore to add support of encrypted fields using built-in or custom encryption providers.
14,339
Microsoft.EntityFrameworkCore.DynamicLinq
Dynamic Linq extensions for Microsoft.EntityFrameworkCore which adds Async support
148
Microsoft.EntityFrameworkCore.Proxies
Lazy-loading proxies for EF Core.
5,538
Microsoft.EntityFrameworkCore.Proxies
Lazy-loading proxies for EF Core.
9,182
Microsoft.EntityFrameworkCore.Proxies
Lazy loading proxies for Entity Framework Core.
100
Microsoft.EntityFrameworkCore.Proxies
Lazy loading proxies for Entity Framework Core.
117
Microsoft.EntityFrameworkCore.Proxies
Lazy loading proxies for Entity Framework Core.
168
Microsoft.EntityFrameworkCore.Proxies
Lazy loading proxies for Entity Framework Core.
244
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
104
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
112
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
166
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
233
Microsoft.EntityFrameworkCore.Relational
Shared Entity Framework Core components for relational database providers.
9,147
Quantum.Framework.Core.StandardLib
Package Description
85
Quantum.Framework.Core.StandardLib
Package Description
114
Quantum.Framework.Core.StandardLib
Package Description
153
Quantum.Framework.Core.StandardLib
Package Description
164
Quantum.Framework.Core.StandardLib
Package Description
171

Version Downloads Last updated
9.0.0 7 12/01/2024
9.0.0-rc.2.24474.1 5 11/05/2024
9.0.0-rc.1.24451.1 4 11/14/2024
9.0.0-preview.7.24405.3 4 11/21/2024
9.0.0-preview.6.24327.4 4 11/24/2024
9.0.0-preview.5.24306.3 7 11/09/2024
9.0.0-preview.4.24267.1 13 05/23/2024
9.0.0-preview.3.24172.4 10 04/16/2024
9.0.0-preview.2.24128.4 13 04/27/2024
9.0.0-preview.1.24081.2 13 05/02/2024
8.0.11 14 12/04/2024
8.0.10 5 11/04/2024
8.0.8 7 11/25/2024
8.0.7 1 12/24/2024
8.0.6 8 11/25/2024
8.0.5 202 05/18/2024
8.0.4 171 04/16/2024
8.0.3 9 05/22/2024
8.0.2 14 04/16/2024
8.0.1 9 01/25/2024
8.0.0 124 12/02/2023
8.0.0-rc.2.23480.1 13 05/15/2024
8.0.0-rc.1.23419.6 5 12/03/2024
8.0.0-preview.7.23375.4 7 11/21/2024
8.0.0-preview.6.23329.4 8 07/28/2023
8.0.0-preview.3.23174.2 6 11/22/2024
8.0.0-preview.2.23128.3 4 11/25/2024
8.0.0-preview.1.23111.4 10 05/06/2024
7.0.20 7 11/21/2024
7.0.19 110 05/18/2024
7.0.18 9 05/09/2024
7.0.17 9 04/16/2024
7.0.16 12 04/16/2024
7.0.15 12 01/25/2024
7.0.14 14 12/06/2023
7.0.13 13 05/29/2024
7.0.12 13 04/16/2024
7.0.11 10 04/16/2024
7.0.10 15 08/22/2023
7.0.9 16 08/21/2023
7.0.8 9 05/09/2024
7.0.7 8 05/06/2024
7.0.5 7 05/08/2024
7.0.4 13 05/14/2024
7.0.2 15 12/07/2023
7.0.1 12 08/14/2023
7.0.0-rc.2.22472.11 12 05/15/2024
7.0.0-rc.1.22426.7 10 05/02/2024
7.0.0-preview.7.22376.2 3 11/26/2024
7.0.0-preview.6.22329.4 10 05/09/2024
7.0.0-preview.5.22302.2 10 05/11/2024
7.0.0-preview.4.22229.2 11 05/05/2024
7.0.0-preview.3.22175.1 3 11/24/2024
7.0.0-preview.2.22153.1 3 11/14/2024
7.0.0-preview.1.22076.6 6 11/10/2024
6.0.36 2 12/02/2024
6.0.35 6 11/25/2024
6.0.33 5 10/31/2024
6.0.32 5 12/11/2024
6.0.31 3 11/25/2024
6.0.30 10 05/18/2024
6.0.29 7 05/11/2024
6.0.28 6 05/14/2024
6.0.27 6 05/24/2024
6.0.26 12 01/25/2024
6.0.25 13 12/10/2023
6.0.24 12 04/16/2024
6.0.23 12 05/05/2024
6.0.22 14 09/13/2023
6.0.21 14 09/08/2023
6.0.20 102 08/07/2023
6.0.19 11 05/15/2024
6.0.18 10 05/12/2024
6.0.15 9 05/09/2024
6.0.14 11 07/13/2023
6.0.13 11 05/03/2024
6.0.12 6 05/22/2024
6.0.10 9 05/14/2024
6.0.9 7 05/09/2024
6.0.8 8 05/09/2024
6.0.6 10 05/24/2024
6.0.5 15 08/04/2023
6.0.2 25 01/04/2024
6.0.1 12 05/05/2024
6.0.0-rc.2.21480.5 7 05/09/2024
6.0.0-rc.1.21452.10 3 12/09/2024
6.0.0-preview.6.21352.1 3 11/25/2024
6.0.0-preview.5.21301.9 7 11/21/2024
6.0.0-preview.4.21253.1 5 05/11/2024
6.0.0-preview.3.21201.2 6 05/01/2024
6.0.0-preview.2.21154.2 5 11/10/2024
6.0.0-preview.1.21102.2 6 11/10/2024
5.0.16 7 05/11/2024
5.0.13 9 05/22/2024
5.0.6 10 05/21/2024
5.0.3 9 05/06/2024
5.0.0-rc.2.20475.6 7 05/23/2024
5.0.0-rc.1.20451.13 3 11/26/2024
5.0.0-preview.6.20312.4 8 05/01/2024
5.0.0-preview.5.20278.2 7 11/09/2024
5.0.0-preview.4.20220.10 9 05/10/2024
5.0.0-preview.2.20159.4 6 11/25/2024
5.0.0-preview.2.20120.8 3 11/10/2024
3.1.31 7 11/09/2024
3.1.29 12 05/20/2024
3.1.28 11 05/25/2024
3.1.27 11 05/11/2024
3.1.26 4 11/09/2024
3.1.25 7 05/08/2024
3.1.22 6 05/30/2024
3.1.20 12 05/23/2024
3.1.13 18 03/11/2024
3.1.10 6 05/07/2024
3.1.8 8 05/11/2024
3.1.5 12 05/09/2024
3.1.0-preview2.19525.5 6 11/09/2024
3.1.0-preview1.19506.2 7 11/26/2024
3.0.3 10 05/18/2024
3.0.2 14 05/02/2024
3.0.1 7 05/27/2024
3.0.0-rc1.19456.14 11 05/03/2024
3.0.0-preview8.19405.11 5 11/09/2024
3.0.0-preview7.19362.6 9 05/06/2024
3.0.0-preview6.19304.10 8 05/09/2024
3.0.0-preview.19074.3 10 05/01/2024
3.0.0-preview.18572.1 9 05/05/2024
2.2.4 11 05/18/2024
2.2.0-preview3-35497 4 11/26/2024
2.2.0-preview2-35157 3 11/21/2024
2.1.8 7 05/29/2024
2.1.1 8 01/31/2024
2.1.0 7 05/21/2024
2.1.0-rc1-final 7 05/09/2024
2.1.0-preview1-final 6 05/07/2024
2.0.3 10 05/21/2024
2.0.0-preview2-final 10 05/13/2024
1.1.4 9 05/15/2024
1.1.1 10 01/31/2024
1.1.0-preview1-final 10 05/05/2024
1.0.6 5 11/09/2024
1.0.4 7 11/10/2024
1.0.2 10 05/08/2024
1.0.0 10 05/13/2024
1.0.0-rc2-final 10 05/02/2024