Npgsql.EntityFrameworkCore.PostgreSQL 9.0.4

Prefix Reserved
.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher.
There is a newer prerelease version of this package available.
See the version list below for details. 
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 9.0.4
                    


                    

                
NuGet\Install-Package Npgsql.EntityFrameworkCore.PostgreSQL -Version 9.0.4
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="9.0.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="9.0.4" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add Npgsql.EntityFrameworkCore.PostgreSQL --version 9.0.4
                    


                    

                
#r "nuget: Npgsql.EntityFrameworkCore.PostgreSQL, 9.0.4"
#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. 
#addin nuget:?package=Npgsql.EntityFrameworkCore.PostgreSQL&version=9.0.4
                    


                            Install Npgsql.EntityFrameworkCore.PostgreSQL as a Cake Addin
                        

                    

                
#tool nuget:?package=Npgsql.EntityFrameworkCore.PostgreSQL&version=9.0.4
                    


                            Install Npgsql.EntityFrameworkCore.PostgreSQL as a Cake Tool

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 net8.0 is compatible.  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.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.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.4K)

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.
EFCore.BulkExtensions.PostgreSql

EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on PostgreSQL
AppAny.Quartz.EntityFrameworkCore.Migrations.PostgreSQL

EntityFrameworkCore PostgreSQL migrations for Quartz.NET

GitHub repositories (261)

