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.
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 Developer:
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.