Articles

InMemory

InMemory...Introduction...Microsoft.EntityFrameworkCore.InMemory... is an in-memory database provider for Entity Framework Core. It is useful when you want to test components using something that approximates connecting to the real database, without the overhead of actual database operations....The advantage of in-memory provider is that you can test the code of your application against an in-memory database instead of installing and configuring the real database....It is a general purpose datab...

More...

More Providers......A variety of sources builds EF Core providers and all of them are not maintained as part of the Entity Framework Core Project. Below are some more providers available for EF Core...You can find the full provider list supported here: ...https://docs.microsoft.com/en-us/ef/core/providers/...Pomelo.EntityFrameworkCore.MySql...It allows Entity Framework Core to be used with MySQL. The provider is maintained as part of the ...Pomelo Foundation Project.......Install...PM> Install-P...

MySQL

MySQL...Introduction...You can also use ...MySQL Connector/Net... which integrates support for Entity Framework Core. ...MySql.Data.EntityFrameworkCore... allows Entity Framework Core to be used with MySQL. The provider is maintained as part of the ...MySQL... project....Requirements...Install Connector/Net...MySQL Server 5.7 or higher...How to Use MySQL Database Provider...To use MySQL database provider, the first step is to install ... MySql.Data.EntityFrameworkCore... NuGet package. Let's con...

Oracle

Oracle...Introduction...The Oracle .NET team has announced they are planning to release a first-party provider for EF Core 2.0 approximately in the third quarter of 2018. For more information, see their statement of direction for ....NET Core and Entity Framework Core.......The EF team has produced a sample ...EF Core provider... for Oracle databases....The purpose of the project is not to produce an EF Core provider owned by Microsoft, but to help us identify gaps in EF Core's relational and ba...

PostgreSQL

PostgreSQL...Introduction...Npgsql.EntityFrameworkCore.PostgreSQL... is an Entity Framework Core provider built on top of Npgsql. It allows you to use the EF Core O/RM with PostreSQL. It mostly behaves like any other EFCore provider (e.g. SQL Server)...How to Use PostgreSQL Database Provider...To use PostgreSQL database provider, the first step is to install ...Npgsql.EntityFrameworkCore.PostgreSQL... NuGet package....Now to use Entity Framework Core with PostgreSQL database, override the OnConf...

SQL Server

SQL Server...Introduction...Microsoft.EntityFrameworkCore.SqlServer... database provider allows Entity Framework Core to be used with Microsoft SQL Server (including SQL Azure). The provider is maintained as part of the ...Entity Framework Core... Project....How to Use SQL Server Provider...To use SQL Server database provider, the first step is to install ...Microsoft.EntityFrameworkCore.SqlServer... NuGet package. Let's consider a simple model which contains three entities....public class Custo...

SQLite

SQLite...Microsoft.EntityFrameworkCore.Sqlite... database provider allows Entity Framework Core to be used with to be used with SQLite. The provider is maintained as part of the ...Entity Framework Core... Project....How to Use SQLite Provider...To use SQLite database provider, the first step is to install ...Microsoft.EntityFrameworkCore.Sqlite... NuGet package. Let's consider a simple model which contains three entities....public class Customer { public int CustomerId { get; set; } pub...