NBearLite_PetShop

Connector/Net 5.1.2 Release Notes ------------------------------------ Welcome to the release notes for Connector/Net 5.1.2 Binary and VarBinary issues --------------------------- With 5.1.2, we have reintroduced code to properly return field values as byte[] when the field's type is indicated to be binary by the server. Unfortunately, there are some scenarios where the connector simply can't tell which is right. One example is the 'SHOW PROCESSLIST' query. The fields returned from this query contain text data but are incorrectly returned using the binary character set. This means that these fields will be returned as byte[]. They can stil be retrieved as strings using MySqlDataReader.GetString(). Please let us know how this issue affects you. We are evaluating adding a connection option to make the past behavior available. Known Issues ------------ 1. Creating a procedure with the name StoredProcedure1 will cause any future attempts to create a stored procedure to fail. Connector/Net 5.1.1 Release Notes ------------------------------------ Welcome to the release notes for Connector/Net 5.1.1 This release fixes some installer issues that were reported with 5.1.0 alpha. - MySQL Connector/Net 5.0.4 MySQL AB's ADO.Net Driver for MySQL Copyright (c) 2004-2006 MySQL AB CONTENTS * License * Documentation Location LICENSE MySQL Connector/Net is licensed under the GPL or a commercial license from MySQL AB. If you have licensed this product under the GPL, please see the COPYING file for more information. If you have licensed this product under a commercial license from MySQL AB, please see the file "MySQLEULA.txt" that comes with this distribution for the terms of the license. If you need non-GPL licenses for commercial distribution please contact me <reggie@mysql.com> or <sales@mysql.com>. DOCUMENTATION LOCATION The documentation currently exists in MSDN help format and is located in the 'doc' directory. -- This software is OSI Certified Open Source Software. OSI Certified is a certification mark of the Open Source Initiative. Connector/Net 5.0.5 Release Notes ------------------------------------ Welcome to the release notes for Connector/Net 5.0.5. Important Changes --------------------- * We've added support for MySqlParameterCollection.AddWithValue. This method should be used whenever you are wanting to add a parameter by name and set its value in a single method call. The previous .Add overload is marked as deprecated and will give a compiler warning if you continue to use it. * This release includes support for calling stored procedures without having privileges on the mysql.proc table. This is accomplished by adding 'Use Procedure Bodies=false' to your connection string. The default is true (which means by default you still need access to mysql.proc). Since MySQL does not yet support an information schema parameters view, the connector has to trust the order of parameters that you set on the command. So, to call a procedure using a limited privilege account, set 'Use Procedure Bodies=false' on your connection string, add parameters to your command object in the exact same order they appear in the procedure definition, and make sure all the parameters have their type set. * With 5.0.3, we required that all parameters start with the parameter marker (default is ?). This was not fully thought out and has been rolled out in this release. With this release, you can add parameters with or without the leading parameter marker. One thing to understand though is that the IndexOf method of MySqlParameterCollection is still sensitive to the name. What this means is that if you add a parameter with the name '?parm1' and then call IndexOf with the value 'parm1', it will return -1. * Connecion pooling has been significantly changed in this release. Now, a semaphore is used to control access to the pool. This significantly reduces CPU time incurred while waiting on a connection to free and greatly simplifies the locking code involved. * MySqlCommandBuilder now includes a new property named ReturnGeneratedIdentifiers. This property when set to true will cause the command builder to generate a SELECT statement that will populate autogenerated fields.