dotConnect for PostgreSQL 7.24 is released!

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Locked
Devart
Site Admin
Posts: 3974
Joined: Tue 26 Oct 2004 13:51

dotConnect for PostgreSQL 7.24 is released!

Post by Devart » Thu 27 Jan 2022 09:12

Dear users,

Devart is glad to announce the release of dotConnect for PostgreSQL 7.24 — a powerful ADO.NET provider for PostgreSQL with advanced support for Entity Framework, Entity Framework Core, LinqConnect (LINQ to PostgreSQL), and NHibernate. The new release offers support for load balancing that allows specifying multiple hosts with their ports in the Host parameter of the connection string. The servers should be separated by commas.

dotConnect for PostgreSQL now also includes new assemblies for Entity Framework 5, compiled with .NET Framework 4.7.

Here is the complete list of dotConnect for PostgreSQL 7.24.2066 changes:
  • The KeepConnected connection string parameter is implemented to determine the number of seconds of connection inactivity before the client sends a ping request
  • The Load Balancing support is implemented: now several hosts with their ports can be specified in the Host parameter of the connection string
  • The Target Session connection string parameter is added for managing Load Balancing functionality, possible values are SuppressLoadBalancing, Any, PreferStandby, PreferPrimary, Primary, Standby
  • The TargetSession property is added to the PgSqlCommand class to provide the possibility to overwrite the behavior of the same option set in the connection object
Entity Developer
  • The bug when mapping PostgreSQL inet and macaddr types in Entity Framework Core Model is fixed
  • The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
  • The behavior is changed: Devart.Data.PostgreSql.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models
Entity Framework support
  • The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
  • The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
  • The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added
  • The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
  • The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
  • The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed
  • The bug with throwing the "schema does not exist" error by Database.EnsureDeleted() in EF Core is fixed
  • The bug with saving and reading string value NULL to/from HSTORE data type in PostgreSQL mapped to Dictionary<string, string> or ImmutableDictionary<string, string> or SortedDictionary<string, string> or ImmutableSortedDictionary<string, string> in EF Core 3, EF Core 5, EF Core 6 is fixed
Devart development team
http://www.devart.com/dotconnect/postgresql/

Locked