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
SSL is supported in .NET Standard 2.0 provider assemblies.
Proxy connection is supported for the SSL and HTTPS protocols.
The bug with connecting to MariaDB with GSSAPI authentication is fixed.
Entity Framework Core 2.1 is supported -
Query type support is added: classes now have the Query Type property, and if it is set to true, this class is generated as a query type.
Lazy loading for Entity Framework Core 2.1 is supported >
Model now has the Use Lazy-Loading Proxies property, which enables lazy loading on the model level.
Navigation properties now have the Lazy property, which enables lazy loading for a specific navigation property.
Properties now have the Constructor Parameter property, for configuring a parameterized constructor of the class.
The "Include Environment Variables" property, determining whether context configuration will be extended with environment variables when a connection string from the appsettings.json file is used, is added to the EF Core template.
The "Json File Base Path" property, specifying the base path for file-based providers when a connection string from the appsettings.json file is used, is added to the EF Core template.
Entity Framework support:
Entity Framework Core 2.1.1 is supported.
The bug with applying the updated provider behavior after changing connection string options in EF Core 2 is fixed.
The bug with generating incorrect SQL when using IndexOf expression in EF Core is fixed.