Devart - ( Commercial Trial)
dotConnect for MySQL enhanced ORM data provider to easily create MySQL-based database applications.
dotConnect for MySQL is a reliable and enhanced ORM (Entity Framework, NHibernate, LinqConnect) enabled data provider build over ADO.NET architecture, being in the same time a development framework with impressive innovative technologies. It was developed to offer a complete solution for designing MySQL-based database applications while increasing the productivity in the same time. The application offers flexible conectivity – being able to operate in Direct Mode without MySQL client library and in Client mode with usage of libmysql.dll, database application development extensions, MySQL advanced features such as SSL and SSH connections, embedded server, HTTP tunneling and more, BIS support, ASP.NET Identity 1 and 2 support, Sync Framework support, a vast number of GUI tools that increase your productivity, per-component tracing of database events with a free dbMonitor application and much more.
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.