Functionality added or changed:
Performing
GetValue()
on a fieldTINYINT(1)
returned aBOOLEAN
. While not a bug, this caused problems in software that expected anINT
to be returned. A new connection string optionTreat Tiny As Boolean
has been added with a default value oftrue
. If set tofalse
the provider will treatTINYINT(1)
asINT
. (Bug#34052)Added support for
DbDataAdapter
UpdateBatchSize
. Batching is fully supported including collapsing inserts down into the multi-value form if possible.DDEX provider now works under Visual Studio 2008 beta 2.
Added ClearPool and ClearAllPools features.
Bugs fixed:
Some speed improvements have been implemented in the
TokenizeSql
process used to identify elements of SQL statements. (Bug#34220)When accessing tables from different databases within the same
TransactionScope
, the same user/password combination would be used for each database connection. MySQL Connector/NET does not handle multiple connections within the same transaction scope. An error is now returned if you attempt this process, instead of using the incorrect authorization information. (Bug#34204)The status of connections reported through the state change handler was not being updated correctly. (Bug#34082)
Incorporated some connection string cache optimizations sent to us by Maxim Mass. (Bug#34000)
In an open connection where the server had disconnected unexpectedly, the status information of the connection would not be updated properly. (Bug#33909)
Data cached from the connection string could return invalid information because the internal routines were not using case-sensitive semantics. This lead to updated connection string options not being recognized if they were of a different case than the existing cached values. (Bug#31433)
Column name metadata was not using the character set as deifned within the connection string being used. (Bug#31185)
Memory usage could increase and decrease significantly when updating or inserting a large number of rows. (Bug#31090)
Commands executed from within the state change handeler would fail with a
NULL
exception. (Bug#30964)When running a stored procedure multiple times on the same connection, the memory usage could increase indefinitely. (Bug#30116)
Using compression in the MySQL connection with MySQL Connector/NET would be slower than using native (uncompressed) communication. (Bug#27865)
The
MySqlDbType.Datetime
has been replaced withMySqlDbType.DateTime
. The old format has been obsoleted. (Bug#26344)