2.5.0-beta.1

2.5.0 Beta 1

• Support .NET 10: #1595.
• Possibly breaking MySqlConnection.State will be set to ConnectionState.Broken when there is a network error: #1599.
  • Previously it would have been set to ConnectionState.Closed but the connection wasn't truly closed.
  • Call MySqlConnection.Close() to fully close the connection before calling Open() again.
  • Better yet, call .Dispose() (ideally with a using declaration) and create a new MySqlConnection instance to recover from failure.
• Possibly breaking MySqlConnection.ResetConnectionAsync will consistently throw a MySqlException: #1602.
• Implement MariaDB PARSEC authentication: #1540.
• Support the VECTOR data type: #1549.
• Implement COM_STMT_SEND_LONG_DATA to stream large parameter values: #943.
• Add MySqlConnectorTracingOptions and builder APIs to configure tracing output: #1524.
• Read Guid values from stored procedure out parameters: #1528.
• Mark MySqlDbType with [DbProviderSpecificTypeProperty(true)]: #1557.
• Allow loopback connections (e.g., Google Cloud SQL Proxy) to use clear-text password or public key retrieval: #1534, #1542.
• Improve schema metadata with MariaDB by reading stored procedure metadata from mysql.proc: #1547.
• Improve XA transaction rollback handling: #1585, #1589.
• Free large cached payload buffers when returning sessions to the pool to reduce memory usage: #1587.
• Suppress error-level logging when a command is canceled: #1544.
• Fix MySqlBulkCopy auto-detected column mappings: #1568.
• Fix Foreign Keys schema SQL syntax: #1601.
• Fix extra roundtrip for caching_sha2_password: #1562.
• Fix cancellation with AWS RDS Proxy: #1581.
• Optimization: Use System.Threading.Lock for .NET 9.0+.
• Optimization: Use PemEncoding in .NET 5.0+ and UTF-8 methods in .NET 10.0+.
• Thanks to @djeman, @jnoordsij, @NETSphereSoft, @PatrickMNL, @petedishman, and @rusher for contributions to this release.

2.4.0

• Support .NET 9.0.
• Possibly breaking Mark MySqlConnectorLogManager.Provider as [Obsolete]: #1397.
• Possibly breaking Remove end-of-life .NET 7 target framework.
  • Users who wish to use DbDataSource need to target .NET 8.0 or later.
• Possibly breaking Update dependencies:
  • Microsoft.Extensions.Logging.Abstractions from 7.0.1 to 8.0.2.
  • System.Diagnostics.DiagnosticSource from 7.0.2 to 8.0.1.
• Support trimming and native AOT: #1265.
• Add MySqlDataSourceBuilder.UseConnectionOpenedCallback: #1508.
• Add MySqlDbColumn.TableName: #1521.
• Support zero-configuration SSL with MariaDB: #1500.
• Support SET data type in functions: #1491.
• Remove TABLESPACES schema: #1477.
• Rewrite server redirection logic based on latest MariaDB specification: #1499.
• Change variable name for better server compatibility: #1502.
• Performance: Avoid SET NAMES commands when not necessary: #1497.
• Fix "Can't replace active reader": #1469.
• Fix potential NullReferenceException in MySqlConnection.Cancel: #1506.
• Fix InvalidOperationException in FinishQuerying: #1341.
• Provide logger to new MySqlConnection: #1510.
• Use correct hostname when cancelling query: #1514.
• Thanks to @AlexKerman and @rusher for contributions to this release.

2.4.0 Beta 2

• Remove end-of-life .NET 7 target framework.
  • Users who wish to use DbDataSource need to target .NET 8.0 or later.
• Fix "Can't replace active reader": #1469.
• Update dependencies:
  • Microsoft.Extensions.Logging.Abstractions from 7.0.1 to 8.0.2.
  • System.Diagnostics.DiagnosticSource from 7.0.2 to 8.0.1.

2.4.0 Beta 1

• Support .NET 9.0.
• Support zero-configuration SSL with MariaDB: #1500.
• Add MySqlDataSourceBuilder.UseConnectionOpenedCallback: #1508.
• Rewrite server redirection logic based on latest MariaDB specification: #1499.
• Support SET data type in functions: #1491.
• Performance: Avoid SET NAMES commands when not necessary: #1497.
• Fix potential NullReferenceException in MySqlConnection.Cancel: #1506.
• Provide logger to new MySqlConnection: #1510.
• Use correct hostname when cancelling query: #1514.
• Remove TABLESPACES schema: #1477.
• Change variable name for better server compatibility: #1502.
• Thanks to @rusher for contributions to this release.

2.3.7

• Fix NullReferenceException in MySqlDataReader.ActivateResultSet and MySqlDataReader.DisposeAsync: #1459.
  • This bug likely also caused "Packet received out-of-order" errors.
  • This was introduced in 2.3.0.
• Fix rare NullReferenceException in ServerSession during cancellation: #1472.
• Fix Foreign Keys schema not being generated asynchronously.

2.3.6

• Fix VerifyCA incompatibility with AWS Aurora: #1462.
• Verify that the server's root certificate is present (in the list of provided CA certificates) when using the SslCa connection string option and SslMode is VerifyCA or VerifyFull.
• Optimization: Use pipelining to begin a transaction: #1286.
  • Use Pipelining = False; in your connection string to disable this optimization if there are compatibility issues.
• Optimization: cache START TRANSACTION payloads.
• Add transaction logging: #1411.
• Fix incompatibility with MySQL Server 5.1: #1445.
  • This fixes a regression introduced in 2.3.0.
• Thanks to @CRC32EX, @dlenski, and @rbanks54 for documentation contributions in this release.

2.3.5

• DLL files within the NuGet packages are now digitally signed.
• Thanks to Devolutions for sponsoring this change.

2.3.4

• Unify Application Name connection string option and MySqlDataSourceBuilder.UseName: #1434.
• Remove TLS version fallback code: #1409.
• Fix ArgumentOutOfRangeException in TimerQueue.Add: #1424.
• Fix InvalidCastException when using stored procedures with MySQL 5.0: #1431.
• Fix hang when disposing MySqlDataSource twice on .NET Framework.
• Thanks to @SolacomYongYao for contributions to this release.

2.3.3

• Support COLUMN_NAME restriction for IndexColumns schema; this improves NHibernate compatibility.

2.3.2

• Add Foreign Keys, Indexes, Index Columns schemas: #1419.
• Fix exception when server doesn't send expected metadata: #1398.
• Clear activity tags when retrying TLS: #1405.
• Use underlying enum type when writing binary parameters: #1421.
• Avoid retrying TLS negotiation when a non-recoverable exception occurs.
• Thanks to @daebo01, @eaexo, and @trejjam for contributions to this release.