Changes in MySQL Connector/NET 8.0.31 (2022-10-11, General Availability)

• Deprecation and Removal Notes

• Functionality Added or Changed

• Bugs Fixed

Deprecation and Removal Notes

• The EMTrace extension is removed. The EMTrace project implements a trace-listener plugin that feeds data back to MySQL Enterprise Monitor using a REST server endpoint. (WL #15158)

• The MySql.Data.MySqlClient.Memcached namespace and its members now are removed. An alternative binary or text client is recommended for applications that access data using the InnoDB memcached plugin. (WL #15213)

Functionality Added or Changed

• Connector/NET now provides DNS Service (SRV) records support without depending on libraries that were previously omitted from the Connector/NET 8.0.19 (and later) NuGet packages. This update does not change how the DNS-SRV feature looks up, extracts the SRV records, or uses those records to establish a connection (see Opening a Connection Using a Single DNS Domain). (WL #14016)

• Connector/NET now supports .NET 7 (preview) and continues to support a range of frameworks (see Connector/NET Versions). (WL #15195)

• Connector/NET now fully supports EF Core 7.0 (preview) for applications that target .NET 7 exclusively. Applications that target .NET Framework (or any .NET Standard version) cannot use this feature. (WL #15194)

Bugs Fixed

• One of the links published for submitting a pull request was not well-formed. Our thanks to Adam Croot for the patch. (Bug #108290, Bug #34535732)

• NuGet was not able to display license information for Connector/NET packages accurately. Our thanks to Matthew Steeples for the patch. (Bug #108091, Bug #34477295)

• On systems running .NET 6, Connector/NET could throw an exception when trying to perform an equality check involving type Datetime.Date. (Bug #107618, Bug #34317220)

• After a connection timeout expired, exception type TimeoutException was thrown when MySqlException was expected. (Bug #107600, Bug #34299402)

• Incomplete dependencies prevented Connector/NET from installing and running properly. (Bug #107316, Bug #34189859)

• If an exception occurred during the execution of a SQL statement within a transaction, the subsequent transaction rollback produced a null reference exception, which could cause the Web server (IIS) process to halt unexpectedly. This fix changes the way the connection object manages rollback behavior. (Bug #107110, Bug #34107186)

• The overall performance of the MySql.Data.MySqlClient.MySqlParameterCollection.Add(Object) method was improved by changing the return statement. (Bug #105997, Bug #33710643)

• When a query attribute and a command parameter had the exact same name, Connector/NET overwrote the value of the attribute with the value from the parameter, which then prevented using mysql_query_attribute_string to retrieve an accurate value for the attribute. Connector/NET now removes all parameter names when sending a prepared statement. (Bug #105728, Bug #33620022)

• Additional validation now checks the MySqlParameter value assignment to ensure that binary data in a MemoryStream object can be read properly. (Bug #102593, Bug #32506736)

• An error was emitted after passing in MySqlParameter.MySqlDbType set with type MySqlDbType.Int24 to command.ExecuteNonQuery() using a prepared statement. (Bug #95986, Bug #29959095)