Direct Mode

Allows your application to work with MySQL directly via TCP/IPwithout involving MySQL client library.

Implements Role, Session State, Membership, Profile, Site Map, and other ASP 2.0 providers.

Enterprise Library

Can be used in conjunction with Microsoft Enterprise Library Data Access Application Block.

BIS

Enables Integration Services to export and import data to/from MySQL servers.

Monitoring

Allows per-component tracing of database events with a free dbMonitor application.

Compatibility

Supports MySQL servers 3.23 and higher on .NET and .NET Compact Framework 2.0 and higher, .NET Core, and Mono.

New features in dotConnect for MySQL 8.10

The current build is 8.10.1031 from 23-Nov-2017

• .NET Standard 2.0 is supported
• .NET Standard 2.0 compatible assemblies are added to the Devart.Data and Devart.Data.MySql NuGet packages
• Distributed transactions are supported
• The MySqlDataAdapter and MySqlCommandBuilder are implemented
• The MySqlConnection.GetSchema() and MySqlDataReader.GetSchemaTable() methods for metadata retrieving are implemented
• The MySqlDataSourceEnumerator class is implemented
• The MySqlDependency class is implemented
• The MySqlDump class is implemented
• Component classes in .NET Standard 2.0 compatible assemblies are inherited from the Component class, and some of them implement the ICloneable and ISupportInitialize interfaces
• Some of the classes, representing data types, now implement the INullable and ISerializable interfaces
• .NET Core 2.0 is supported
• The CancelEditRowIfUpdateFailed property, determining whether to call CancelEdit for the row after update of the row is failed when data binding is used, is added to MySqlDataTable

LinqConnect (formerly known as LINQ to MySQL)

• .NET Standard 2.0 is supported
• .NET Core 2.0 is supported
• The performance of generating complex queries is improved

Entity Developer

• .NET Standard 2.0 projects in Visual Studio 2017 are supported
• .NET Core 2.0 projects in Visual Studio 2017 are supported
• Entity Framework Core 2.0 is supported
• The Retrieve Data functionality via Model Explorer for EF Core 2 is implemented
• The new "Detect function-based column default value" option is implemented in Model Settings of EF Core model
• The code generation for async method calls is added to the EF Core template
• The usage of long identifiers (up to 140 symbols) for naming model objects is supported

Entity Framework

• Entity Framework Core 1.1.3 is supported
• Entity Framework Core 2.0 is supported
• Entity Framework 6.2 is supported
• The SQL generation for subselects, when using Distinct(), in EF1/EF4/EF5/EF6 is optimized
• The Code-First Migrations functionality in EF Core is improved:
• the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2), EnsureSchema (creates database if not exists), DropSchema (removes database) are supported