Monday, February 11, 2008

MySQL Connector/Net 5.2.0 Alpha has been released


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 [] 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

Bugs fixed

  • 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!


  1. Hi, Thank for that download link.

  2. Healthy Weight Loss TipsApril 2, 2009 at 12:43 AM

    I need a MySQL membership, roleprovider and profileprovider for an important project. But after installing the MySQL Connector/NET 5.2.0 I can't get it to work. I've found it difficult to use since there's no tutorials yet regarding this. Has anybody got it to work with a webproject in VS2005?

  3. here 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.

  4. fap turbo swiss robotJuly 1, 2009 at 10:48 AM

    I am going to check why new about mySql connector and net 5.2.0 alpha this time. Thank you for sharing the link, I appreciate it.

  5. best weight loss pillsJuly 1, 2009 at 10:58 PM

    MySQL Connector/Net 5.2 is the most exciting release of MySQL's fully managed ADO.Net provider to date. It’s nice to find out that now MySQL Connector can be integrated into Visual Studio 2008.

  6. dentists in NorthamptonJuly 20, 2009 at 10:06 PM

    Thanks for the information. I have been using a prior version and hope this new version MySQL Connector/Net 5.2.0 comes with great new features and fixes.