Meet the New dotConnect for PostgreSQL Release

From: Devart via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: Meet the New dotConnect for PostgreSQL Release
Date: 2026-01-16 07:11:41
Message-ID: 176854750127.768.6724437677063650509@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Devart, a recognized vendor of high-performance ADO.NET data providers that enable direct access to major database systems and cloud services, released a new version of [dotConnect for PostgreSQL](https://www.devart.com/dotconnect/postgresql/).

**The list of updates:**

1) Added support for **PostgreSQL 18**.

Now, users can reliably connect, run queries, and use PostgreSQL 18 features in .NET applications without driver compatibility issues.

2) Added support for the **PgSqlNumeric data type** for high-precision NUMERIC values.

This type lets users insert, read, and process NUMERIC values without losing accuracy, even for long numbers.

3) Added support for **Visual Studio 2026** and **Visual Studio 2026 Insiders**

Now, teams can develop, model, and maintain their data access layers in the latest Visual Studio environment.

4) Added support for **modern SSH encryption and key exchange algorithms**

This update ensures secure connectivity to PostgreSQL environments using modern cryptographic standards.

5) **Batch Updates**.

dotConnect for PostgreSQL offers several alternative approaches, allowing users to select the one that best fits their needs. Additionally, they demonstrate better performance in specific scenarios.

In dotConnect for PostgreSQL, [batch operations](https://www.devart.com/dotconnect/postgresql/batch-operations.html) can be executed using:

- PgSqlDataAdapter
- PgSqlDataTable
- PgSqlCommand

The Simple method runs separate commands in a loop, while *DataAdapter.Update()*, *DataTable.Update()*, and *Command.ExecuteArray()* use Batch Updates. In every case, batch-based methods cut execution time dramatically compared to the simple approach, with *Command.ExecuteArray()* delivering the highest performance for single-type operations. The execution time for different batch update approaches across popular databases is presented in the [table](https://www.devart.com/dotconnect/postgresql/batch-operations.html#performance-comparison).

So, now users can choose a better variant for their purposes.

To learn more about updates and download the product, visit the [recent release](https://blog.devart.com/dotconnect-2025-1-release.html).

Browse pgsql-announce by date

  From Date Subject
Next Message RapidLoop, Inc. via PostgreSQL Announce 2026-01-19 09:25:11 pgmetrics 1.19 released
Previous Message HexaCluster via PostgreSQL Announce 2026-01-16 07:11:21 credcheck v4.4 has been released