.NET

We have started a new project wiki for MySQL Connector/Net.  It’s a little light in content right now but should grow rapidly.  It can be found here.  Please let us know what we can do better.

MySQL Connector/Net 5.2.6, a new version of the all-managed .NET driver for MySQL has been released.  This release is of GA quality and is suitable for  use in production environments.  We strongly urge you to  review the change log that is shipped with the product for a thorough review of the changes.

We have a ton of fixes in this release so please review the changelog and see if your favorite bug has been fixed.  This version officially supports all versions of MySQL from 4.1 and later.

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.)

Changes since 5.2.5

• cleaned up how stored procedure execution operated when the user does or does not have execute privs on the routine (bug #40139)
• fixed problem with datetime formatting that causes an extra space to be included between the date and time when sent to the server (bug #41021)
• fixed sproc parameter parsing so that a space between the type and size spec would not cause a problem (bug #41034)
• removed code from profile provider that overrode Name and Description properties in error.  This had the effect of not allowing you to override those values in the web.config (ug #40871)
• fixed "metadatacollections" collection to include foreign key columns
• fixed GetAllProfiles (which is used by several methods).  It had a typo in the SQL and was not including several important columns (bug #41654)
• fixed problem where the core method GetUser was not properly checking the application id when retrieving user id values.  This would mean that in some cases methods like ValidateUser would return success when they shouldn’t.  (bug #42574)  This triggered several other cleanups in all the providers
• fixed problem with execution of LOAD DATA LOCAL INFILE (which also affected MySqlBulkLoader). When the driver encountered some type of error opening the local file for transport it would still attempt to close the file which would yield a null reference exception (bug #43332)
• fixed Sql null value exception when an attempt was made to reset the password and require question and answer was false.  (bug #41408)
• fixed MySqlDataReader.GetGuid to be more robust in how it attempts to read guid values (bug #41452)
• fixed bug where attempting to clear a pool twice would result in a null reference exception (bug #42801)
• Fixed problem with index column schema collection
• Fixed RemoveUsersFromRoles and DeleteRole where they were not calling transactionscope.Complete. This meant that on systems where the provider tables are transaction aware the changes could be rolled back in every case (bug #43553)
• Fixed typo in the collection returned when you request the MetaDataCollections collection.  The NumberOfRestrictions column was missing the trailing s. (bug #43990)
• fixed index and index column schema collections that would fail if you specified the any restrictions more specific than table name (bug #43991)
• removed a couple of unnecessary lines from NativeDriver.Open() (bug #44028)
• added connection string option ‘use affected rows’.  (bug #44194)
• changed MySqlPool so that a freshly pulled connection will issue it’s ping and reset outside of the idlepool lock.  This lessens some of the contention on the idle pool.

Enjoy!

MySQL Connector/Net 6.0.1, a new version of the all-managed .NET driver for MySQL has been released. This is a beta release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment.

We had three major goals with this release. Speed, Entity Framework support, and a better Visual Studio experience. I’m happy to report that we have met all three. Please see the complete list of changes below.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.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.)

• Massive speedups. We have increased the speed of the provider. In many situations it now matches or exceeds the speed of the native C connector.
• SQL tokenizing has been improved dramatically. Not only is it substantially faster (approx 40%) it also now uses a completely rewritten tokenizer that supports all types of stored procedure comments.
• Added UDF schema collection
• Implement initial Entity Framework support (see below)
• Improved Visual Studio integration (see below)

Entity Framework support
Yes, we are late to the party but we are here. I apologize for the delays related to this release and I hope that those of you looking to use MySQL with the entity framework will still want to give us a look. This releases uses a entity framework engine that was completely developed in-house and is, therefore, licensed in exactly the same way as our core provider. Please remember that this is an alpha release and we are certain that you will find databases that will not reverse-engineer correctly or you will build models or queries that will not generate correctly. Please file those as bug reports and include all the information you can. We’ll quickly get to those as we are going to move as quickly as possible to GA.

Visual Studio improvements
We have completely rewritten our Visual Studio integration bits and are delivering several exciting features with it. Here’s a look at some of those features:

1. Now uses the same toolbars and commands as SQL Server so the integration is much more seamless.
2. Uses the native code editor which means code splitting and syntax highlighting.
3. Change script generation
4. And many more smaller features…..

Please take this version for a test drive and let us know what works and what doesn’t.

MySQL Connector/Net 5.2.4, a new version of the all-managed .NET driver for MySQL has been released.  This release is of GA quality and is suitable for  use in production environments.  We strongly urge you to  review the change log that is shipped with the product for a thorough review of the changes.

We have a ton of fixes in this release so please review the changelog and see if your favorite bug has been fixed.  Version 5.2.4 works with all versions of MySQL including MySQL-4.1,  MySQL-5.0, MySQL-5.1, and the MySQL-6.0 beta.

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.)

Changes since 5.2.3

• fixed web providers autogenerateschema option where it would fail if no schema is   present at all (bug #39072)
• backported fix for lingering problem related to bug #37239.  If two columns had the same name but different case then an exception would be thrown.
• fixed stored procedure parameter parsing when used inside server explorer.  (bug #39252)
• fixed time data type so that negative values are handled properly (bug #39275)
• added runtime check for the mono platform to our Membership provider.  The mono runtime as of 1.9.1 did not support the methods needed for hashed passwords (bug #38895)
• fixed problem where negative time values with a zero hour would return as positive values (bug #39294)
• fixed problem where using a stored procedure with parameters with a table adapter was no longer working after our parameter schema changes (bug #39252)
• fixed problem with profile provider where INSERT .. ON DUPLICATE UPDATE syntax would not work correctly with some older server versions (bug #39330)
• Defaulting max allowed packet to 1024 to account for the possible case where the value doesn’t come in as a server variable
• fixed bug #39728 by making MySqlConnectionStringBuilder.GetConnectionString an internal method.   It should not have been publicly available anyway.  It is used internally by the MySqlConnection.ConnectionString property
• implemented Disposable pattern on MySqlTransaction class so including one in a using statement and then not calling commit will cause a rollback when the using exits (bug #39817)
• fixed MySqlScript object so that it handles scripts with user variables
• fixed bug where specifying ‘functions return string=yes’ would cause strings to be returned using the ‘binary’ charset which would not properly render some characters.  Now the connection character set is used. (bug #40076)
• fixed problem that caused in use connection strings to be modified when a pooled connection timed out and was cancelled.  (bug #40091)
• fixed problem where using respect binary flags would not use the connection char set and therefore return strings with a bad encoding.
• fixed bug where provider was attempting to use the new parameters I_S view on servers that didn’t have it (bug #40382)
• fixed problem where CharSetMap.GetDefaultCollation and CharSetMap.GetMaxLengths might have a thread sync issue on high load systems.  They were not locking the static collections there were initializing. (bug #40231)
• added GetSByte to the reader for returning tinyint columns (bug #40571)

Thanks for using MySQL Connector/Net!