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)
http://www.devart.com/dotconnect/entityframework.html