Npgsql.EntityFrameworkCore.PostgreSQL 7.0.0-preview.2

Prefix Reserved
This is a prerelease version of Npgsql.EntityFrameworkCore.PostgreSQL.
There is a newer version of this package available.
See the version list below for details.
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.0-preview.2                
NuGet\Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 7.0.0-preview.2                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="7.0.0-preview.2" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Npgsql.EntityFrameworkCore.PostgreSQL --version 7.0.0-preview.2                
#r "nuget: Npgsql.EntityFrameworkCore.PostgreSQL, 7.0.0-preview.2"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Npgsql.EntityFrameworkCore.PostgreSQL as a Cake Addin
#addin nuget:?package=Npgsql.EntityFrameworkCore.PostgreSQL&version=7.0.0-preview.2&prerelease

// Install Npgsql.EntityFrameworkCore.PostgreSQL as a Cake Tool
#tool nuget:?package=Npgsql.EntityFrameworkCore.PostgreSQL&version=7.0.0-preview.2&prerelease                

Npgsql Entity Framework Core provider for PostgreSQL

Npgsql.EntityFrameworkCore.PostgreSQL is the open source EF Core provider for PostgreSQL. It allows you to interact with PostgreSQL via the most widely-used .NET O/RM from Microsoft, and use familiar LINQ syntax to express queries. It's built on top of Npgsql.

The provider looks and feels just like any other Entity Framework Core provider. Here's a quick sample to get you started:

await using var ctx = new BlogContext();
await ctx.Database.EnsureDeletedAsync();
await ctx.Database.EnsureCreatedAsync();

// Insert a Blog
ctx.Blogs.Add(new() { Name = "FooBlog" });
await ctx.SaveChangesAsync();

// Query all blogs who's name starts with F
var fBlogs = await ctx.Blogs.Where(b => b.Name.StartsWith("F")).ToListAsync();

public class BlogContext : DbContext
{
    public DbSet<Blog> Blogs { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        => optionsBuilder.UseNpgsql(@"Host=myserver;Username=mylogin;Password=mypass;Database=mydatabase");
}

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

Aside from providing general EF Core support for PostgreSQL, the provider also exposes some PostgreSQL-specific capabilities, allowing you to query JSON, array or range columns, as well as many other advanced features. For more information, see the the Npgsql site. For information about EF Core in general, see the EF Core website.

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1.2K)

Showing the top 5 NuGet packages that depend on Npgsql.EntityFrameworkCore.PostgreSQL:

Package Downloads
Npgsql.EntityFrameworkCore.PostgreSQL.Design

PostgreSQL/Npgsql provider for Entity Framework Core.

Npgsql.EntityFrameworkCore.PostgreSQL.NetTopologySuite

NetTopologySuite PostGIS spatial support plugin for PostgreSQL/Npgsql Entity Framework Core provider.

Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime

NodaTime support plugin for PostgreSQL/Npgsql Entity Framework Core provider.

Npgsql.Bulk

Extension for Entity Framework Npgsql for Bulk Copy

Reo.Core.Database

Package Description

GitHub repositories (232)

Showing the top 5 popular GitHub repositories that depend on Npgsql.EntityFrameworkCore.PostgreSQL:

