Devart.Data.PostgreSql 9.0.0

Prefix Reserved
dotnet add package Devart.Data.PostgreSql --version 9.0.0
                    
NuGet\Install-Package Devart.Data.PostgreSql -Version 9.0.0
                    
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="Devart.Data.PostgreSql" Version="9.0.0" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Devart.Data.PostgreSql" Version="9.0.0" />
                    
Directory.Packages.props
<PackageReference Include="Devart.Data.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 Devart.Data.PostgreSql --version 9.0.0
                    
#r "nuget: Devart.Data.PostgreSql, 9.0.0"
                    
#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.
#:package Devart.Data.PostgreSql@9.0.0
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Devart.Data.PostgreSql&version=9.0.0
                    
Install as a Cake Addin
#tool nuget:?package=Devart.Data.PostgreSql&version=9.0.0
                    
Install as a Cake Tool

dotConnect for PostgreSQL

dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL that builds on ADO.NET technology.

The provider works with .NET Frameworks 2.0+, .NET Core 1.0+, .NET 5+.

It supports a wide range of PostgreSQL-specific features, such as secure SSL and SSH connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.

More information at dotConnect for PostgreSQL.

Compatibility


The following table show which version of this package to use with which version of frameworks.

Frameworks Version support
.NET 9, 8, 7, 6, 5
.NET Core 3, 2, 1
.NET Framework 4.8, 4.7, 4.6

More information here

Installation


For projects, using general ADO.NET functionality of dotConnect for PostgreSQL, you need to install the Devart.Data.PostgreSql package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.PostgreSql

For projects, using Entity Framework Core 1, 3, 5, 6, 7, 8, 9 with PostgreSQL, install the Devart.Data.PostgreSql.EFCore package.

For projects that require integration with Entity Framework 6.4 (EF6), use the Devart.Data.PostgreSql.EF6 package.

License

dotConnect for PostgreSQL is available in several editions. See pricing options for ordering.

The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial.

Usage


In this example, a new instance of the PostgreSqlConnection class (part of the Devart.Data.PostgreSql namespace) is created.

using Devart.Data.PostgreSql;
...
PgSqlConnection connection = new PgSqlConnection();
connection.Host = "127.0.0.1";
connection.Port = 5432;
connection.UserId = "postgres";
connection.Password = "postgres";
connection.Database = "test";
connection.Schema = "pg_catalog";

This snippet simplifies the PostgreSQL connection setup by directly assigning a connection string to the ConnectionString property of the PostgreSqlConnection object

сonnection.ConnectionString = "UserId=postgres;Password=postgres;Host=127.0.0.1;Port=5432;Database=test;Schema=pg_catalog;";
ASP.NET Core and Blazor

Configuration File Snippet (appsettings.json):

{
  "ConnectionStrings": {
    "DefaultConnection": "UserId=postgres;Password=postgres;Host=127.0.0.1;Port=5432;Database=test;Schema=pg_catalog;"
   }
}

Dependency Injection of IConfiguration:

private readonly IConfiguration configuration;

public YourController(IConfiguration config) 
{
    configuration = config;
}

Retrieving a Connection String:

var connectionString = configuration.GetConnectionString("DefaultConnection");
var connection = new PostgreSqlConnection(connectionString);

For more information about secure connections using SSL or SSH connections read at our documentation.

Key Features

  • Easy Connection: Allows your application to work with PostgreSQL.
  • ASP.NET Core: Supports ASP.NET Core Identity.
  • Performance: Uses many PostgreSQL-specific performance features & optimizations to ensure the highest performance.
  • Monitoring: Allows per-component tracing of database events with a free dbMonitor application.
  • Security: Supports various encryption ciphers, SSL and SSH connections, etc.
  • Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

Support Area

More Resources

Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  net5.0-windows was computed.  net6.0 was computed.  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.  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.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (10)

Showing the top 5 NuGet packages that depend on Devart.Data.PostgreSql:

Package Downloads
Devart.Data.PostgreSql.EFCore

dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 1.0+, .NET 5+. It supports a wide range of PostgreSQL-specific features, such as secure SSL and SSH connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.a More information at https://www.devart.com/dotconnect/postgresql/ License dotConnect for PostgreSQL is available in several editions https://www.devart.com/dotconnect/postgresql/ordering.html The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. Key Features * Easy Connection: Allows your application to work with PostgreSQL. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many PostgreSQL-specific performance features & optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Security: Supports various encryption ciphers, SSL and SSH connections, etc. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

Devart.Data.PostgreSql.Linq

