MySQL Connector/Net 5.2.0 a new version of the all-managed .NET driver for MySQL has been released. This release is an alpha and may contain bugs with some of them possibly being severe. You are strongly urged to not use this release in production environments. This release is intended only for testing and feedback purposes.
There are many changes in this release including an extensive change related to using @ as a parameter marker instead of ?. There is a more thorough write-up of the breaking changes in the release notes and we strongly encourage you to read those notes to better understand the changes.
Version 5.2.0 works with all versions of MySQL including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-6.0 Falcon "Preview".
It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/5.2.html] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)
Features or behavior changes
- Added connection string option 'Treat Tiny As Boolean' so applications that expect TINYINT(1) to return an integer will not break (bug #34052). This setting is true by default. If your application expects TINYINT(1) columns to be returned as integer, you need to set this setting to false.
- Added the ability to clear a single or all connection pools.
- Added Visual Studio 2008 integration.
- Added support for batching to MySqlDataAdapter. Batching is fully supported including collapsing inserts down into the multi-value form if possible.
- Added MySqlScript class for executing scripts against a database.
- Marked connection string option 'Use Old Syntax' as obsolete and changed code to allow both @ and ? as parameter markers.
- Added MySqlBulkLoader class for easily executing LOAD DATA commands
- Added support for treating BINARY(16) columns as GUID values
- Perfmon counters are now created using Wix code instead of a managed custom action. This seems to help the problem where some installation were failing becausing of being unable to register the counters.
- Added Allow User Variables connection string option so that users can use user variables without getting missing parameter exceptions. This feature is related to our move back to using @ as parameter marker. (see release notes)
- Added a new profile provider to our web providers collection
- Completely revamped provider schema allowing for tighter integration between the providers
- Fixed problem with membership provider where FindUserByEmail would fail trying to add a second parameter with the same name as the first (bug #33347)
- Fixed long standing problem with compression over a network. It's now fast again. (bug #27865)
- Fixed nant compilation problem on mono (bug #33508)
- Fixed problem where connection state reported through the state change handler was not showing Open (bug #34082)
- Incorporated some connection string cache optimizations sent to us by Maxim Mass (bug #34000)
- Fixed problem with opening a connection that was previously closed by sudden server disconnection (bug #33909)
- Fixed code to yield better exception when using different connection strings in a single transaction (bug #34204)
- Small bug fix and speed enhancement in Statement.TokenizeSql (bug #34220)
Enjoy and thanks for the support!