Released: Jan 25, 2022

V8.21.2066 での更新項目

機能

• Added support for Microsoft .NET 6.0.

Entity Developer

• Changed behavior: Turning off the "Save connection to" option in Model Settings of Entity Framework Core Model wipes out connection string literal from the generated code.
• Changed behavior: Devart.Data.MySql.Entity.EF5.dll compiled with Microsoft .NET Framework 4.7 is now used in Entity Framework 5 models.

Entity Framework support

• Mapping of internet/intranet data type System.Uri to MySQL string data types is now supported in Entity Framework Core 3, 5 and 6.
• Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to MySQL string data types is now supported in Entity Framework Core 5 and 6.
• The SQL translation of the following class members used in LINQ query is now supported in Entity Framework Core 3, 5 and 6:
  • static method IsNullOrWhiteSpace() of the String class.
  • static property Today and instance property DayOfWeek of the DateTime class.
  • static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the Math class.
• The SQL translation of the following class members used in LINQ query is now supported in Entity Framework Core 5 and 6:
  • static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the MathF class.
• The SQL translation of the following class members used in LINQ query is now supported in Entity Framework Core 6:
  • static method Log2() of the Math and MathF classes.
• Added new \Entity\EF5\net47\Devart.Data.MySql.Entity.EF5.dll, \Entity\EF5\net47\Devart.Data.MySql.Entity.Migrations.EF5.dll and \Entity\EF5\net47\Devart.Data.MySql.Entity.Spatials.EF5.dll assemblies compiled with Microsoft .NET Framework 4.7.
• Added new methods ExtractAsByte(), ExtractAsSByte(), ExtractAsInt16(), ExtractAsInt32(), ExtractAsInt64(), ExtractAsSingle(), ExtractAsDouble(), ExtractAsDecimal() and ExtractAsDateTime() to the MySqlJsonFunctions class for working with the JSON data type in LINQ to Entities queries.

不具合の修正

Entity Framework support

• Fixed the bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in Entity Framework Core.
• Fixed the bug with a materialization used within the Let operator of LINQ query in Entity Framework 6.
• Fixed the bug with using .Contains with a collection within .Select of LINQ query in Entity Framework Core 2.