Npgsql 9.0.2

Prefix Reserved
dotnet add package Npgsql --version 9.0.2                
NuGet\Install-Package Npgsql -Version 9.0.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" Version="9.0.2" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Npgsql --version 9.0.2                
#r "nuget: Npgsql, 9.0.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 as a Cake Addin
#addin nuget:?package=Npgsql&version=9.0.2

// Install Npgsql as a Cake Tool
#tool nuget:?package=Npgsql&version=9.0.2                

Npgsql is the open source .NET data provider for PostgreSQL. It allows you to connect and interact with PostgreSQL server using .NET.

Quickstart

Here's a basic code snippet to get you started:

var connString = "Host=myserver;Username=mylogin;Password=mypass;Database=mydatabase";

await using var conn = new NpgsqlConnection(connString);
await conn.OpenAsync();

// Insert some data
await using (var cmd = new NpgsqlCommand("INSERT INTO data (some_field) VALUES (@p)", conn))
{
    cmd.Parameters.AddWithValue("p", "Hello world");
    await cmd.ExecuteNonQueryAsync();
}

// Retrieve all rows
await using (var cmd = new NpgsqlCommand("SELECT some_field FROM data", conn))
await using (var reader = await cmd.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
    Console.WriteLine(reader.GetString(0));
}

Key features

  • High-performance PostgreSQL driver. Regularly figures in the top contenders on the TechEmpower Web Framework Benchmarks.
  • Full support of most PostgreSQL types, including advanced ones such as arrays, enums, ranges, multiranges, composites, JSON, PostGIS and others.
  • Highly-efficient bulk import/export API.
  • Failover, load balancing and general multi-host support.
  • Great integration with Entity Framework Core via Npgsql.EntityFrameworkCore.PostgreSQL.

For the full documentation, please visit the Npgsql 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 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.7K)

Showing the top 5 NuGet packages that depend on Npgsql:

Package Downloads
Npgsql.EntityFrameworkCore.PostgreSQL

PostgreSQL/Npgsql provider for Entity Framework Core.

AspNetCore.HealthChecks.NpgSql

HealthChecks.NpgSql is a health check for Postgress Sql.

Hangfire.PostgreSql

PostgreSql storage implementation for Hangfire (background job system for ASP.NET and aspnet core applications).

Npgsql.Json.NET

Json.NET plugin for Npgsql, allowing transparent serialization/deserialization of JSON objects directly to and from the database.

Npgsql.EntityFrameworkCore.PostgreSQL.Design

PostgreSQL/Npgsql provider for Entity Framework Core.

GitHub repositories (255)

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

