Devart.Data.PostgreSql 9.1.100

Prefix Reserved

dotnet add package Devart.Data.PostgreSql --version 9.1.100

NuGet\Install-Package Devart.Data.PostgreSql -Version 9.1.100

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.1.100" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="Devart.Data.PostgreSql" Version="9.1.100" />
                    

                            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.1.100

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Devart.Data.PostgreSql, 9.1.100"

#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.1.100

#: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.1.100
                    

                            Install as a Cake Addin

#tool nuget:?package=Devart.Data.PostgreSql&version=9.1.100
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

NuGet Version NuGet Downloads

Advanced C# Connection Provider for PostgreSQL

dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL 9.5+ including Amazon RDS, Amazon Aurora, Azure PostgreSQL, Google Cloud SQL, and Heroku Postgres that builds on ADO.NET technology.

The provider works with .NET Frameworks, .NET Core, .NET.

It supports a wide range of PostgreSQL-specific features, such as secure SSL and SSH connections, PostgreSQL LISTEN/NOTIFY, bulk data loading, GEOMETRY types, PostgreSQL ARRAY, JSON, and UUID types, and others. Package provides advanced Visual Studio integration and convenient visual component editors to simplify component tweaking.

More information at dotConnect for PostgreSQL.

Installation

Install the NuGet Package

Install-Package Devart.Data.PostgreSql

Activate license

Free Trial License: Evaluate the full capabilities of dotConnect for PostgreSQL in a non-commercial environment—ideal for development and testing. Start your free trial
Commercial License: Deploy dotConnect for PostgreSQL in commercial applications and access full technical support with a valid license. Purchase a license

Work with EF Core and Entity Framework

For projects, using Entity Framework Core 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.

Compatibility

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

Frameworks	Version support
.NET	10, 9, 8, 7, 6, 5
.NET Core	3.1, 3.0, 2.2, 2.1, 2.0
.NET Framework	4.8, 4.7, 4.6.2, 4.6.1

More information here

Key Features

Enterprise-Grade Security: Secure PostgreSQL connectivity with SSL, SSH, HTTP tunneling, and multiple encryption algorithms. dotConnect for PostgreSQL follows rigorous security standards in product development, ensuring both secure communication and resilient code.
High Performance Data Access: Built-in PostgreSQL-specific optimizations, efficient connection pooling, and fast bulk data loading with PgSqlLoader ensure low-latency access for high-throughput applications.
Full ADO.NET Compatibility: 100% compliant with ADO.NET standards, supporting key interfaces such as DbConnection, DbCommand, DataSet, and DataTable for seamless integration into .NET applications.
Advanced PostgreSQL Data Types: Native support for PostgreSQL-specific types including GEOMETRY, ARRAY, JSON, JSONB, UUID, and hstore for accurate operation across all major PostgreSQL versions.
Real-Time Notifications: Respond to database changes in real time with full PostgreSQL LISTEN/NOTIFY support, enabling event-driven application architectures.
Broad Platform Compatibility: Fully compatible with .NET Framework, .NET Core, and .NET, supporting everything from legacy enterprise systems to modern cloud-native applications.
Disconnected Data Management: Manage relational data offline using PgSqlDataSet and PgSqlDataTable, with support for batch updates, UI data binding, and local data manipulation.
Real-Time Monitoring: Track database operations using PgSqlMonitor for per-component tracing of database events.
Visual Studio Integration: Accelerate development with wizards for connection setup, typed DataSet generation, and schema management—all embedded in Visual Studio.
Priority Support and Continuous Improvement: Backed by dedicated technical support and regular updates that deliver security enhancements, feature improvements, and long-term stability.

Usage

To help you get started quickly, here's a simple code example demonstrating how to connect to a PostgreSQL database.

using Devart.Data.PostgreSql;

class Program
{
  static void Main()
  {
    string connectionString = "" +
      "Host=127.0.0.1;" +
      "Port=5432;" +
      "User Id=TestUser;" +
      "Password=TestPassword;" +
      "Database=TestDatabase;" +
      "Schema=TestSchema;" +
      "License Key=**********";

    using (PgSqlConnection connection = new PgSqlConnection(connectionString))
    {
      try
      {
        connection.Open();
        Console.WriteLine("Connection successful!");
      }
      catch (Exception ex)
      {
        Console.WriteLine($"Error: {ex.Message}");
      }
    }
  }
}

Basic Connection Strings

Property	Meaning
Host	Specifies the hostname or IP address of the server.
Port	Specifies the port number on which the server is listening.
User Id	Specifies the user ID used to authenticate with the host.
Password	Specifies the password for the user ID.
Database	Specifies the default database to be used after connecting.
Schema	Specifies the default schema to use after connecting.
License Key	Specify your license key in this parameter.

For more detailed tutorials, API reference, and advanced examples, visit our Getting Started guide.

Support Area

Product	Compatible and additional computed target framework versions.
.NET	net5.0 is compatible. net5.0-windows was computed. 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. 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.

.NETStandard 2.0
- Devart.Data (>= 7.0.100)
- System.Diagnostics.PerformanceCounter (>= 10.0.5)
- System.Text.Encoding.CodePages (>= 10.0.0)
net5.0
- Devart.Data (>= 7.0.100)
- System.Diagnostics.PerformanceCounter (>= 10.0.5)
- System.Text.Encoding.CodePages (>= 10.0.0)
net6.0
- Devart.Data (>= 7.0.100)
- System.Diagnostics.PerformanceCounter (>= 10.0.5)
- System.Text.Encoding.CodePages (>= 10.0.0)

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 2.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.	709.3K
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.	157.2K
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 2.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.	134.5K
rdc-model RDC software base data model library. Contains program modules for writing plug-in driver modules for data acquisition devices.	14.3K
Pnukee.Framework.PostgreSQL.Connector Pnukee Framework connector for PostgreSQL database engine.	10.7K

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	565

Version	Downloads	Last Updated
9.1.100	385	5/25/2026
9.1.72	5,424	4/23/2026
9.1.35	5,524	3/6/2026
9.1.33	626	2/24/2026
9.0.0	16,711	12/19/2025
8.4.290	20,929	7/30/2025
8.4.235	4,382	4/25/2025
8.4.193	8,438	2/11/2025
8.4.191	2,275	1/15/2025
8.4.190	1,553	12/27/2024
8.3.104	4,560	11/8/2024
8.3.21	77,618	6/6/2024
8.3.20	3,933	5/30/2024
8.3.10	48,168	1/18/2024
8.2.0	8,066	11/17/2023
8.1.151	20,838	6/7/2023
8.1.134	11,162	3/4/2023
8.0.0	50,562	7/1/2022
7.24.2066	47,459	1/26/2022
7.23.2042	7,771	12/21/2021

https://www.devart.com/dotconnect/postgresql/revision_history.html