• Improve detection of Azure Database for MySQL proxy: #731.
• Implement CommandBehavior.SingleResult and SingleRow: #681.
• Improve "Connect Timeout" exception message when connection pool is empty.
• Revalidate missing stored procedures in MySqlCommandBuilder.DeriveParameters(Async): #730.

• Add more schemas to MySqlConnection.GetSchema: #724.
• Add XML documentation to NuGet package.
• Add documentation for MySqlConnection.ConnectionTimeout: #727.
• Fix exception in MySqlDataReader.FieldCount and HasRows: #728.
  • This fixes a regression introduced in 0.60.1.
• Thanks to @JosephAmalfitanoSSA and @KaliVi for contributions to this release.

Download on NuGet

• Fix error when reading a BIT(1) column: #713.
  • This fixes a problem introduced in 0.59.1.

Download on NuGet

• Allow DECIMAL column type to be read by GetBoolean: #707.
• Fix error in reading BIT(n) columns: #708.
• Thanks to @lauxjpn for contributions to this release.

Download on NuGet

• Add NoBackslashEscapes connection option: #701.
• Store icon in the NuGet package: #705.`
• Thanks to @lauxjpn for contributions to this release.

Download on NuGet

• Breaking Remove MySqlClientFactory.Register: #654
  • Replace calls to this method with DbProviderFactories.RegisterFactory("MySqlConnector", MySqlClientFactory.Instance) instead.
• Breaking Return type of MySqlConnection.BeginTransactionAsync changed to ValueTask<MySqlTransaction> (to match .NET Core 3.0 APIs).
• Breaking Various XyzAsync method overloads that did not take a CancellationToken were removed.
• Breaking Throw InvalidOperationException from MySqlDataReader.GetSchemaTable when there is no result set: #678.
• Experimental Implement the new ADO.NET DbBatch API: #650.
  • This API is not finalised and may change in the future.
• Add netstandard2.1 and netcoreapp3.0 platforms.
• Implement .NET Core 3.0 ADO.NET API.
• Add .NET Core 3.0 async methods: #642.
• Allow MySqlDataReader.GetDouble and GetFloat on DECIMAL columns: #664.
• Allow narrowing conversions in MySqlDataReader.GetByte: #695.
• Add MySqlGeometry and MySqlDataReader.GetMySqlGeometry: #677.
  • The API is deliberately different than Connector/NET, which assumes a MySqlGeometry can only be a simple point.
• Use sql_select_limit when CommandBehavior.SingleRow is specified: #679.
• Use batching in MySqlDataAdapter when UpdateBatchSize is set: #675.
• Support utf8mb4_0900_bin collation introduced in MySQL Server 8.0.17: #670.
• Add MySqlConnection.CloseAsync: #467.
• Throw InvalidOperationException from MySqlConnection.EnlistTransaction instead of NullReferenceException.
• Fix NullReferenceException thrown from MySqlConnection.ConnectionTimeout: #669.
• Fix connection timeout when executing a stored procedure: #672.
• Fix incorrect exception being thrown after a timeout occurs executing a stored procedure: #667.
• Fix exception deserializing an OUT BOOL parameter from a stored procedure: #682.
• Fix exception deserializing an OUT TIME parameter from a stored procedure: #680.
• Fix MySqlConnection.State not being set to ConnectionState.Closed when a failure occurs if pooling is disabled: #674.
• Fix exception when executing a prepared statement if MySqlParameter.MySqlDbType was set: #659.
• Handle error packet being sent out-of-order: #662.
• Use MySqlErrorCode.UnableToConnectToHost in more situations when connecting fails: #647.
• Add some nullable annotations; these are primarily on internal types and not in the public API.
• Reduce allocations on some common code paths.
• Improve performance of MySqlDataReader; reduce memory allocations.
• Thanks to @joshdrees for contributions to this release.

Download on NuGet

• Support client_ed25519 authentication plugin for MariaDB: #639.
  • This is implemented in a new NuGet package, MySqlConnector.Authentication.Ed25519, and must be activated by calling Ed25519AuthenticationPlugin.Install.

Download on NuGet

• Support client_ed25519 authentication plugin for MariaDB: #639.
  • This is implemented in a new NuGet package, MySqlConnector.Authentication.Ed25519, and must be activated by calling Ed25519AuthenticationPlugin.Install.

Download on NuGet

• Breaking MySqlBulkLoader (for local files) and LOAD DATA LOCAL INFILE are disabled by default.
  • Set AllowLoadLocalInfile=true in the connection string to enable loading local data.
  • This is a security measure; see https://fl.vu/mysql-load-data for details.
• Add AllowLoadLocalInfile connection string option: #643.
• Add SslCert and SslKey connection string options to specify a client certificate using PEM files: #641.
• Add SslCa alias for the CACertificateFile connection string option: #640.

Download on NuGet

• Implement batch updates in MySqlDataAdapter: #635.
  • See Performing Batch Operations Using DataAdapters for information about the API.
