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

Reply via email to