Repository Stars
microsoft/semantic-kernel
Integrate cutting-edge LLM technology quickly and easily into your apps
DapperLib/Dapper
Dapper - a simple object mapper for .Net
Sonarr/Sonarr
Smart PVR for newsgroup and bittorrent users.
Radarr/Radarr
Movie organizer/manager for usenet and torrent users.
dotnet/orleans
Cloud Native application framework for .NET
Version Downloads Last updated
9.0.2 1,857,175 12/7/2024
9.0.1 949,082 11/19/2024
8.0.6 2,247,366 11/18/2024
8.0.5 4,559,556 10/13/2024
8.0.4 3,789,693 9/10/2024
8.0.3 27,105,096 5/9/2024
8.0.2 11,997,358 2/10/2024 8.0.2 has at least one vulnerability with high severity.
8.0.1 3,047,590 12/4/2023 8.0.1 has at least one vulnerability with high severity.
8.0.0 12,583,408 11/21/2023 8.0.0 has at least one vulnerability with high severity.
8.0.0-rc.2 212,853 10/11/2023
8.0.0-preview.4 319,662 5/17/2023
8.0.0-preview.3 60,231 4/24/2023
8.0.0-preview.2 53,425 3/20/2023
8.0.0-preview.1 76,727 3/3/2023
7.0.9 63,253 11/18/2024
7.0.8 190,722 9/10/2024
7.0.7 2,993,831 5/9/2024
7.0.6 12,571,859 9/14/2023 7.0.6 has at least one vulnerability with high severity.
7.0.4 18,973,751 4/24/2023 7.0.4 has at least one vulnerability with high severity.
7.0.2 10,853,610 2/15/2023 7.0.2 has at least one vulnerability with high severity.
7.0.1 7,754,777 12/17/2022 7.0.1 has at least one vulnerability with high severity.
7.0.0 6,185,672 11/9/2022 7.0.0 has at least one vulnerability with high severity.
7.0.0-rc.2 76,433 10/11/2022
7.0.0-rc.1 38,132 9/16/2022
7.0.0-preview.7 40,637 8/9/2022
7.0.0-preview.6 37,304 7/13/2022
7.0.0-preview.5 18,982 6/19/2022
7.0.0-preview.4 41,773 5/11/2022
7.0.0-preview.3 44,368 4/19/2022
7.0.0-preview.2 44,505 3/16/2022
7.0.0-preview.1 5,310,581 2/17/2022
6.0.13 103,013 11/18/2024
6.0.12 149,747 9/10/2024
6.0.11 5,021,173 5/9/2024
6.0.10 2,607,392 9/14/2023 6.0.10 has at least one vulnerability with high severity.
6.0.9 3,089,933 2/15/2023 6.0.9 has at least one vulnerability with high severity.
6.0.8 9,153,760 12/17/2022 6.0.8 has at least one vulnerability with high severity.
6.0.7 14,257,551 9/16/2022 6.0.7 has at least one vulnerability with high severity.
6.0.6 11,501,335 8/4/2022 6.0.6 has at least one vulnerability with high severity.
6.0.5 8,486,183 6/19/2022 6.0.5 has at least one vulnerability with high severity.
6.0.4 11,584,257 4/19/2022 6.0.4 has at least one vulnerability with high severity.
6.0.3 14,516,189 1/27/2022 6.0.3 has at least one vulnerability with high severity.
6.0.2 5,454,074 12/20/2021 6.0.2 has at least one vulnerability with high severity.
6.0.1 8,473,741 12/3/2021 6.0.1 has at least one vulnerability with high severity.
6.0.0 23,476,237 11/9/2021 6.0.0 has at least one vulnerability with high severity.
6.0.0-rc.2 144,803 10/14/2021
6.0.0-rc.1 138,895 9/24/2021
6.0.0-preview7 44,528 8/16/2021
6.0.0-preview6 11,562 7/31/2021
6.0.0-preview5 63,916 7/1/2021
6.0.0-preview4 60,820 5/27/2021
6.0.0-preview3 63,794 4/15/2021
6.0.0-preview2 69,617 3/11/2021
5.0.18 1,116,715 5/9/2024
5.0.17 155,510 9/14/2023 5.0.17 has at least one vulnerability with high severity.
5.0.16 309,546 2/15/2023 5.0.16 has at least one vulnerability with high severity.
5.0.15 485,358 9/16/2022 5.0.15 has at least one vulnerability with high severity.
5.0.14 369,165 6/19/2022 5.0.14 has at least one vulnerability with high severity.
5.0.13 456,961 4/26/2022 5.0.13 has at least one vulnerability with high severity.
5.0.12 873,878 2/1/2022 5.0.12 has at least one vulnerability with high severity.
5.0.11 2,355,164 11/12/2021 5.0.11 has at least one vulnerability with high severity.
5.0.10 10,479,264 9/15/2021 5.0.10 has at least one vulnerability with high severity.
5.0.7 14,237,466 6/13/2021 5.0.7 has at least one vulnerability with high severity.
5.0.5 5,200,828 5/11/2021 5.0.5 has at least one vulnerability with high severity.
5.0.4 8,161,801 3/25/2021 5.0.4 has at least one vulnerability with high severity.
5.0.3 6,709,187 1/26/2021 5.0.3 has at least one vulnerability with high severity.
5.0.2 4,604,317 1/19/2021 5.0.2 has at least one vulnerability with high severity.
5.0.1.1 2,790,321 12/12/2020 5.0.1.1 has at least one vulnerability with high severity.
5.0.0 4,910,743 11/15/2020 5.0.0 has at least one vulnerability with high severity.
4.1.14 269,092 5/18/2024
4.1.13 686,060 5/9/2024
4.1.12 883,500 6/19/2022 4.1.12 has at least one vulnerability with high severity.
4.1.11 96,930 4/26/2022 4.1.11 has at least one vulnerability with high severity.
4.1.10 761,223 11/12/2021 4.1.10 has at least one vulnerability with high severity.
4.1.9 3,440,715 4/6/2021 4.1.9 has at least one vulnerability with high severity.
4.1.8 3,230,497 1/21/2021 4.1.8 has at least one vulnerability with high severity.
4.1.7 471,434 12/12/2020 4.1.7 has at least one vulnerability with high severity.
4.1.6 1,177,235 11/15/2020 4.1.6 has at least one vulnerability with high severity.
4.1.5 5,475,376 9/28/2020 4.1.5 has at least one vulnerability with high severity.
4.1.4 4,241,392 7/19/2020 4.1.4 has at least one vulnerability with high severity.
4.1.3.1 20,422,197 2/20/2020 4.1.3.1 has at least one vulnerability with high severity.
4.1.3 8,052,976 1/31/2020 4.1.3 has at least one vulnerability with high severity.
4.1.2 5,760,392 11/14/2019 4.1.2 has at least one vulnerability with high severity.
4.1.1 4,390,457 10/2/2019 4.1.1 has at least one vulnerability with high severity.
4.1.0 699,148 9/26/2019 4.1.0 has at least one vulnerability with high severity.
4.0.17 47,062 6/10/2024
4.0.16 44,612 5/18/2024
4.0.14 57,371 5/9/2024
4.0.13 133,417 6/19/2022 4.0.13 has at least one vulnerability with high severity.
4.0.12 107,589 5/16/2021 4.0.12 has at least one vulnerability with high severity.
4.0.11 713,641 7/19/2020 4.0.11 has at least one vulnerability with high severity.
4.0.10 6,056,351 9/9/2019 4.0.10 has at least one vulnerability with high severity.
4.0.9 1,133,861 8/14/2019 4.0.9 has at least one vulnerability with high severity.
4.0.8 949,731 7/18/2019 4.0.8 has at least one vulnerability with high severity.
4.0.7 7,174,699 5/21/2019 4.0.7 has at least one vulnerability with high severity.
4.0.6 3,568,722 4/11/2019 4.0.6 has at least one vulnerability with high severity.
4.0.5 1,581,656 3/3/2019 4.0.5 has at least one vulnerability with high severity.
4.0.4 8,037,322 12/6/2018 4.0.4 has at least one vulnerability with high severity.
4.0.3 5,857,520 9/8/2018 4.0.3 has at least one vulnerability with high severity.
4.0.2 3,510,624 7/8/2018 4.0.2 has at least one vulnerability with high severity.
4.0.1 761,188 7/1/2018 4.0.1 has at least one vulnerability with high severity.
4.0.0 1,837,228 5/30/2018 4.0.0 has at least one vulnerability with high severity.
4.0.0-rc1 94,038 5/8/2018 4.0.0-rc1 has at least one vulnerability with high severity.
4.0.0-preview2 109,166 4/11/2018 4.0.0-preview2 has at least one vulnerability with high severity.
4.0.0-preview1 18,624 3/19/2018 4.0.0-preview1 has at least one vulnerability with high severity.
3.2.7 8,253,251 2/27/2018 3.2.7 has at least one vulnerability with high severity.
3.2.6 5,780,929 12/3/2017 3.2.6 has at least one vulnerability with high severity.
3.2.5 7,201,747 7/25/2017 3.2.5 has at least one vulnerability with high severity.
3.2.4.1 241,779 6/22/2017 3.2.4.1 has at least one vulnerability with high severity.
3.2.4 26,830 6/13/2017 3.2.4 has at least one vulnerability with high severity.
3.2.3 66,444 6/1/2017 3.2.3 has at least one vulnerability with high severity.
3.2.2 1,653,916 3/21/2017 3.2.2 has at least one vulnerability with high severity.
3.2.1 123,888 2/14/2017 3.2.1 has at least one vulnerability with high severity.
3.2.0 74,696 1/27/2017 3.2.0 has at least one vulnerability with high severity.
3.1.10 90,295 2/14/2017 3.1.10 has at least one vulnerability with high severity.
3.1.9 7,879,912 11/20/2016 3.1.9 has at least one vulnerability with high severity.
3.1.8 436,854 9/24/2016 3.1.8 has at least one vulnerability with high severity.
3.1.7 527,945 8/6/2016 3.1.7 has at least one vulnerability with high severity.
3.1.6 132,197 7/12/2016 3.1.6 has at least one vulnerability with high severity.
3.1.5 352,186 6/28/2016 3.1.5 has at least one vulnerability with high severity.
3.1.4 80,662 6/16/2016 3.1.4 has at least one vulnerability with high severity.
3.1.3 281,358 5/30/2016 3.1.3 has at least one vulnerability with high severity.
3.1.2 152,579 5/22/2016 3.1.2 has at least one vulnerability with high severity.
3.1.1 235,996 5/19/2016 3.1.1 has at least one vulnerability with high severity.
3.1.0 173,516 5/16/2016 3.1.0 has at least one vulnerability with high severity.
3.0.8 63,251 6/16/2016 3.0.8 has at least one vulnerability with high severity.
3.0.7 37,098 5/3/2016 3.0.7 has at least one vulnerability with high severity.
3.0.6 9,753 5/1/2016 3.0.6 has at least one vulnerability with high severity.
3.0.5 290,312 1/1/2016 3.0.5 has at least one vulnerability with high severity.
3.0.4 36,137 12/6/2015 3.0.4 has at least one vulnerability with high severity.
3.0.3 72,002 9/27/2015 3.0.3 has at least one vulnerability with high severity.
3.0.2 46,674 9/4/2015 3.0.2 has at least one vulnerability with high severity.
3.0.1 32,077 8/18/2015 3.0.1 has at least one vulnerability with high severity.
3.0.0 50,245 8/7/2015 3.0.0 has at least one vulnerability with high severity.
2.2.7 452,456 9/18/2015 2.2.7 has at least one vulnerability with high severity.
2.2.6 57,867 8/27/2015 2.2.6 has at least one vulnerability with high severity.
2.2.5 358,556 3/11/2015 2.2.5 has at least one vulnerability with high severity.
2.2.4.3 53,095 2/6/2015 2.2.4.3 has at least one vulnerability with high severity.
2.2.4.1 18,822 2/3/2015 2.2.4.1 has at least one vulnerability with high severity.
2.2.3 402,413 11/26/2014 2.2.3 has at least one vulnerability with high severity.
2.2.2 41,715 11/1/2014 2.2.2 has at least one vulnerability with high severity.
2.2.1 60,462 9/24/2014 2.2.1 has at least one vulnerability with high severity.
2.2.0 30,803 9/1/2014 2.2.0 has at least one vulnerability with high severity.
2.1.3 79,452 4/9/2014 2.1.3 has at least one vulnerability with high severity.
2.1.2 17,154 3/28/2014 2.1.2 has at least one vulnerability with high severity.
2.1.1 16,994 3/21/2014 2.1.1 has at least one vulnerability with high severity.
2.1.0 32,721 3/19/2014 2.1.0 has at least one vulnerability with high severity.
2.0.14.3 94,333 12/21/2013 2.0.14.3 has at least one vulnerability with high severity.
2.0.12.1 76,446 12/17/2012 2.0.12.1 has at least one vulnerability with high severity.
2.0.11 264,841 2/6/2011 2.0.11 has at least one vulnerability with high severity.