Monday, November 6, 2006

MySQL Connector/Net 5.0.2 has been released!

MySQL Connector/Net 5.0.2 Beta has been released.  MySQL Connector/Net is an all-managed ADO.Net provider for MySQL.  While this release is suitable for any version of MySQL, it is strongly encouraged that this release not be used on any production data. 

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

Changes in this release (changelog):

Bugs fixed

  • Bug #23268 System.FormatException when invoking procedure with ENUM input parameter
  • Bug #23538 Exception thrown when GetSchemaTable is called and "fields" is null.
  • Bug #23245 Connector Net 5.01 Beta Installer produces Antivirus Error Message
  • Bug #23758 Unable to connect to any server - IPv6 related
  • Bug #22882 Registry key 'Global' access denied
  • Bug #18186 Problem with implementation of PreparedStatement

Other changes

  • Increased speed of MySqlParameterCollection.IndexOf(string) orders of magnitude (parameter name lookups are now strict on use of parameter marker)
  • Improved character set mappings
  • Turned MySqlPoolManager into a static class and added a static ctor to avoid any race conditions related to initializing the hashtable.
  • Added 'Ignore Prepare' connection string option for disabling prepared statements application-wide
  • Added Installer class to provide custom install type procedures such as modifying machine.config
  • A nicer exception is displayed if you have added a parameter without the parameter marker.
  • Load Data Local InFile is working again
  • Installer now gives the user the choice of creating start menu items and registering the provider in the GAC.

 

NEW CONNECTION STRING OPTION
We have added a new connection string option named 'Ignore Prepare'. It is a boolean option and its default value is true. This option, when true, instructs the provider to ignore any calls to MySqlCommand.Prepare(). We decided to do this because we have discovered some inconsistencies with server side prepared statements which can lead to incorrect or damaging results. If you are sure you want to use server-side prepared statements, then you can add 'ignore prepare=false' to your connection string and it will behave as before.

 

Highlights of the 5.0.x Connector/Net releases:

Support for ADO.Net 2.0 interfaces and subclasses

Re-architected to improve speed and flexibility
The internals of the provider have been improved to allow column values to be retrieved without boxing in many cases.  Also, the internal changes have enabled the future inclusion of embedded and client library support.

Implemented Usage Advisor
The Usage Advisor first appeared in Connector/J.  We have now implemented that feature in Connector/Net.  Enabling it causes the provider to check both your queries and how you read the results and report to you if it thinks you are using the provider in an  inefficient manner.  It checks such things as using a query without an index, not reading all the columns or rows from a resultset, etc.

Implemented asynchronous query methods
The MySqlCommand object now supports asynchronous queries.  This is implemented using the BeginExecuteNonQuery and EndExecuteNonQuery methods.  BeginExecuteReader and EndExecuteReader are now included.

Implemented stored procedure metadata caching
We now cache the metadata that is retrieved during stored procedure and stored function execution.  This cache data is used for subsequent executions of that stored routine.

Added PerfMon hooks
This release includes PerfMon hooks to monitor stored procedure cache hits and misses.  We are looking at adding additional hooks in the first beta release.

Removed use of SharpZipLib library
We have replaced use of the SharpZipLib library with the deflate support available with .NET 2.0.

Support for embedded server and client library has been removed
For those of you that have seen my presentations on 5.0, we decided to remove these features to help get 5.0 out the door more quickly.  These features will reappear in a later version of the product.

Thank you for checking out this release of Connector/Net. 

-Reggie

20 comments:

  1. interesting!!thanks for the info

    ReplyDelete
  2. Busby SEO Test Spammer!January 13, 2009 at 10:38 AM

    beware of busby seo test spammer!

    ReplyDelete
  3. another connector choice

    ReplyDelete
  4. MySQL Connector/Net 5.0.2 Beta has been released. MySQL Connector/Net is an all-managed ADO.Net provider for MySQL. While this release is suitable for any version of MySQL, it is strongly encouraged that this release not be used on any production data.

    ReplyDelete
  5. greece yacht charterFebruary 15, 2009 at 6:58 AM

    MySQL Connector/Net 5.0.2 Beta has been released. MySQL Connector/Net is an
    all-managed ADO.Net provider for MySQL. While this release is suitable for
    any version of MySQL, it is strongly encouraged that this release not be
    used on any production data.

    ReplyDelete
  6. MySQL Connector/J is a native Java driver that converts JDBC (Java Database Connectivity) calls into the network protocol used by the MySQL database. It lets developers working with the Java programming language easily build programs and applets that interact with MySQL and connect all corporate data, even in a heterogeneous environment. MySQL Connector/J is a Type IV JDBC driver and has a complete JDBC feature set that supports the capabilities of MySQL.

    ReplyDelete
  7. On the MySQL site navigate through to Drivers/Downloads and you will find a choice of connector depending on the version of NET you are using. If you are using NET Framework 1.1 then you should download Connector/Net 1.0 (latest stable version 1.07). On the other hand if you are using NET framework 2.0 then there doesn't seem anything to lose by downloading Connector/Net 5.1 (latest stable version 5.1.5). It appears Connector/Net 5.0 is being replaced as the MySQL Server 5.1 version becomes the main release.

    ReplyDelete
  8. While this release is suitable for
    any version of MySQL, it is strongly encouraged that this release not be
    used on any production data.

    ReplyDelete
  9. such a nice thinking
    thank u all for the nice, lovely thinking

    ReplyDelete
  10. love u all
    thank u for nice thinking

    ReplyDelete
  11. Hatton Vs Pacquiao liveMay 1, 2009 at 8:49 AM

    It is nice to be released because this program runs as a server providing multi-user access to a number of databases.

    ReplyDelete
  12. gagner de l'argentMay 4, 2009 at 5:43 PM

    so great to see that ! thansk for sharing it ! very useful !

    ReplyDelete
  13. It is nice to be released because this program runs as a server providing multi-user access....

    ReplyDelete
  14. # Bug #22882 Registry key 'Global' access denied
    # Bug #18186 Problem with implementation of PreparedStatement

    ReplyDelete
  15. Thank you for all that information very useful!

    ReplyDelete
  16. thank you all for the nice !
    Lovely thinking

    ReplyDelete
  17. Tried to autotranslate you site not understand the writing any hope deutsch version?

    ReplyDelete
  18. I like your blog curently we are looking for a part time article writer would you be interested?

    ReplyDelete
  19. Great writeup.. I guess you summed it all up.. Cheers

    ReplyDelete
  20. Good post, I will mention it on my blog.. Cheers

    ReplyDelete