dotConnect for MySQL, formerly known as MyDirect .NET, is an enhanced ORM enabled data provider for MySQL that builds on ADO.NET technology to present a complete solution for developing MySQL-based database applications.
It introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.
The tool supports Entity Framework, NHibernate, and LinqConnect (formerly known as LINQ to MySQL).
PLEASE NOTE THIS IS A 30 DAY PROFESSIONAL TRIAL
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.
Entity Framework support:
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.