Changes in MySQL Connector/NET 8.0.33 (2023-04-18, General Availability)

• Deprecation and Removal Notes

• Packaging Notes

• X DevAPI Notes

• Functionality Added or Changed

• Bugs Fixed

Deprecation and Removal Notes

• Data can be passed in and out of a MySQL stored procedure through the MySqlCommand.Parameters collection. When used with a legacy server (prior to MySQL 8.0), the command object consults the mysql.proc table to determine the parameters of the stored procedure. This secondary action now is deprecated and will be removed in a future release. (WL #15645)

Packaging Notes

• .NET Framework 4.6.2 replaces version 4.5.2 in target frameworks. (WL #15641)

• Connector/NET no longer provides within the install and no-install bundles any third-party libraries that the connector does not build internally. Application developers must now ensure the availability of following libraries at run time.

  For applications using OCI Authentication and SSL Certificates validation:

  • Portable.BouncyCastle (see https://www.nuget.org/packages/Portable.BouncyCastle)

  For applications using X DevAPI:

  • K4os.Compression.LZ4.Streams (see https://www.nuget.org/packages/K4os.Compression.LZ4.Streams)

  • Google.Protobuf (see https://www.nuget.org/packages/Google.Protobuf)

  (WL #15682)

X DevAPI Notes

• Class MySqlX.XdevAPI.Collection<T> is expanded to enable the use of generic types with operations performed on a collection. Collection<T> now includes these new methods:

  • Add(Object[]) (replaces the Add(T) method)

  • Count()

  • CreateIndex(String, Object)

  • DropIndex(String)

  • Find(String)

  • GetOne(Object)

  • Modify(String)

  • Remove(String)

  • RemoveOne(Object)

  (Bug #31182148, WL #15476)

Functionality Added or Changed

• The zstd compression algorithm is deactivated in the connector. (Bug #35281610)

• Asynchronous methods used with classic MySQL protocol connections now are implemented to ensure asynchronous behavior at the level of I/O operations. Previously, some asynchronous methods were executed in a synchronous context. (Bug #70111, Bug #26477952, WL #15484)

• Connector/NET’s implementation of the authentication_oci_client plugin now permits using a security-token file to support ephemeral key-pair authentication when integration with an external identity provider is needed for classic MySQL protocol connections. In addition, .NET applications now can set the new OciConfigProfile connection option (see General Options) to specify which profile in the configuration file to use for authentication. (WL #15489)

Bugs Fixed

• Queries using the MySql.Data.MySqlClient.MySqlConnection class did not connect as expected if the connector was installed using the MSI file. This fix now adds System.Threading.Tasks.Extensions and System.CompilerServices.Unsafe DLLs to the MSI file for inclusion into the GAC.

  Important

  This resolution requires Connector/NET 8.0.33.1, which supersedes the Connector/NET 8.0.33 release.

  (Bug #35360846)

• Connector/NET API member documentation was incomplete. (Bug #34975410, Bug #35141281)

• When Connector/NET inserted multiple rows using a single MySqlCommand object, the MySqlCommand.LastInsertedId property returned the ID of the first row that was inserted rather than the last row. (Bug #109683, Bug #34993798)

• A valid query formatted with tabs or new lines could return an invalid syntax error. (Bug #95226, Bug #29722378)