Archive for May, 2007

We are happy to announce that we have now enabled interim snapshots for Connector/Net 5.1.  It can be found at http://downloads.mysql.com/snapshots.php.

These will not currently update nightly.  In the future, we hope to enable nightly uploads of snapshots.  In the meantime, please take care when using these builds.  They are snapshots directly out of our development trees and are not guaranteed to function at all.  They are intended simply to give users and customers an advance look at what is coming in future released versions.
Thanks!

MySQL Connector/Net 5.1.1 a new version of the all-managed .NET driver for MySQL has been released.

This is a big release and represents a change in how we package our products. Until now, we’ve shipped our core provider and the Visual Studio integration bits as separate downloads. This has become a bit of a problem. Often we would fix a bug that involved changing code both in the VS package and in the core provider. This provided a versioning problem where users would need to upgrade both products to see the benefit of the bug fix. To solve this, we’ve decided to discontinue Tools for Visual Studio as a separate product and have, instead, integrated it into a new Connector/Net installer. We hope this provides a better “out of box” experience for our users.

All previous versions of Tools for Visual Studio should be uninstalled prior to installing this product.

Version 5.1.1 works with all versions of MySQL including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-6.0 Falcon “Preview”. Please be aware though that this version is alpha quality software and should not be used in production environments.

It is now available in source and binary form from [dev.mysql.com] 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.)

Bugs fixed:

• Fixed password property on MySqlConnectionStringBuilder to use PasswordPropertyText attribute. This causes dots to show instead of actual password text.
• Fixed problem with pooling on the compact framework. It should work now.
• Install now calls VS setup only when VS integration is selected. (bug #28260)
• MySqlRoleProvider.GetRolesForUser now works correctly (bug #28251)
• Installer now adds a default connection string to machine.config. This will prevent errors related to a missing connection string. You will need to override this value in your web.config files.
• Changed installer to only give option to install Visual Studio integration if Visual Studio 8 is installed

(Bugs fixed in 5.0.7 that are now appearing in 5.1.1)

• Bug #27765 Logging does not work
• Bug #27679 MySqlCommandBuilder.DeriveParameters ignores UNSIGNED flag
• Bug #27668 FillSchema and Stored Proc with an out parameter
• Bug #28167 Poor performance building connection string (thanks Maxim!)
• Bug #26041 Connection Protocol Property Error in PropertyGrid Control
• Bug #26754 EnlistTransaction throws false MySqlExeption “Already enlisted”
• Bug #23342 Incorrect parsing of Datetime object for MySQL versions below 4.1

Where to get information.

.NET forum: [forums.mysql.com]
.NET mailing list: [lists.mysql.com]
Reggie’s blog: [www.bytefx.com]
Planet MySQL: [www.planetmysql.org]

As always we thank you for your use of our products and keep those bug reports coming!

Hi,

MySQL Connector/Net 5.0.7 a new version of the all-managed .NET driver for MySQL has been released.

This is a bug fix release for the current production branch of Connector/Net.

Version 5.0.7 is suitable for use with any MySQL version 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 the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/5.0.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.)

Bugs fixed

• Bug #27269 MySqlConnection.Clone does not mimic SqlConnection.Clone behavior
• Bug #27289 Transaction is not rolledback when connection close
• Bug #26147 “User Id” problem during connection creation
• Bug #27240 Property value characterset not retrieved/fetched in conn wizard
• Bug #25947 CreateFormat/CreateParameters Column of DataTypes collection incorrect for CHAR
• Bug #27765 Logging does not work
• Bug #27679 MySqlCommandBuilder.DeriveParameters ignores UNSIGNED flag
• Bug #27668 FillSchema and Stored Proc with an out parameter
• Bug #28167 Poor performance building connection string (thanks Maxim!)
• Bug #26041 Connection Protocol Property Error in PropertyGrid Control
• Bug #26754 EnlistTransaction throws false MySqlExeption “Already enlisted”
• Bug #23342 Incorrect parsing of Datetime object for MySQL versions below 4.1

Other changes

• Installer now works if XML comments are found in machine.config
• GetSchema will now attempt to unquote identifiers passed in as restrictions
• The MySqlCommand object now properly clones the CommandType and CommandTimeout properties

Thanks for trying out this release.

Reggie

MySQL

Often people ask me how to retrieve the value of an autoincrement column when they are using the MySqlCommandBuilder object.  Generally this is done by appending something like “;SELECT last_insert_id()” onto the generated insert command text.  Command builder objects usually provide some type of syntax where a user can indicate that they want this to be done.  Connector/Net 1.0 had some syntax for this but starting with Connector/Net 5.0 that all changed. 

With the new ADO.Net 2.0 API, Microsoft did not directly provide for any type of API that users could use for selecting this.  With ADO.Net 2.0, there are two things that need to happen.  First, a SELECT statement similar to above must be attached to the INSERT command.  Second, the command object must have its UpdatedRowSource property set to Both or FirstReturnedRecord.  What this does is tell the data adapter update engine to take the first returned row and merge it’s values back into the changed row.  So, if the first returned row is the result of a ‘SELECT last_insert_id()’, then the generated key will be returned and merged back in.  Good, huh?

Not so fast.  The UpdatedRowSource property exists on the command object.  The whole point of using MySqlCommandBuilder is to not mess with command objects.  Everything should be handled automatically with as little code as possible.  To this end, we’ve added a custom property to MySqlCommandBuilder called ReturnGeneratedIdentifiers.  By setting this property to true, the proper select statement will be included and the generated command object will have its UpdatedRowSource property set.