MySQL Connector/NET 6.7.5, a new version of the all-managed .NET driver for MySQL has been released. This is the GA, is feature complete. It is recommended for production environments. It is appropriate for use with MySQL server versions 5.0-5.7.
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloadsand mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.) The 6.7 version of MySQL Connector/NET brings the following new features: - WinRT Connector. - Load Balancing support. - Entity Framework 5.0 support. - Memcached support for Innodb Memcached plugin. - This version also splits the product in two: from now on, starting version 6.7, Connector/NET will include only the former Connector/NET ADO.NET driver, Entity Framework and ASP.NET providers (Core libraries of MySql.Data, MySql.Data.Entity & MySql.Web). While all the former product Visual Studio integration (Design support, Intellisense, Debugger) are available as part of MySQL Windows Installer under the name "MySQL for Visual Studio". WinRT Connector ------------------------------------------- Now you can write MySql data access apps in Windows Runtime (aka Store Apps) using the familiar API of Connector/NET for .NET. Load Balancing Support ------------------------------------------- Now you can setup a Replication or Cluster configuration in the backend, and Connector/NET will balance the load of queries among all servers making up the backend topology. Entity Framework 5.0 ------------------------------------------- Connector/NET is now compatible with EF 5, including special features of EF 5 like spatial types. Memcached ------------------------------------------- Just setup Innodb memcached plugin and use Connector/NET new APIs to establish a client to MySQL 5.6 server's memcached daemon. Changes in MySQL Connector/Net 6.7.5 (2014-04-04) Bugs Fixed * Entity Framework threw a NullReferenceException on insertion of a record into tables that had an auto-increment, unsigned, bigint primary key. (Bug #18189217, Bug #71242) * "MaximumPoolSize" and "MinimumPoolSize" were not recognized as valid connection string options. (Bug #18182246) * The MySQL parser did not recognize the full string literal syntax of [_charset_name]'string' [COLLATE collation_name] as supported by the MySQL Server. This fix makes Connector/Net and MySQL for Visual Studio recognize the string literal syntax as specified in the Character String Literal Character Set and Collation (http://dev.mysql.com/doc/refman/5.6/en/charset-literal.html) section of the MySQL Server manual. (Bug #18169145) * In Visual Studio, Connector/Net did not read the millisecond portion of a time value for a field of type TIME(3). (Bug #18111085) * When Connector/Net's SQL generator emitted code for the LINQ Union() or Concat() operator, parentheses were not applied around the individual SELECT statements. That could cause a change of meaning for the query when a Take() operator (thus a LIMIT clause in the SQL code) was applied to the last SELECT statement. With this fix, parentheses were put around individual SELECT statements, so that the LIMIT clause will not be applied to the entire result of the UNION operation. (Bug #18049691, Bug #70828) * During migrations with ASP.NET Identity 1.0 in Visual Studio, the code generator did not generate the indexes and foreign keys in the Up() class. (Bug #18049272, Bug #71287) * Connector/Net did not add the AUTO_INCREMENT property to a primary key column of type BIGINT when creating a model in Entity Framework. (Bug #17924407, Bug #17937401, Bug #70602) * Millisecond values written to a TIME(6)-typed field of a database were wrongly serialized by Connector/Net. (Bug #17924388, Bug #70686) * The RenameColumn operation in an Entity Framework migration threw an "Unknown column 'no' in the 'field list'" error when Update-Database was applied. (Bug #17959787, Bug #71102) * A MySQL-session-state-enabled web application threw exceptions for referencing the wrong table name my_aspnet_Sessions (instead of the correct name my_aspnet_sessions). This was due to the incorrect case handling of the SQL queries for MySqlSessionStateStore. (Bug #17960855, Bug #69652) * The value for the Keepalive option in the connection string was interpreted by Connector/Net to be in milliseconds. This fix makes it to be interpreted as number of seconds, as specified in the documentation. (Bug #17981275, Bug #69484) * When using the Code First approach in Entity Framework 5, automatic migrations failed with the use of foreign keys. (Bug #17929549) * Connector/Net threw a NullReferenceException when trying to save an entity into a table with a tinyint or bigint auto-incremented primary key. (Bug #17866076, Bug #70888) * Could not open the ASP.NET Web Configuration tool in the Solution Explorer when using MySQL for Visual Studio 1.0.2 and Connector/Net 6.7.5. (Bug #17898244, Bug #69808) * Fractional part of a value read by MySqlDataReadeer.GetTimeSpan() from a TIME(3)-typed field was dropped. (Bug #17923814, Bug #70377) * When using the Code First approach in Entity Framework 5, a LINQ query that checked whether a nullable column was null resulted in a faulty SQL query being generated. (Bug #17285548, Bug #69922) * Executing a LINQ query containing an order by clause and a call to the Contains method using the Take method resulted in a bad SQL query, which made reference to a no-existent alias. (Bug #17194945, Bug #69751) The documentation is available at: http://dev.mysql.com/doc/refman/5.7/en/connector-net.html Enjoy and thanks for the support! On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql