Skip to content

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.

License

Notifications You must be signed in to change notification settings

svengeance/EntityFrameworkCore

This branch is 3 commits ahead of, 6921 commits behind dotnet/efcore:main.

Folders and files

NameName
Last commit message
Last commit date
Nov 25, 2019
Dec 3, 2019
Nov 25, 2019
Dec 3, 2019
Oct 18, 2019
Dec 7, 2019
Dec 9, 2019
Nov 26, 2019
Nov 2, 2019
Mar 13, 2017
Aug 21, 2019
Sep 26, 2019
Nov 2, 2019
Dec 3, 2019
Dec 3, 2019
Aug 9, 2019
Aug 9, 2019
Aug 29, 2019
Aug 29, 2019
Aug 9, 2019
Apr 10, 2019
Aug 9, 2019
Mar 22, 2019
Sep 9, 2019
Dec 3, 2019
Nov 25, 2019
Feb 27, 2019
Feb 27, 2019
Nov 25, 2019
Sep 16, 2019
Dec 19, 2018
Dec 3, 2019
Sep 16, 2019
Mar 18, 2019
Feb 6, 2019
Sep 16, 2019
Mar 18, 2019

Repository files navigation

Repository

build status test results

This repository is home to the following .NET Foundation projects. These projects are maintained by Microsoft and licensed under the Apache License, Version 2.0.

Entity Framework Core

latest version preview version downloads

EF 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.

Installation

EF Core is available on NuGet. Install the provider package corresponding to your target database. See the list of providers in the docs for additional databases.

dotnet add package Microsoft.EntityFrameworkCore.SqlServer
dotnet add package Microsoft.EntityFrameworkCore.Sqlite
dotnet add package Microsoft.EntityFrameworkCore.Cosmos

Use the --version option to specify a preview version to install.

Use the daily builds to verify bug fixes and provide early feedback.

Usage

The following code demonstrates basic usage of EF Core. For a full tutorial configuring the DbContext, defining the model, and creating the database, see getting started in the docs.

using (var db = new BloggingContext())
{
    // Inserting data into the database
    db.Add(new Blog { Url = "http://blogs.msdn.com/adonet" });
    db.SaveChanges();

    // Querying
    var blog = db.Blogs
        .OrderBy(b => b.BlogId)
        .First();

    // Updating
    blog.Url = "https://devblogs.microsoft.com/dotnet";
    blog.Posts.Add(
        new Post
        {
            Title = "Hello World",
            Content = "I wrote an app using EF Core!"
        });
    db.SaveChanges();

    // Deleting
    db.Remove(blog);
    db.SaveChanges();
}

Microsoft.Data.Sqlite

latest version preview version downloads

Microsoft.Data.Sqlite is a lightweight ADO.NET provider for SQLite. The EF Core provider for SQLite is built on top of this library. However, it can also be used independently or with other data access libraries.

Installation

The latest stable version is available on NuGet.

dotnet add package Microsoft.Data.Sqlite

Use the --version option to specify a preview version to install.

Use the daily builds to verify bug fixes and provide early feedback.

Usage

This library implements the common ADO.NET abstractions for connections, commands, data readers, etc. See the samples directory for additional examples.

using (var connection = new SqliteConnection("Data Source=Blogs.db"))
{
    connection.Open();

    var command = connection.CreateCommand();
    command.CommandText = "SELECT Url FROM Blogs";

    using (var reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            var url = reader.GetString(0);
        }
    }
}

Getting support

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 issue. For more details, see getting support.

Contributing

If you're interested in contributing to these projects, see contributing.

See also

About

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.

Resources

License

Code of conduct

Security policy

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C# 99.2%
  • Other 0.8%