Description

dotConnect for PostgreSQL is a high-performance ORM enabled data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications.

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

Advanced Visual Studio Integration
dotConnect for PostgreSQL provides a vast number of GUI tools that increase your productivity. For example, it includes DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.

PostgreSQL ADO.NET Provider supports advanced Visual Studio integration (DDEX), and provides convenient visual component editors to simplify component tweaking.

Broad Compatibility
dotConnect for PostgreSQL was the first PostgreSQL database provider to support .NET Core and Entity Framework Core, and we work hard to support new platforms and development technologies as soon as they are released.

PostgreSQL support: from 7.1 to 12
Visual Studio support: 2008 – 2019
Platforms support:
Full .NET Framework 2.0 – 4.8
.NET Core 1.x, 2.x, and 3.0
.NET Compact Framework 2.0 and above
Mono 2.0 and above

Enhanced ORM Support
dotConnect for PostgreSQL offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our PostgreSQL ADO.NET Provider supports the following ORMs:

Entity Framework v1 - v6
Entity Framework Core 1.x, 2.x, and 3.1
NHibernate
LinqConnect

9.1.33 24-Feb-26

• Added support for pgvector VECTOR and HALFVEC data types
• Added the Use Session Timezone connection string parameter to control whether PostgreSQL date/time values are converted using the current session time zone
• Added the LoadLicenseKey() method to the PgSqlConnection class
• Fixed an issue where the license key could not be applied on Red Hat–based Linux distributions (RHEL 9/10, AlmaLinux 9/10, Rocky Linux 9/10) when the system-wide cryptographic policy was set to DEFAULT
• Fixed an issue where SSL connections on Linux could fail when using server certificates
• Fixed an issue where executing a stored function via PgSqlCommand could fail when CommandType was set to StoredProcedure
• Fixed an issue with PgSqlDataTable when working with UNIQUE CONSTRAINT columns
• Fixed an issue with batch updates in the PgSqlDataTable class
• Fixed an issue with GENERATED ALWAYS AS columns in the PgSqlDump class
• Fixed execution of queries containing pg_hint_plan hints in PgSqlScript
• Fixed PgSqlNumeric.ToString() for large numeric values

Entity Framework support

• Added support for Entity Framework Core 10
• Added support for NetTopologySuite 2.6 in Entity Framework Core
• Added support for NetTopologySuite 2.6 for EF6 in the .NET Standard 2.0 assemblies of the NuGet packages
• Added support for pgvector VECTOR and HALFVEC data types in EF Core
• Updated Entity Framework Core 9 support to version 9.0.12
• Updated Entity Framework Core 8 support to version 8.0.23
• Fixed an issue where LINQ queries with subqueries or projections could generate incorrect SQL aliases when used with Entity Framework Core 9
• Fixed an issue with String.IsNullOrWhiteSpace() in LINQ queries in Entity Framework Core

LinqConnect

• Fixed an issue where Devart.Data.PostgreSql.Linq.dll could be missing from the installation

Additional Information