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.
The behavior is changed: now "Unicode=true;" sets client character set to utf8mb4 for MySQL Server 5.5.3 and higher.
The bug with connecting to database with .NET Standard 1.3 compatible assemblies on .NET Framework 4.6.0 run-time is fixed.
LinqConnect (formerly known as LINQ to MySQL)
The new overload DataContext.Refresh(bool ignoreErrors, RefreshMode mode, object entity) is added for ignoring errors during refresh.
The existing overload DataContext.Refresh(RefreshMode mode, object entity) is improved: its check avoids the try to refresh the entity that is added to the context but not submitted to the database.
The type and text of the error generated by the DataContext.Refresh(RefreshMode mode, object entity) method, when the passed entity doesn't exist in database, is fixed.
The bug with generating the COALESCE expression is fixed.
Entity Developer
The multiple select functionality in EF Core Model is improved: now it allows setting PrimaryKey, ValueGenerated, Concurrency for several properties simultaneously.
The bug with detecting order of columns in composite primary key with two or more columns by Update To Database and by Update From Database wizards in EF Core is fixed.
The bug with using ASP.NET Core Web Application (.NET Framework) and Azure Functions v1 (.NET Framework) projects in Visual Studio 2017 is fixed.
Entity Framework support
Entity Framework Core 2.2.1 is supported.
The new extension method Database.IsMySql() in EF Core 2 is implemented.
The config.QueryOptions.NullStringCollation option is implemented to use the COLLATE operator with a required collation when comparing null strings in "equal" and "not equal" cases.
The bug with applying config.Workarounds.IgnoreSchemaName=true to the .ToTable() functionality in EF Core 2 is fixed.
The bugs with using the GuidToStringConverter, EnumToStringConverter, ValueConverter classes in EF Core 2 are fixed.
The bug with constructing the LIKE clause in EF Core 2 is fixed.
The bug with generating a subselect within the SELECT list in EF Core 2 is fixed.
The bug with applying an aggregate function to the result of a subselect in EF Core 2 is fixed.