dotConnect for MySQL 8.21 is released!

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Locked
Devart
Site Admin
Posts: 3974
Joined: Tue 26 Oct 2004 13:51

dotConnect for MySQL 8.21 is released!

Post by Devart » Thu 27 Jan 2022 09:14

Dear users,

Devart is glad to announce the release of dotConnect for MySQL 8.21 with significant improvements in Entity Framework Core support. We supported new data types Uri, IPAddress, PhysicalAddress and expanded the capabilities for translating LINQ queries into SQL. Besides, we have improved support for working with JSON in LINQ queries for EF6.

New data types Uri, IPAddress, PhysicalAddress are supported and the capabilities for translating LINQ queries into SQL are expanded. We have also improved support for working with JSON in LINQ queries for EF6.

Here is the complete list of dotConnect for MySQL 8.21.2066 changes:

Entity Developer
  • The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
  • The behavior is changed: Devart.Data.MySql.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models
Entity Framework support
  • Mapping of internet/intranet data type System.Uri to MySQL string data types is supported in EF Core 3, EF Core 5, EF Core 6
  • Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to MySQL string data types is supported in EF Core 5 and EF Core 6
  • The SQL translation of the following class members used in LINQ query is supported in EF Core 3, EF Core 5, EF Core 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 the LINQ query is supported in EF Core 5 and EF Core 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 the LINQ query is supported in EF Core 6:
    • static method Log2() of the Math and MathF classes
  • The new \Entity\EF5\net47\Devart.Data.MySql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
  • The new \Entity\EF5\net47\Devart.Data.MySql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
  • The new \Entity\EF5\net47\Devart.Data.MySql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added
  • The new methods ExtractAsByte(), ExtractAsSByte(), ExtractAsInt16(), ExtractAsInt32(), ExtractAsInt64(), ExtractAsSingle(), ExtractAsDouble(), ExtractAsDecimal(), ExtractAsDateTime() are added to the MySqlJsonFunctions class for working with the JSON data type in LINQ to Entities queries
  • The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
  • The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
  • The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed
Devart development team
http://www.devart.com/dotconnect/mysql/

Locked