New features in the Entity Framework support!

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Locked
Devart
Site Admin
Posts: 3974
Joined: Tue 26 Oct 2004 13:51

New features in the Entity Framework support!

Post by Devart » Tue 28 Sep 2021 15:52

Dear users,

We are glad to announce the new features that are available in the Entity Framework support in the latest version:
  • Entity Framework Core 5.0.10 is supported (MySQL, Oracle, PostgreSQL, SQLite)
  • 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 (PostgreSQL):
    • 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 (PostgreSQL):
    • 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
  • The following Code-First Migration operations are supported in EF Core 3 and EF Core 5 via recreating a table and copying the existing data (SQLite):
    • AlterColumn
    • RenameColumn (SQLite 3.24 and below)
    • DropColumn (SQLite 3.34 and below)
    • AddForeignKey
    • DropForeignKey
    • AddPrimaryKey
    • DropPrimaryKey
  • The SQL translation of the following class members used in LINQ query is supported in EF Core 3 and EF Core 5 (SQLite):
    • 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
  • Mapping of System.Decimal to MySQL DECIMAL with specified precision and scale in EF Core 5 is supported (MySQL)
  • Mapping of System.Decimal to Oracle NUMBER with specified precision and scale in EF Core 5 is supported (Oracle)
  • Mapping of System.Decimal to PostgreSQL DECIMAL with specified precision and scale in EF Core 5 is supported (PostgreSQL)
  • Mapping of System.Decimal to SQLite DECIMAL with specified precision and scale in EF Core 5 is supported (SQLite)
  • Mapping of System.Decimal to DB2 DECIMAL with specified precision and scale in EF Core 5 is supported (DB2)
  • Mapping of the PostgreSQL HSTORE data type to Dictionary, SortedDictionary, ImmutableDictionary, ImmutableSortedDictionary is supported in EF Core 3 and EF Core 5 (PostgreSQL)
  • The definition of System.ICloneable is removed from .NET Framework assembly \Entity\EFCore3\Devart.Data.MySql.Entity.EFCore.dll (MySQL)
  • The definition of System.ICloneable is removed from .NET Framework assembly \Entity\EFCore3\Devart.Data.Oracle.Entity.EFCore.dll (Oracle)
  • The definition of System.ICloneable is removed from .NET Framework assembly \Entity\EFCore3\Devart.Data.PostgreSql.Entity.EFCore.dll (PostgreSQL)
  • The definition of System.ICloneable is removed from .NET Framework assembly \Entity\EFCore3\Devart.Data.SQLite.Entity.EFCore.dll (SQLite)
  • The definition of System.ICloneable is removed from .NET Framework assembly \Entity\EFCore3\Devart.Data.DB2.Entity.EFCore.dll (DB2)
  • The HasFilter extension on IndexBuilder in EF Core Migrations is supported in EF Core 3 and EF Core 5 (PostgreSQL)
  • Mapping of internet/intranet data type System.Uri to PostgreSQL TEXT is supported in EF Core 3 and EF Core 5 (PostgreSQL)
  • 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 (PostgreSQL)
  • Mapping of internet/intranet data type System.Uri to SQLite TEXT is supported in EF Core 3 and EF Core 5 (SQLite)
  • Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to SQLite TEXT is supported in EF Core 5 (SQLite)
  • The SQL translation of these static methods of the MathF class used in LINQ query is supported in EF Core 5: Abs(), Round(), Truncate(), Floor(), Ceiling(), Max(), Min(), Pow(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan() (SQLite)
Devart development team
http://www.devart.com/dotconnect/entityframework.html

Locked