Devart is glad to announce the release of dotConnect for MySQL 8.16 — a powerful ADO.NET provider for MySQL with advanced support for Entity Framework, Entity Framework Core, and LinqConnect ORMs. The new version offers you support for Entity Framework Core 3.1.
After Microsoft released Entity Framework 3 only for .NET Core 3 (.NET Standard 2.1), it caused certain criticism because of not supporting Full .NET Framework. Microsoft reacted to this criticism by making Entity Framework Core 3.1 compatible with .NET Standard 2.0, and thus, allowing developers to use it in projects, targeting Full .NET Framework as well as .NET Core.
So finally we also can support Entity Framework Core 3 for Full .NET Framework too, and we have added this support to all of our ADO.NET providers for cloud apps and for major databases.
dotConnect for MySQL now includes a new Devart.Data.MySql.Entity.EFCore.dll assembly for Entity Framework Core 3.1 support on Full .NET Framework. You can find it in the \Entity\EFCore3 subfolder of the provider installation folder.
dotConnect for MySQL also keeps supporting Entity Framework 6, and we have updated it to support Entity Framework 6.4.
Here is the complete list of dotConnect for MySQL 8.16.1541 features:
- Visual Studio 2019 version 16.5 Preview is supported
- The bug with using Toolbox component MySqlDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
- The bug with enabling Devart DataSet Editor in Visual Studio 2017 and Visual Studio 2019 is fixed
- The bug with using Toolbox component DbLinqDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
- The bug with creating one-to-one association basing on an optional FK in EF Core Model is fixed
- The bug with code generation for oneOrZero-to-one and one-to-many associations based on an optional FK in EF Core Model is fixed
- The bug with generating a mapping for a unique constraint specified in owned type property of EF Core Model is fixed
- Entity Framework 6.4 is supported
- Entity Framework Core 3.1 is supported
- The new \Entity\EFCore3\Devart.Data.MySql.Entity.EFCore.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
- The new config.CodeFirstOptions.TruncateAllLongNames option (default value is False) is added to use EF Core 2/EF Core 3 implementation for truncating long names of columns and PK/FK/IX/UX
- The config.DatabaseScript.ForeignKey.IndexCreation configuration option is supported in EF Core 1/EF Core 2/EF Core 3
- The RenameColumn operation translated to ALTER TABLE RENAME COLUMN is supported for MySQL 8.0 and higher via Code-First Migrations in EF4/EF5/EF6/EF Core 1/EF Core 2/EF Core 3
- The behavior is changed: System.Decimal is mapped now to MySQL data type DECIMAL(58,29) instead of DECIMAL by Code-First Migrations in EF Core 1/EF Core 2/EF Core 3
- The bug with creating a unique constraint in the database via EF Core Code-First Migrations is fixed
- The bug with applying .ValueGeneratedOnAdd() to the string, guid, byte properties with .Key() and without .HasDefaultValueSql() in EF Core is fixed
- The error message with notification about missing annotation for the RenameColumn operation translated to ALTER TABLE CHANGE COLUMN in case of MySQL versions lower than 8.0 is fixed
- The bug with detecting implicit database column type, when model mapping and migration mapping are different, via EF Core Code-First Migrations is fixed
- The bug with generating SQL when using explicit cast in LINQ queries in EF Core 1/EF Core 2 is fixed
- The bug with throwing the "Null TypeMapping in Sql Tree" error by methods in LINQ query in EF Core 3 is fixed