EF Core Support Improvements in dotConnect for PostgreSQL 7.21

Devart news about betas, releases, awards, and other information
Locked
Devart
Site Admin
Posts: 3974
Joined: Tue 26 Oct 2004 13:51

EF Core Support Improvements in dotConnect for PostgreSQL 7.21

Post by Devart » Thu 30 Sep 2021 10:27

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.

Feel free to download the new version of dotConnect for PostgreSQL, try the new functionality, and leave feedback.

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

Locked