Showing the top 20 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.
jasontaylordev/CleanArchitecture
Clean Architecture Solution Template for ASP.NET Core
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.
dotnet/eShop
A reference .NET application implementing an eCommerce site
MassTransit/MassTransit
Distributed Application Framework for .NET
elsa-workflows/elsa-core
A .NET workflows library
btcpayserver/btcpayserver
Accept Bitcoin payments. Free, open-source & self-hosted, Bitcoin payment processor.
fullstackhero/dotnet-starter-kit
Production Grade Cloud-Ready .NET 9 Starter Kit (Web API + Blazor Client) with Multitenancy Support, and Clean/Modular Architecture that saves roughly 200+ Development Hours! All Batteries Included.
aspnet/Mvc
[Archived] ASP.NET Core MVC is a model view controller framework for building dynamic web sites with clean separation of concerns, including the merged MVC, Web API, and Web Pages w/ Razor. Project moved to https://github.com/aspnet/AspNetCore
danielgerlag/workflow-core
Lightweight workflow engine for .NET Standard
ChilliCream/graphql-platform
Welcome to the home of the Hot Chocolate GraphQL server for .NET, the Strawberry Shake GraphQL client for .NET and Nitro the awesome Monaco based GraphQL IDE.
immense/Remotely
A remote control and remote scripting solution, built with .NET 8, Blazor, and SignalR.
dotnetcore/Util
Util是一个.Net平台下的应用框架，旨在提升中小团队的开发能力，由工具类、分层架构基类、Ui组件，配套代码生成模板，权限等组成。
dotnet/aspire
Tools, templates, and packages to accelerate building observable, production-ready apps
dotnetcore/WTM
Use WTM to write .netcore app fast !!!
Xabaril/AspNetCore.Diagnostics.HealthChecks
Enterprise HealthChecks for ASP.NET Core Diagnostics Package
cq-panda/Vue.NetCore
(已支持sqlsugar).NetCore、.Net6、Vue2、Vue3、Vite、TypeScript、Element plus+uniapp前后端分离，全自动生成代码；支持移动端(ios/android/h5/微信小程序。http://www.volcore.xyz/
testcontainers/testcontainers-dotnet
A library to support tests with throwaway instances of Docker containers for all compatible .NET Standard versions.
Ombi-app/Ombi
Want a Movie or TV Show on Plex/Emby/Jellyfin? Use Ombi!
Version Downloads Last updated
10.0.0-preview.3 2,992 4/12/2025
10.0.0-preview.2 3,629 3/24/2025
10.0.0-preview.1 2,470 3/1/2025
9.0.4 2,218,904 3/1/2025
9.0.3 2,659,836 1/17/2025
9.0.2 2,345,620 12/7/2024
9.0.1 1,130,245 11/19/2024
9.0.0-rc.2 99,585 10/13/2024
9.0.0-rc.1 56,968 9/13/2024
9.0.0-preview.7 10,861 9/1/2024
9.0.0-preview.3 120,239 4/12/2024
9.0.0-preview.2 15,484 3/22/2024
9.0.0-preview.1 46,900 2/14/2024
8.0.11 5,456,763 11/18/2024
8.0.10 4,383,174 10/17/2024
8.0.8 2,747,371 9/27/2024
8.0.4 21,147,395 5/11/2024
8.0.2 11,360,037 2/17/2024
8.0.0 9,873,087 11/21/2023
8.0.0-rc.2 167,858 10/11/2023
8.0.0-rc.1 68,564 9/14/2023
8.0.0-preview.7 16,422 8/18/2023
8.0.0-preview.4 72,970 5/20/2023
8.0.0-preview.3 42,780 4/24/2023
8.0.0-preview.2 29,423 3/20/2023
8.0.0-preview.1 63,490 3/3/2023
7.0.18 1,435,024 5/11/2024
7.0.11 8,778,306 9/15/2023
7.0.4 12,879,109 4/24/2023
7.0.3 7,931,039 2/15/2023
7.0.1 5,458,864 12/17/2022
7.0.0 3,395,378 11/9/2022
7.0.0-rc.2 57,914 10/11/2022
7.0.0-rc.1 16,866 9/16/2022
7.0.0-preview.7 16,243 8/9/2022
7.0.0-preview.6 16,079 7/13/2022
7.0.0-preview.5 11,124 6/19/2022
7.0.0-preview.4 18,541 5/11/2022
7.0.0-preview.3 14,403 4/19/2022
7.0.0-preview.2 24,887 3/16/2022
7.0.0-preview.1 10,513 2/17/2022
6.0.29 1,399,192 5/11/2024
6.0.22 2,205,842 9/15/2023
6.0.8 10,640,902 12/17/2022
6.0.7 9,922,620 9/16/2022
6.0.6 8,795,067 8/4/2022
6.0.5 6,195,532 6/19/2022
6.0.4 8,622,996 4/19/2022
6.0.3 7,886,165 1/27/2022
6.0.2 4,004,976 12/22/2021
6.0.1 5,397,600 12/3/2021
6.0.0 4,424,358 11/9/2021
6.0.0-rc.2 134,121 10/14/2021
6.0.0-rc.1 145,491 9/24/2021
6.0.0-preview7 20,122 8/16/2021
6.0.0-preview6 5,993 7/31/2021
6.0.0-preview5 44,196 7/1/2021
6.0.0-preview4 32,300 5/27/2021
6.0.0-preview3 22,920 4/15/2021
6.0.0-preview2 9,327 3/11/2021
6.0.0-preview1 13,308 2/16/2021
5.0.10 8,200,496 9/15/2021
5.0.7 5,488,336 6/13/2021
5.0.6 1,809,564 5/11/2021
5.0.5.1 1,296,647 4/21/2021
5.0.5 414,743 4/16/2021
5.0.2 4,545,544 1/19/2021
5.0.1 1,483,381 12/12/2020
5.0.0 1,863,673 11/15/2020
3.1.18 2,824,688 8/27/2021
3.1.11 2,836,399 1/21/2021
3.1.4 12,264,472 5/29/2020
3.1.3 3,370,819 3/26/2020
3.1.2 1,987,967 2/20/2020
3.1.1.2 769,543 2/6/2020
3.1.1.1 190,333 2/3/2020
3.1.1 362,660 1/31/2020
3.1.0 3,003,228 12/4/2019
3.0.1 1,042,744 10/2/2019
3.0.0 270,966 9/26/2019
2.2.4 5,413,394 5/21/2019
2.2.0 5,507,928 12/7/2018
2.1.2 3,607,174 9/8/2018
2.1.1.1 1,216,560 7/15/2018
2.1.1 691,737 7/1/2018
2.1.0 1,302,092 5/31/2018
2.0.2 545,398 4/22/2018
2.0.1 576,627 1/11/2018
2.0.0 1,017,735 8/16/2017
1.1.1 304,132 7/25/2017
1.1.0 1,362,832 11/20/2016
1.0.2 88,366 9/24/2016
1.0.1 127,191 7/21/2016
1.0.0 263,876 6/29/2016