2.0.0

[bgrainger]

• Target .NET 6.0.
  • Breaking Update the MySqlBatch (experimental API) to match .NET 6.0 API changes.
  • Support DateOnly and TimeOnly structs: Support the new BCL DateOnly and TimeOnly structs #963.
  • Use ZLibStream for compression: Use ZLibStream for compression #957.
  • Use X_OR_GREATER preprocessor definitions: Use new OR_GREATER preprocessor symbols for version checks #958.
• Breaking Improve MySqlBulkCopy API: Improve MySqlBulkCopy API #1012.
• Breaking Remove ConnectionIdlePingTime: Don't ping when Connection Reset = false  #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). This improves performance but may degrade reliability. (Connection Reset = True, which is the default, is still recommended for greatest reliability.)
  • 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.
• 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: Remove netstandard1.3 support #1031, Remove netcoreapp2.1 support #1067.
• Add ActivitySource for tracing: Add ActivitySource #1036.
• Reduce default log message severity: Reduce log message severity #981.
• Add MySqlConnection.ProvideClientCertificatesCallback, MySqlConnection.ProvidePasswordCallback, MySqlConnection.RemoteCertificateValidationCallback: RDS/Aurora IAM Database Authentication and Connection Pooling #800, [New Feature] Passing Certificate in X509Certificate/X509Certificate2 format rather than physical paths #976.
• Support BigInteger as parameter value: Support BigInteger parameter #1069.
• Add more values to MySqlErrorCode: Add additional MySQL error codes #1048.
• Make MySqlError.Code obsolete: Replace MySqlError.Code with ErrorCode #1011.
  • Use ErrorCode property instead.
• Remove BackgroundConnectionResetHelper: Remove BackgroundConnectionResetHelper (used by DeferConnectionReset=false) #1013.
  • MySqlConnectionStringBuilder.DeferConnectionReset is obsolete and will always be treated as if it's true.
• Add NuGet package READMEs: Add package README to all packages #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: Better exception if DELIMITER is used #1010.
• Fix MySqlConnectionStringBuilder.TryGetValue: MySqlConnectionStringBuilder does not implement ICustomTypeDescriptor correctly #1030.
• Fix incorrect value for MySqlCommand.LastInsertedId when executing multiple commands: MySqlCommand.LastInsertedId #1026.
• Fix bug executing stored procedures with backticks in their names: Procedure name is not escaped when using CommandType.StoredProcedure #1029.
• Fix rare ObjectDisposedException that could be thrown when a connection timeout occurred.

---

This discussion was created from the release 2.0.0.