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.
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 can be executed using:
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.
So, now users can choose a better variant for their purposes.
To learn more about updates and download the product, visit the recent release.