dotConnect for PostgreSQL 7.21 is released!

[Devart]

Dear users,

Devart is glad to announce the release of dotConnect for PostgreSQL 7.21 — 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 improved support for Entity Framework Core. It both supports the new data types and extends LINQ query translation capabilities. Additionally, we have improved Entity Framework Core Code-First Migrations support.

WHERE Condition Support for Index in Code-First Migrations

For Entity Framework Core 3 and 5, dotConnect for PostgreSQL now supports specifying a condition for an index. This allows creating PostgreSQL partial indexes.

LINQ to Entities Improvements

LINQ to Entities Improvements

dotConnect for PostgreSQL now supports translation of the following LINQ features to SQL for both EF Core 3 and EF Core 5:

• The static IsNullOrWhiteSpace() method of the String class
• The static Today property and instance DayOfWeek and Ticks properties of the DateTime class
• The following static methods of the Math class: Max(), Min(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan()

For EF Core 5, more LINQ features can be translated to SQL:

• The static Parse() method of the System.Net.IPAddress class
• The static Parse() method of the System.Net.NetworkInformation.PhysicalAddress class
• The following static methods of the MathF class: Abs(), Round(), Truncate(), Floor(), Ceiling(), Max(), Min(), Pow(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan()

Data Types Support

For Entity Framework Core 3 and 5, dotConnect for PostgreSQL now supports mapping the internet/intranet System.Uri type to PostgreSQL ‘text’ data type.

For Entity Framework Core 5, dotConnect for PostgreSQL now supports mapping network types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to PostgreSQL ‘inet’ and ‘macaddr’/’macaddr8’ data types.

For Entity Framework Core 3 and 5, dotConnect for PostgreSQL now supports mapping the dictionary .NET types to HSTORE PostgreSQL data type. Mapping of the following types is supported:

• Dictionary<TKey, TValue>
• SortedDictionary<TKey, TValue>
• ImmutableDictionary<TKey, TValue>
• ImmutableSortedDictionary<TKey, TValue>

For more details about mapping and using these types and other new dotConnect for PostgreSQL 7.21 features. see our blog article.

Here is the complete list of dotConnect for PostgreSQL 7.21.1985 changes:

Entity Developer

• The new property Validation Framework is implemented in the Data Transfer Object template for generating DataAnnotations attributes
• The Uri data type is supported in EF Core Model
• The new option "Save connection to" is implemented in Model Settings of EF Core Model to provide the ability to store the connection string in "Model file", "Entity Developer storage", "Environment variable"
• The new option "Enum Output" is added to the EF Core template to specify output for the generated enums
• The new property Generate UnitOfWork Repository Properties (by default, True) is implemented in the Repository and Unit Of Work template of EF Core Model for accessing the collections of entities
• The representation of one-to-one association with non-nullable properties on both ends is changed from 1 -> 1 to 0..1 -> 1 on a diagram in EF Core Model
• The bug with code generation for the Constrained option of Association Editor in the case of 0..1 -> 1 association in EF Core Model is fixed
• The bug throwing "Unknown property 'DoNotSerialize'.", when complex types and VB.NET template are used in EF Core Model, is fixed

Entity Framework support

• Entity Framework Core 5.0.10 is supported
• Entity Framework Core 3.1.19 is supported
• The SQL translation of the following class members used in LINQ query is supported in EF Core 3 and EF Core 5:
  • static method IsNullOrWhiteSpace() of the String class
  • static property Today and instance properties DayOfWeek, Ticks of the DateTime class
  • static methods Max(), Min(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan() of the Math class
• The SQL translation of the following class members used in LINQ query is supported in EF Core 5:
  • static method Parse() of the System.Net.IPAddress class
  • static method Parse() of the System.Net.NetworkInformation.PhysicalAddress class
  • static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Max(), Min(), Pow(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan() of the MathF class
• Mapping of System.Decimal to PostgreSQL DECIMAL with specified precision and scale in EF Core 5 is supported
• Mapping of the PostgreSQL HSTORE data type to Dictionary, SortedDictionary, ImmutableDictionary, ImmutableSortedDictionary is supported in EF Core 3 and EF Core 5
• The HasFilter extension on IndexBuilder in EF Core Migrations is supported in EF Core 3 and EF Core 5
• Mapping of internet/intranet data type System.Uri to PostgreSQL TEXT is supported in EF Core 3 and EF Core 5
• Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to PostgreSQL INET and MACADDR/MACADDR8 is supported in EF Core 5
• The definition of System.ICloneable is removed from .NET Framework assembly \Entity\EFCore3\Devart.Data.PostgreSql.Entity.EFCore.dll

Devart development team
http://www.devart.com/dotconnect/postgresql/