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.

0.59.0

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.

0.58.0

Download on NuGet

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

0.57.0

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.

0.56.0

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.

0.55.0

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.

0.54.0

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.

0.53.0

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.

0.52.0

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.

0.51.1

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.