EF Core PostgreSQL Discover how to install and use this provider
2 major NuGet packages support PostgreSQL:
Npgsql.EntityFrameworkCore.PostgreSQL
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 Npgsql.EntityFrameworkCore.PostgreSQL Provider
To use Npgsql.EntityFrameworkCore.PostgreSQL
provider, the first step is to install Npgsql.EntityFrameworkCore.PostgreSQL NuGet package.
Now to use Entity Framework Core with PostgreSQL database, override the OnConfiguring method in the context class and set the PostgreSQL data provider using UseNpgsql
method.
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseNpgsql(@"host=localhost;database=postgres;user id=postgres;password=******;"); }
Devart.Data.PostgreSql.EFCore
Devart.Data.PostgreSql.EFCore
is an Entity Framework Core provider created by Devart.
How to Use Devart.Data.PostgreSql.EFCore Provider
To use Devart.Data.PostgreSql.EFCore
provider, the first step is to install the Devart.Data.PostgreSql.EFCore NuGet package.
Now to use Entity Framework Core with PostgreSQL database, override the OnConfiguring method in the context class and set the PostgreSQL data provider using UsePostgreSql
method.
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UsePostgreSql(@"host=localhost;database=postgres;user id=postgres;password=******;"); }
ZZZ Projects