The new version of open source ADO.NET Data Provider for PostgreSQL, Npgsql 3.2 is now available on nuget.org. There have been several internal updates, especially for improved performance, in this new version. Also, some new features have been added as well, so as to help developers community to reduce the complexity of the programming using Npgsql as data provider.
Some of the major changes include the following-
- Prepared statements are now persistent to improve the performance for applications with short-lived connections, such as most webapps.
- Npgsql's custom logging has been replaced with [Microsoft.Extensions.Logging]
- The internal I/O system has been overhauled to continue supporting sync and async I/O, but with a vastly better coding model.
- Performance counters have been implemented, similar to what SqlClient provides.
- The Visual Studio integration extension (DDEX) has been rewritten for a much better installation experience.
- The "operation already in progress" exception now provides more information to help you track down the bug.
However, as per the Npgsql community blog, this new version should be deployed carefully and if you are working on a critical application, it is better to not to update the new version until the version 3.2.1 is released.