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

• Fix CryptographicException when loading a PFX certificate file: #574.

Download on NuGet

• Add MySqlParameter.Clone.
• Implement ICloneable on MySqlParameter: #567.
• Implement MySqlParameterCollection.CopyTo.
• Add logging for cached procedures.
• Thanks to @jrocha for contributions to this release.

Download on NuGet

• Fix error parsing SQL parameters: #563.
• Add documentation for common errors: #565.

Download on NuGet

• Implement MySqlConnection.GetSchema("ReservedWords"): #559.
• Optimisation: Use ReadOnlySpan<byte> when deserialising payloads.
• Thanks to @fedesasso for contributions to this release.

Download on NuGet

• MySqlCommand.Prepare will cache the prepared command until the connection is reset.
• Improve performance of MySqlCommand.Prepare, especially when preparation is unnecessary.
• Lazily allocate MySqlParameterCollection (accessed via MySqlCommand.Parameters) for better performance when command parameters aren't used.
• Use GC.SuppressFinalize to improve performance when various objects (derived from Component) aren't properly disposed.

Download on NuGet

• Add Application Name connection string setting: #547.
• Clear connection pools on exit: #545.
• Allow ConnectionString to be set on a closed connection: #543.
• Fix intermittent NotSupportedException with SSL connections under .NET Core 2.1: #509.

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

• Add GuidFormat connection string option (for better compatibility with MySQL 8.0 UUID_TO_BIN): #497.
• Add InteractiveSession connection string option: #510.
• Add PipeName connection string option: #454.
• Improve performance by using ReadOnlySpan<byte>, Utf8Formatter, and Utf8Parser: #426.
• Add netcoreapp2.1 package.
• Remove unnecessary dependencies from netstandard2.0 package.
• Fix error in loading multiple certificates on macOS.
• Fix bug in setting MySqlParameter.Precision and Scale under netstandard1.3.
• Thanks to @ejball for contributions to this release.

• Allow CACertificateFile to contain multiple (concatenated) certificates: #499.
• Avoid IndexOutOfRangeException in ValidateRemoteCertificate: #498.

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.

Download on NuGet

• Reverted ConnectionReset=true optimisation (added in 0.40.0) that was incompatible with Aurora: #486.