Functionality added or changed:
Reverted behavior that required parameter names to start with the parameter marker. We apologize for this back and forth but we mistakenly changed the behavior to not match what
SqlClientsupports. We now support using either syntax for adding parameters however we also respond exactly likeSqlClientin that if you ask for the index of a parameter using a syntax different from when you added the parameter, the result will be -1.Assembly now properly appears in the Visual Studio 2005 Add/Remove Reference dialog.
Fixed problem that prevented use of
SchemaOnlyorSingleRowcommand behaviors with stored procedures or prepared statements.Added
MySqlParameterCollection.AddWithValueand marked theAdd(name, value)method as obsolete.Return parameters created with DeriveParameters now have the name
RETURN_VALUE.Fixed problem with parameter name hashing where the hashes were not getting updated when parameters were removed from the collection.
Fixed problem with calling stored functions when a return parameter was not given.
Added
Use Procedure Bodiesconnection string option to enable calling procedures without using procedure metadata.
Bugs fixed:
MySqlConnection.GetSchemafails withNullReferenceExceptionfor Foreign Keys. (Bug#26660)MySQL Connector/NET would fail to install under Windows Vista. (Bug#26430)
Opening a connection would be slow due to host name lookup. (Bug#26152)
Incorrect values/formats would be applied when the
OldSyntaxconnection string option was used. (Bug#25950)Registry would be incorrectly populated with installation locations. (Bug#25928)
Times with negative values would be returned incorrectly. (Bug#25912)
Returned data types of a
DataTypescollection do not contain the right correct CLR data type. (Bug#25907)GetSchemaandDataTypeswould throw an exception due to an incorrect table name. (Bug#25906)MySqlConnectionthrows an exception when connecting to MySQL v4.1.7. (Bug#25726)SELECTdid not work correctly when using aWHEREclause containing a UTF-8 string. (Bug#25651)When closing and then re-opening a connection to a database, the character set specification is lost. (Bug#25614)
Filling a table schema through a stored procedure triggers a runtime error. (Bug#25609)
BINARYandVARBINARYcolumns would be returned as a string, not binary, data type. (Bug#25605)A critical
ConnectionPoolerror would result in repeatedSystem.NullReferenceException. (Bug#25603)The
UpdateRowSource.FirstReturnedRecordmethod does not work. (Bug#25569)When connecting to a MySQL Server earlier than version 4.1, the connection would hang when reading data. (Bug#25458)
Using
ExecuteScalar()with more than one query, where one query fails, will hang the connection. (Bug#25443)When a
MySqlConversionExceptionis raised on a remote object, the client application would receive aSerializationExceptioninstead. (Bug#24957)When connecting to a server, the return code from the connection could be zero, even though the host name was incorrect. (Bug#24802)
High CPU utilization would be experienced when there is no idle connection waiting when using pooled connections through
MySqlPool.GetConnection. (Bug#24373)MySQL Connector/NET would not compile properly when used with Mono 1.2. (Bug#24263)
Applications would crash when calling with
CommandTypeset toStoredProcedure.