2.0.0

• Target .NET 6.0.
  • Breaking Update the MySqlBatch (experimental API) to match .NET 6.0 API changes.
  • Support DateOnly and TimeOnly structs: #963.
  • Use ZLibStream for compression: #957.
  • Use X_OR_GREATER preprocessor definitions: #958.
• Breaking Improve MySqlBulkCopy API: #1012.
• Breaking Remove ConnectionIdlePingTime: #1042.
  • The Connection Idle Ping Time connection string option is still accepted, but has no effect.
  • If Connection Reset = False, MySqlConnection.Open will return a pooled connection (if one is available) without testing it for liveness (by pinging the server). If the server has closed the pooled connection, MySqlConnection.Open will succeed, but the first operation on that connection will fail. Command execution should be wrapped in a try/catch/retry loop to handle this scenario.
  • Connection Reset = False improves performance but may degrade reliability; Connection Reset = True, which is the default, is still recommended for greatest reliability.
• Breaking Change how option keys are serialized when retrieving the MySqlConnectionStringBuilder.ConnectionString property:
  • For example, User Id is now User ID, DefaultCommandTimeout is now Default Command Timeout, etc.
  • All existing connection strings are still valid, and all the previous aliases for connection string options are still accepted.
  • The primary connection string option key is listed first in the documentation at https://mysqlconnector.net/connection-options/.
• Breaking Seal MySqlCommandBuilder and MySqlConversionException.
• Remove netstandard1.3 and netcoreapp2.1 target frameworks: #1031, #1067.
• Add ActivitySource for tracing: #1036.
• Reduce default log message severity: #981.
• Add MySqlConnection.ProvideClientCertificatesCallback, MySqlConnection.ProvidePasswordCallback, MySqlConnection.RemoteCertificateValidationCallback: #800, #976.
• Support BigInteger as parameter value: #1069.
• Add more values to MySqlErrorCode: #1048.
• Make MySqlError.Code obsolete: #1011.
  • Use ErrorCode property instead.
• Remove BackgroundConnectionResetHelper: #1013.
  • MySqlConnectionStringBuilder.DeferConnectionReset is obsolete and will always be treated as if it's true.
• Add NuGet package READMEs: #1053.
• Add [Category], [DefaultValue], and [Description] attributes to all MySqlConnectionStringBuilder properties.
• Improve performance of Regex usage internally.
• Throw an informative exception if DELIMITER is used in a SQL statement: #1010.
• Fix MySqlConnectionStringBuilder.TryGetValue: #1030.
• Fix incorrect value for MySqlCommand.LastInsertedId when executing multiple commands: #1026.
• Fix bug executing stored procedures with backticks in their names: #1029.
• Fix rare ObjectDisposedException that could be thrown when a connection timeout occurred.