This release fixes bugs since 6.2.0.
MySqlParameterclass now has a property named
PossibleValues. This property is NULL unless the parameter is created by
MySqlCommandBuilder.DeriveParameters. Further, it will be NULL unless the parameter is of type enum or set - in this case it will be a list of strings that are the possible values for the column. This feature is designed as an aid to the developer. (Bug #48586)
Prior to MySQL Connector/Net 6.2,
MySqlCommand.CommandTimeoutincluded user processing time, that is processing time not related to direct use of the connector. Timeout was implemented through a .NET Timer, that triggered after
MySQL Connector/Net 6.2 introduced timeouts that are aligned with how Microsoft handles
SqlCommand.CommandTimeout. This property is the cumulative timeout for all network reads and writes during command execution or processing of the results. A timeout can still occur in the
MySqlReader.Readmethod after the first row is returned, and does not include user processing time, only IO operations.
Further details on this can be found in the relevant Microsoft documentation.
Starting with MySQL Connector/Net 6.2, there is a background job that runs every three minutes and removes connections from pool that have been idle (unused) for more than three minutes. The pool cleanup frees resources on both client and server side. This is because on the client side every connection uses a socket, and on the server side every connection uses a socket and a thread.
Prior to this change, connections were never removed from the pool, and the pool always contained the peak number of open connections. For example, a web application that peaked at 1000 concurrent database connections would consume 1000 threads and 1000 open sockets at the server, without ever freeing up those resources from the connection pool.
MySQL Connector/Net now supports the processing of certificates when connecting to an SSL-enabled MySQL Server. For further information see the connection string option SSL Mode in the section Connector/Net Connection String Options Reference and the tutorial Tutorial: Using SSL with MySQL Connector/Net.
MySqlCommandwas not typesafe. To clone a
MySqlCommandit was necessary to do:
MySqlCommand clone = (MySqlCommand)((ICloneable)comm).Clone();
MySQL Connector/Net was changed so that it was possible to do:
MySqlCommand clone = comm.Clone();
When used, the
Encryptconnection string option caused a “Keyword not supported” exception to be generated.
This option is in fact obsolete, and the option SSL Mode should be used instead. Although the
Encryptoption has been fixed so that it does not generate an exception, it will be removed completely in version 6.4. (Bug #48290)
When building the
MySql.Dataproject with .NET Framework 3.5 installed, the following build output was displayed:
Project file contains ToolsVersion="4.0", which is not supported by this version of MSBuild. Treating the project as if it had ToolsVersion="3.5".
The project had been created using the .NET Framework 4.0, which was beta, instead of using the 3.5 framework. (Bug #48271)
It was not possible to retrieve a value from a MySQL server table, if the value was larger than that supported by the .NET type
MySQL Connector/Net was changed to expose the
MySqlDecimaltype, along with the supporting method
GetMySqlDecimal. (Bug #48100)
An entity model created from a schema containing a table with a column of type
UNSIGNED BIGINTand a view of the table did not behave correctly. When an entity was created and mapped to the view, the column that was of type
UNSIGNED BIGINTwas displayed as
BIGINT. (Bug #47872)
MySQL Connector/Net session support did not work with MySQL Server versions prior to 5.0, as the Session Provider used a call to
TIMESTAMPDIFF, which was not available on servers prior to 5.0. (Bug #47219)