Devart is glad to announce the release of the new version of dotConnect for MySQL, enhanced database connectivity solution, built over the ADO.NET architecture, that supports Entity Framework and LinqConnect ORM solutions.
New version of dotConnect for MySQL offers you support for Microsoft Sync Framework 2.1 and MySQL load balancing.
Sync Framework Support
dotConnect for MySQL now provides support for Sync Framework 2.1. It provides MySqlSyncProvider class, classes for provisioning and deprovisioning, and MySqlSyncDescriptionBuilder class. Now you can easily synchronize your MySQL databases using dotConnect for MySQL.
Support for Load Balancing in MySQL
Now you can specify several hosts with their ports in the Host parameter of the connection string, like "Host = (localhost:3307,db:3308,db)", and dotConnect for MySQL will switch host for each new SELECT or SHOW statement. The first host is considered the master server, and all statements, other than SELECT and SHOW, will be executed against it.
Here is the complete list of dotConnect for MySQL 8.0.17 features:
- Microsoft Sync Framework support is implemented
- Load Balancing support is implemented: now several hosts with their ports can be specified in the Host parameter of the connection string, and dotConnect for MySQL will switch the host for each new SELECT or SHOW statement
- The Collate method of the SqlMethods class is implemented
- The bug with ignoring 'IsDbGenerated = True' when using Attach(TEntity entity, bool asModified) method is fixed
- The bug with the compiled query cache when query contains parameters with the same values is fixed
- The predefined templates are improved: new template setting, "Use Compiled Query Cache", is added (LinqConnect models)
- The bug with "DevartEntityDeploy" task, which generates mapping files, in Visual Studio 2013 Release Candidate is fixed
- The behaviour is changed: Code-First Migrations generates DEFAULT 0 for new NOT NULL columns of numeric types when adding them in the existing table
- The behaviour is changed: Code-First Migrations generates DEFAULT '' for new NOT NULL columns of string types when adding them in the existing table
- The bug with performing queries via the ExecuteStoreQuery, SqlQuery methods in Entity Framework 6 is fixed