• Improve compatibility with latest Azure Database for MySQL changes.

Download on NuGet

• Breaking MySqlDataReader.GetTextReader() will throw an InvalidCastException if the field value is NULL. Previously, it would return a StringReader wrapping an empty string.
• Add MySqlDataReader.GetTextReader(string name).
• Implement MySqlDataReader.GetFieldValue<T> and GetFieldValueAsync<T> for TextReader and Stream: #631.

Download on NuGet

• Potentially breaking Change default connection collation from utf8mb4_general_ci to the server's default for utf8mb4: #626.
  • This updates a change made in 0.48.0.
• Fix "Command timeout" exception being thrown when there wasn't a command timeout: #628.

Download on NuGet

• Add support for Memory<byte> and ArraySegment<byte> as MySqlParameter.Value values.
• Fix exception when setting MySqlParameter.Value to ReadOnlyMemory<byte> when using prepared commands.

Download on NuGet

• Add MySqlClientFactory.Register() for integration with DbProviderFactories in netcoreapp2.1: #526.
• Use more efficient "Reset Connection" for MariaDB 10.2.4 and later: #613.
• Ignore MySqlConnection.EnlistTransaction called more than once for the same transaction: #619.
• MySqlConnection.ConnectionString will always be coerced from null to the empty string.
• Use ReadOnlySpan<byte> in more places when parsing server responses.
• Fix multiple NullReferenceException errors that could occur in edge cases.

Download on NuGet

• Use correct isolation level when starting a transaction for System.Transactions.TransactionScope: #605.

Download on NuGet

• Fix bug in parsing OK packet when CLIENT_SESSION_TRACK isn't supported: #603.

Download on NuGet

• Fix InvalidCastException in MySqlDataReader.GetDateTime when AllowZeroDateTime=True: #597.

Download on NuGet

• Add net471 as target platform: #595.
• Support IDbColumnSchemaGenerator interface in netcoreapp2.1 package.
• Fix error in binding parameter values for prepared statements.
• Fix exception when using more than 32,767 parameters in a prepared statement.

Download on NuGet

• Breaking Disallow duplicate parameter names after normalization: #591.
• Potentially breaking Change default connection collation from utf8mb4_bin to utf8mb4_general_ci: #585.
• Potentially breaking Update stored procedure metadata cache to use mysql.proc when available: #569.
  • This provides higher performance, but is a potentially-breaking change for any client using stored procedures.
• Change System.Transactions support:
  • Add UseXaTransactions connection string option to opt out of XA transactions (equivalent to Connector/NET behaviour): #254.
  • Potentially breaking Opening multiple (distinct) MySqlConnection objects within the same transaction will reuse the same server session: #546.
• Add MySqlConnection.InfoMessage event: #594.
• Implement ICloneable on MySqlCommand: #583.
• Fix logic for detecting variable names in SQL: #195, #589.
• Fix NullReferenceException when attempting to invoke a non-existent stored procedure.
• Support MySQL Server 5.1 (and earlier) by using utf8 if utf8mb4 isn't available.
• Reduce log message severity for session discarded due to ConnectionLifeTime: #586.
• Optimise MySqlDataReader.GetStream: #592.
• Use latest dotnet SourceLink package.

Download on NuGet

• Fix NullReferenceException in GetSchemaTable: #580.
• Return correct schema table for second result set: #581.

Download on NuGet

• Support MariaDB GSSAPI authentication: #577.
• Log received error payloads at Debug level.
• Thanks to @vaintroub for contributions to this release.

Download on NuGet

• Fix missing InnerException on MySqlConnection created for a timeout: #575.

Download on NuGet

• Add first version of prepared commands: #534.
  • Only single statements (and not stored procedures) are preparable.
  • The (new) IgnorePrepare connection string option defaults to true and must be set to false to use prepared commands.
• Add CertificateStore and CertificateThumbprint connection string options: #536.
• Fix bug that rejected sessions from the connection pool if ChangeDatabase had been called: #515.
• Don't map TINYINT(1) UNSIGNED as bool: #530.
• Thanks to @hajekj for contributions to this release.

Download on NuGet

• Fix bug (introduced in 0.42.2) that caused extremely high memory usage: #528.
• Allow DATE columns with invalid DateTime values to be read as MySqlDateTime: #529.

Download on NuGet

• Fix bug that ignored last result set returned from a stored procedure if it was empty: #524.
• Fix extra memory usage if column definition payloads exceeded original size estimate.

Download on NuGet

• Fix NotImplementedException reading a GEOMETRY column as byte[]: #70.
• Fix negative TIME parsing: #518.
• Fix ArgumentException preparing a SQL statement: #520.

Download on NuGet

• Add AllowZeroDateTime connection string option: #507.
• Add MySqlDateTime type (to allow invalid DateTime values to be represented).

Download on NuGet

• Fix caching_sha2_password authentication for MySQL Server 8.0.11 release: #489.
  • Breaking This authentication plugin can no longer be used with MySQL Server 8.0.4; you must update to the GA release.