• Implement CommandBehavior.SchemaOnly: #723.
• Fix MySqlDataReader methods returning data for output parameters of stored procedures: #722.
  • This fixes a regression introduced in 0.57.0.

• Possibly breaking Implement conversions in GetFieldValue: #716.
• Add C# 8 nullable annotations to public API.
• Support Tables and Views schemas in MySqlConnection.GetSchema: #719.
• Add better exception message when '0000-00-00' can't be converted: #690.
• Implement MySqlConnection.Clone: #720.
• Update list of reserved words.
• Use new Socket async APIs (.NET Standard 2.1, .NET Core 3.0).
• Update System.Net.Security dependency to v4.3.1 (.NET Standard 1.3).
• Thanks to @Marusyk 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

• Breaking MySqlDataReader.GetFloat() converts REAL values (from double to float) instead of throwing InvalidCastException: #706.
• Fix error in mysql_clear_password authentication plugin: #703.
• 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

• 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

• Set MySqlException.Number to MySqlErrorCode.UnableToConnectToHost in more situations when connecting times out: #622.
• Improve handling of MySqlConnection.Close() within TransactionScope: #620.
• Allow MySqlParameter.Value to be a ReadOnlyMemory<byte>: #624.
• Thanks to @mguinness for contributions to this release.

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

• Breaking The default value for the UseAffectedRows connection string option has changed from true to false. This provides better compatibility with Connector/NET's defaults and also with other ADO.NET libraries: #600.
  • If you are upgrading from an earlier version of MySqlConnector, either audit your uses of the return value of ExecuteNonQuery (it will now return the number of rows matched by the WHERE clause for UPDATE statements, instead of the number of rows whose values are actually changed), or add UseAffectedRows=true to your connection string.
  • If you are migrating (or have recently migrated) from Connector/NET to MySqlConnector, then no changes need to be made: MySqlConnector now exhibits the same default behaviour as Connector/NET.
• Make MySqlException serializable: #601.
• Set MySqlException.Number to MySqlErrorCode.UnableToConnectToHost when connecting fails: #599.
• Populate MySqlException.Data dictionary: #602.

Download on NuGet

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