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