dotConnect for PostgreSQL is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with advanced support for ORMs, such as Entity Framework and LinqConnect and offers a complete solution for developing database-related applications and web sites. It introduces new approaches for designing a data access layer and boosts the productivity of database application development. This package contains the .NET Standard/.NET Core compatible assemblies with LinqConnect-related functionality of dotConnect for PostgreSQL. LinqConnect (LINQ to PostgreSQL) is a fast ORM solution, having a LINQ to SQL-compatible interface, but also providing its own advanced features. This package contains only runtime features of dotConnect for PostgreSQL. dotConnect for PostgreSQL is also provided as an installation package (exe), which installs runtime assemblies for Full .NET Framework and a set of design-time tools, integrated into Visual Studio - Server Explorer integration, DataSet tools, Windows Forms components with powerful design-time, etc. It also includes visual ORM designer for Entity Framework, Entity Framework Core, and LinqConnect ORM models. You can download it at www.devart.com. The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial.

Devart.Data.PostgreSql.EF6

dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 1.0+, .NET 5+. It supports a wide range of PostgreSQL-specific features, such as secure SSL and SSH connections, PostgreSQL notifications, PostgreSQL bulk data loading, GEOMETRY, PostgreSQL ARRAY types, and others.a More information at https://www.devart.com/dotconnect/postgresql/ License dotConnect for PostgreSQL is available in several editions https://www.devart.com/dotconnect/postgresql/ordering.html The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. Key Features * Easy Connection: Allows your application to work with PostgreSQL. * ASP.NET Core: Supports ASP.NET Core Identity. * Performance: Uses many PostgreSQL-specific performance features & optimizations to ensure the highest performance. * Monitoring: Allows per-component tracing of database events with a free dbMonitor application. * Security: Supports various encryption ciphers, SSL and SSH connections, etc. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

rdc-model

RDC software base data model library. Contains program modules for writing plug-in driver modules for data acquisition devices.

Pnukee.Framework.PostgreSQL.Connector

Pnukee Framework connector for PostgreSQL database engine.

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on Devart.Data.PostgreSql:

Repository Stars
DataDog/dd-trace-dotnet
.NET Client Library for Datadog APM
Version Downloads Last Updated
9.0.0 1,123 12/19/2025
8.4.290 12,821 7/30/2025
8.4.235 3,330 4/25/2025
8.4.193 5,920 2/11/2025
8.4.191 1,880 1/15/2025
8.4.190 1,103 12/27/2024
8.3.104 3,438 11/8/2024
8.3.21 55,652 6/6/2024
8.3.20 3,524 5/30/2024
8.3.10 35,195 1/18/2024
8.2.0 7,555 11/17/2023
8.1.151 20,136 6/7/2023
8.1.134 10,069 3/4/2023
8.0.0 47,105 7/1/2022
7.24.2066 46,848 1/26/2022
7.23.2042 7,337 12/21/2021
7.22.2014 671,858 11/9/2021
7.21.2001 4,985 10/21/2021
7.21.1985 4,145 9/28/2021
7.20.1944 12,060 7/30/2021
7.20.1930 4,177 7/8/2021
7.20.1905 3,587 6/3/2021
7.20.1866 8,539 4/9/2021
7.20.1860 3,167 4/1/2021
7.20.1836 3,998 2/18/2021
7.20.1812 15,270 1/14/2021
7.20.1792 5,405 12/17/2020
7.20.1782 3,795 12/3/2020
7.19.1759 47,593 10/29/2020
7.18.1739 6,450 10/1/2020
7.18.1730 6,797 9/17/2020
7.17.1696 8,536 7/30/2020
7.17.1686 4,485 7/16/2020
7.17.1666 6,733 6/17/2020
7.17.1612 22,828 4/2/2020
7.17.1583 12,441 2/20/2020
7.16.1541 17,199 12/23/2019
7.15.1519 10,366 11/21/2019
7.15.1504 4,284 10/31/2019
7.15.1499 3,663 10/24/2019
7.14.1470 7,496 9/13/2019
7.13.1437 4,734 7/25/2019
7.13.1422 5,609 7/4/2019
7.13.1402 4,715 6/6/2019
7.13.1366 4,915 4/12/2019
7.12.1357 4,238 3/28/2019
7.12.1328 4,131 2/14/2019
7.12.1307 9,746 1/10/2019
7.11.1278 3,978 11/29/2018
7.11.1253 4,279 10/25/2018
7.11.1229 4,623 9/20/2018
7.11.1216 4,508 8/31/2018
7.11.1202 5,065 8/10/2018
7.11.1190 3,714 7/19/2018
7.11.1172 8,047 6/22/2018
7.10.1152 4,336 5/25/2018
7.10.1134 11,748 4/27/2018
7.10.1115 4,586 3/30/2018
7.10.1086 7,099 2/15/2018
7.10.1061 4,557 1/11/2018
7.10.1031 3,890 11/23/2017
7.10.1013 18,547 10/30/2017
7.9.980 5,354 9/7/2017
7.9.958 2,776 8/4/2017
7.9.946 3,658 7/14/2017
7.9.931 3,586 6/23/2017
7.9.912 4,406 5/25/2017