Devart is glad to announce the release of dotConnect for MySQL 8.12 — a powerful ADO.NET provider for MySQL with advanced support for Entity Framework, Entity Framework Core, and LinqConnect ORMs.
The new version of dotConnect for MySQL features MySQL 8.0 support. We have supported the new default MySQL authentication plugin – caching_sha2_password. The list of MySQL charset collations was extended with the new collations introduced in MySQL 8.0.
dotConnect for MySQL is now fully compatible with the latest MySQL version, and you can use it for your applications that need to connect to MySQL 8.0.
Here is the complete list of dotConnect for MySQL 8.12.1190 features:
- MySQL 8.0 is supported
- The authentication plugin caching_sha2_password is supported
- The list of charset collations is updated with new values added in MySQL 8.0
- The keywords and reserved words of MySQL 8.0 are supported
- The behaviour is changed: the DeriveParameters method of MySqlCommandBuilder takes information about parameters from INFORMATION_SCHEMA instead of mysql.proc table for MySQL 8.0
- The IDbColumnSchemaGenerator interface and the MySqlDataReader.GetColumnSchema() method are implemented in .NET Standard provider assemblies
- The performance of the SSIS Lookup component is improved due to using one IN clause instead of many OR clauses
- The bug with throwing the "Socket.IOControl handles Windows-specific control codes and is not supported on this platform." error by .NET Standard compliant assemblies on Linux and MacOS is fixed
- The bug with paging in EF Core 2.1 is fixed
- The bug with using the aggregate functions in EF Core 2.1 is fixed
- The bug with translating calls to properties and methods in LINQ query to SQL statement in EF Core 2.1 is fixed
- The bug with processing arguments of functions mapped via .HasDbFunction in EF Core 2 is fixed
- The bug with applying a filter with implicit EnumToStringConverter via LINQ queries in EF Core 2 is fixed
- The bug with using the String.CompareTo method via LINQ queries in EF Core is fixed
Devart development team
http://www.devart.com/dotconnect/mysql/