MySqlConnector

• Implement MySqlException.IsTransient: #849.
• Nagle's Algorithm is disabled on TCP sockets: #921.
• Prevent exceptions being thrown from MySqlTransaction.Dispose: #923.
• Fix error deserialising MySqlException.ErrorCode property.

• Connections are now reset asynchronously in the background: #178.
  • This speeds up MySqlConnection.Open(Async) but still cleans up connections between uses.
  • Use DeferConnectionReset=true in the connection string to revert to the old behaviour.
  • Experimental Use ConnectionIdlePingTime=300 in the connection string to avoid any network I/O when retrieving a connection from the pool; this is fastest but may return invalid connections from Open. This setting is experimental and may change in the future.
• Use transaction for SHOW WARNINGS: #918.

• Fix bug in extracting PEM data when there's extra data in the certificate file: #912.
• Thanks to @lauxjpn for contributions to this release.

• Add TlsCipherSuites connection string option for fine-grained control of TLS cipher suites: #904.
  • This option is only supported on Linux when using .NET Core 3.1 or .NET 5.0 or later.
• Fix bug loading GUIDs with MySqlBulkCopy.

• Support .NET 5.0.
• Cancel query (server-side) when CommandTimeout expires: #455.
  • Add CancellationTimeout connection string option.
  • Implementation details discussed in this comment.
• Return null from MySqlDataReader.GetSchemaTable when there is no result set: #877.
• Make DisposeAsync fully async: #876.
• Ignore ObjectDisposedException thrown in TryResetConnectionAsync: #897.
• Ignore closed/disposed connections/commands in MySqlCommand.Cancel: #820.
• Fix bug where sessions could time out if they were opened but no queries were ever executed.
• Thanks to @dlemstra and @laurent-jeancler-realist for contributions to this release.

• Support .NET 5 RC 2
• Cancel query (server-side) when CommandTimeout expires: #455.
  • Implementation details discussed in this comment.
• Return null from MySqlDataReader.GetSchemaTable when there is no result set: #877.
• Make DisposeAsync fully async: #876.
• Ignore ObjectDisposedException thrown in TryResetConnectionAsync: #897.
• Fix bug where sessions could time out if they were opened but no queries were ever executed.
• Thanks to @dlemstra for contributions to this release.

• Ignore ObjectDisposedException thrown in TryResetConnectionAsync: #897.
• Thanks to @laurent-jeancler-realist for contributions to this release.

• Return null from MySqlDataReader.GetSchemaTable when there is no result set: #877.

• Support ENUM columns that use the MYSQL_TYPE_ENUM type in their column metadata: #850.
• Allow MySqlCommand.CommandText and .Connection to be changed while another command is executing: #867.
• Make schema collection names (for MySqlConnection.GetSchema(collectionName)) case-insensitive: #852.
• Fix MySqlBulkLoader with Azure Database for MySQL/MariaDB: #853.
• Fix bug preventing the retrieval of more than 2³¹-1 rows in a single query: #863.
• Fix MySqlParameterCollection.Insert implementation: #869.
• Fix integer overflow in sequence number for compressed packets.
• Fix ZLIB header flags verification for compressed packets.
• Thanks to @akamor for contributions to this release.

• Fix MySqlBulkLoader with Azure Database for MySQL/MariaDB: #853.
• Make schema collection names (for MySqlConnection.GetSchema(collectionName)) case-insensitive: #852.

• Support ENUM columns that use the MYSQL_TYPE_ENUM type in their column metadata: #850.

• Breaking Change namespace to MySqlConnector: #824.
• Breaking Rename MySqlClientFactory to MySqlConnectorFactory: #839.
• Breaking All MySqlConnectionStringBuilder string properties return "" (not null) when unset: #837.
• Breaking Remove MySqlInfoMessageEventArgs.errors property; use .Errors instead.
• Implement async schema APIs: #835.
• Implement MySqlConnectorFactory.CanCreateXyz methods: #838.
• Add net5.0 target framework.
• Add MySqlException.ErrorCode: #830.
• Add MySqlConnection.ResetConnectionAsync: #831.
• Add documentation at https://mysqlconnector.net/api/ built from XML doc comments: #827.
• Allow rows larger than 1 MiB in MySqlBulkCopy: #834.
• Reduce memory allocations when hashing passwords (during login).

• Potentially Breaking Introduce MySqlConnection.GetSchemaAsync overloads to match latest .NET 5 API proposal: #835.
• Support GEOMCOLLECTION data type alias in MySQL Server 8.0: #845.

• Support GEOMCOLLECTION data type alias in MySQL Server 8.0: #845.

• Improve robustness of OK packet parsing: #842.

• Breaking Rename MySqlClientFactory to MySqlConnectorFactory: #839.
• Breaking All MySqlConnectionStringBuilder string properties return "" (not null) when unset: #837.
• Implement MySqlConnectorFactory.CanCreateXyz methods: #838.

Fix connection pool leak when a failure (e.g., timeout) occurs on a connection: #836.

• Fix connection pool leak when a failure (e.g., timeout) occurs on a connection: #836.

• Breaking Remove MySqlInfoMessageEventArgs.errors property; use .Errors instead.
• Implement async schema APIs: #835.
• Allow rows larger than 1 MiB in MySqlBulkCopy: #834.
• Fix Failed to read the result set. error when using MySqlBulkCopy: #780.

• Fix Failed to read the result set. error when using MySqlBulkCopy: #780.
  • The maximum row size supported by MySqlBulkCopyis 1 MiB.