Download on NuGet

• Always use new DateTimeKind setting: #484.

Download on NuGet

• Add DateTimeKind connection string setting: #479.
• Fix ArgumentException for SslProtocols.None: #482.
• Fix IOException being thrown at startup: #475.
• Fix race condition in OpenTcpSocketAsync: #476.
• Optimise MySqlConnection.Open when ConnectionReset=true (default): #483.
• Thanks to @ejball for contributions to this release.

MySqlConnector.Logging.Microsoft.Extensions.Logging

• Reduce dependencies to just Microsoft.Extensions.Logging.Abstractions.

Download on NuGet

• Add IgnoreCommandTransaction connection string setting: #474.

Download on NuGet

• Add Serilog logging provider: #463.
• Add NLog logging provider: #470
• Implement IDbDataParameter on MySqlParameter: #465.
• Implement MySqlDataReader.GetChar: #456.
• Add MySqlDataReader.GetFieldType(string) overload: #440.
• Fix a connection pooling session leak in high contention scenarios: #469.
• Fix overhead of extra connection pools created in a race: #468.
• Thanks to @marcrocny and @snakefoot for contributions to this release.

Download on NuGet

• Serialize enum parameter values as strings when MySqlParameter.MySqlDbType is set to MySqlDbType.String or VarChar: #459.
• Require ConnectionIdlePingTime (added in 0.37.0) to be explicitly set to a non-zero value to avoid pinging the server.
• Thanks to @Naragato for contributions to this release.

Download on NuGet

• Support TLS 1.2 on Windows clients: #458.
  • Use the best TLS version supported by the OS, as per best practices.
• Add ConnectionIdlePingTime connection string setting (Experimental): #461.
• Fix failure to log in for accounts with empty passwords that use caching_sha2_password.
• Throw MySqlException for invalid port number in connection string.

Download on NuGet

• Reap connections more frequently if ConnectionIdleTimeout is low: #442.
• Fix ArgumentOutOfRangeException when command times out: #447.
• Speed up connection pooling (particularly in applications that only have one connection string).
• Reduce heap allocations in common scenarios.

Download on NuGet

• Breaking Require CertificateFile to include private key (for mutual authentication): #436.
• Add MySqlDataReader.GetX(string) overloads: #435.
• Add MySqlDataReader.GetTimeSpan: #438.
• Add MySqlDataReader.GetUInt16, GetUInt32, GetUInt64: #439.
• Set MySqlConnection.State to ConnectionState.Closed when the connection fails: #433.
• Fix error parsing -- comments in SQL: #429.
• Fix error parsing C-style comments in SQL.
• Breaking Wrap unhandled SocketException in MySqlException: #434.

Download on NuGet

• Add MySqlCommandBuilder.DeriveParameters: #419.
• Add MySqlConnection.Ping and MySqlConnection.PingAsync: #260.

Download on NuGet

• Fix exception when a stored procedure returns NULL for an OUT parameter: #425.

Download on NuGet

• Add overloads of MySqlParameterCollection.Add: #424.
• Fix conversion of MySqlCommand.LastInsertedId: #422.
• Fix "Expected state to be Failed but was Connected" InvalidOperationException: #423.
• Improve performance when calling stored procedures with no parameters (this was regressed in 0.34.0).
• Reduce severity of some logging statements.

• Implement MySqlCommandBuilder: #303
• Add Microsoft.Extensions.Logging provider: #418
• Add new MySqlTransaction.Connection property that returns an object typed as MySqlConnection
• Support CLIENT_SESSION_TRACK protocol option: #323
• Optimization: move procedure cache to connection pool: #415
• Ignore extra data at end of column definition payload: #413
• Handle failure to find procedure: #282
• Breaking Clear MySqlTransaction.Connection when transaction is committed: #61
  • This is a breaking API change from Connector/NET, but matches other ADO.NET connectors

• Breaking Throw InvalidCastException instead of MySqlException from MySqlDataReader.GetGuid.
  • This is a breaking API change from Connector/NET, but matches other ADO.NET connectors.
• Fix default values of MySqlParameter.ParameterName and .SourceColumn; they now follow MSDN documentation.
• Fix ObjectDisposedException when a connection is returned to the pool: #411.
• Fix NotSupportedException when MySqlParameter.Value is set to a char: #412.

• Add missing .ConfigureAwait(false)
  • Fixes a potential deadlock in clients that blocked on Tasks returned from async methods.

MySqlConnector

• Implement logging framework: #390.
• Implement MySqlDataAdapter: #183.
• Get correct connection ID for Azure Database for MySQL.
• Use AdoNet.Specification.Tests test suite to validate implementation.

MySqlConnector.Logging.log4net

• Add new project, MySqlConnector.Logging.log4net, that adapts MySqlConnector logging for log4net.

• Implement more MySqlParameter constructor overloads: #402
  • This improves compatibility with Connector/NET
• Implement MySqlParameter.Precision and MySqlParameter.Scale
  • The properties are provided only for source compatibility
  • Not available on .NET 4.5
• Implement MySqlDataReader.GetChars
• Implement MySqlDataReader.Depth
• Fix NullReferenceException in MySqlDataReader when reader is disposed
• Breaking Throw InvalidCastException (instead of MySqlException) from MySqlDataReader.GetGuid if column is NULL
• Breaking Throw InvalidOperationException (instead of MySqlException) from MySqlConnection.ConnectionString setter if connection is open
• Breaking Throw ArgumentException (instead of InvalidOperationException) from MySqlConnectionStringBuilder for invalid option names

• Fix return value of ExecuteScalar to be the first column from the first row of the first result set.
• Fix return value of ExecuteNonQuery to correctly return -1 for SELECT statements.
• Fix bug where NextResult returns true for a trailing comment in a SQL statement.
• Breaking Throw InvalidOperationException if MySqlCommand.CommandText is set while the command is active.
• Breaking Throw InvalidOperationException (instead of MySqlException) if a MySqlCommand is executed while there is an open reader.
• Breaking Throw InvalidOperationException from MySqlCommand.Prepare when preconditions aren't met.

• Breaking Throw InvalidOperationException when MySqlCommand.Connection can't be set (instead of MySqlException).
• Breaking Throw InvalidOperationException from MySqlCommand.Prepare when preconditions aren't met.
• Fix NullReferenceException when MySqlCommand.Connection isn't set (now correctly throws InvalidOperationException).

• Fix InvalidOperationException if MySqlBulkLoader is used inside a transaction (again): #300
• Breaking Remove MySqlBulkLoader.Transaction property (added in 0.24.0); MySqlBulkLoader will always use the ambient transaction, if any. This matches Connector/NET API & behaviour

• Implement MinimumPoolSize: #85
• Implement server load balancing with new LoadBalance connection string setting: #226
• Add SourceLink
• Wrap EndOfStreamException in MySqlException when connecting fails: #388
• Fix StackOverflowException when reading large BLOBs asynchronously
• Don't set Transaction on new MySqlCommand: #389
• Ignore MySqlConnection.Cancel when connection is broken: #386
• Improve internal code organisation: #376