Repository Stars
dotnet/aspnetcore
ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.
bitwarden/server
Bitwarden infrastructure/backend (API, database, Docker, etc).
abpframework/abp
Open-source web application framework for ASP.NET Core! Offers an opinionated architecture to build enterprise software solutions with best practices on top of the .NET. Provides the fundamental infrastructure, cross-cutting-concern implementations, startup templates, application modules, UI themes, tooling and documentation.
MassTransit/MassTransit
Distributed Application Framework for .NET
elsa-workflows/elsa-core
A .NET workflows library
Version Downloads Last updated
9.0.0-rc.2 11,252 10/13/2024
9.0.0-rc.1 23,375 9/13/2024
9.0.0-preview.7 5,679 9/1/2024
9.0.0-preview.3 107,224 4/12/2024
9.0.0-preview.2 11,840 3/22/2024
9.0.0-preview.1 31,138 2/14/2024
8.0.10 292,147 10/17/2024
8.0.8 794,028 9/27/2024
8.0.4 11,004,306 5/11/2024
8.0.2 7,406,095 2/17/2024
8.0.0 6,870,010 11/21/2023
8.0.0-rc.2 159,856 10/11/2023
8.0.0-rc.1 52,784 9/14/2023
8.0.0-preview.7 15,827 8/18/2023
8.0.0-preview.4 67,120 5/20/2023
8.0.0-preview.3 35,534 4/24/2023
8.0.0-preview.2 28,300 3/20/2023
8.0.0-preview.1 62,570 3/3/2023
7.0.18 735,389 5/11/2024
7.0.11 7,608,957 9/15/2023
7.0.4 11,625,318 4/24/2023
7.0.3 7,243,124 2/15/2023
7.0.1 5,085,557 12/17/2022
7.0.0 3,033,172 11/9/2022
7.0.0-rc.2 56,310 10/11/2022
7.0.0-rc.1 16,665 9/16/2022
7.0.0-preview.7 16,092 8/9/2022
7.0.0-preview.6 14,394 7/13/2022
7.0.0-preview.5 10,355 6/19/2022
7.0.0-preview.4 17,266 5/11/2022
7.0.0-preview.3 13,084 4/19/2022
7.0.0-preview.2 24,092 3/16/2022
7.0.0-preview.1 10,041 2/17/2022
6.0.29 688,080 5/11/2024
6.0.22 1,829,626 9/15/2023
6.0.8 9,166,746 12/17/2022
6.0.7 9,224,799 9/16/2022
6.0.6 8,295,000 8/4/2022
6.0.5 5,815,546 6/19/2022
6.0.4 8,186,879 4/19/2022
6.0.3 7,469,222 1/27/2022
6.0.2 3,830,399 12/22/2021
6.0.1 5,065,053 12/3/2021
6.0.0 3,987,153 11/9/2021
6.0.0-rc.2 132,431 10/14/2021
6.0.0-rc.1 120,499 9/24/2021
6.0.0-preview7 19,873 8/16/2021
6.0.0-preview6 5,892 7/31/2021
6.0.0-preview5 44,074 7/1/2021
6.0.0-preview4 32,016 5/27/2021
6.0.0-preview3 22,798 4/15/2021
6.0.0-preview2 9,189 3/11/2021
6.0.0-preview1 12,632 2/16/2021
5.0.10 7,776,800 9/15/2021
5.0.7 5,339,431 6/13/2021
5.0.6 1,763,826 5/11/2021
5.0.5.1 1,245,428 4/21/2021
5.0.5 405,114 4/16/2021
5.0.2 4,491,059 1/19/2021
5.0.1 1,437,005 12/12/2020
5.0.0 1,801,294 11/15/2020
3.1.18 2,501,942 8/27/2021
3.1.11 2,736,191 1/21/2021
3.1.4 12,060,478 5/29/2020
3.1.3 3,271,986 3/26/2020
3.1.2 1,954,010 2/20/2020
3.1.1.2 761,294 2/6/2020
3.1.1.1 186,232 2/3/2020
3.1.1 348,285 1/31/2020
3.1.0 2,908,857 12/4/2019
3.0.1 1,031,129 10/2/2019
3.0.0 266,182 9/26/2019
2.2.4 5,341,732 5/21/2019
2.2.0 5,437,146 12/7/2018
2.1.2 3,585,233 9/8/2018
2.1.1.1 1,170,476 7/15/2018
2.1.1 684,927 7/1/2018
2.1.0 1,283,475 5/31/2018
2.0.2 540,261 4/22/2018
2.0.1 566,783 1/11/2018
2.0.0 978,304 8/16/2017
1.1.1 257,822 7/25/2017
1.1.0 1,028,368 11/20/2016
1.0.2 70,040 9/24/2016
1.0.1 126,807 7/21/2016
1.0.0 178,333 6/29/2016