Bot releases are hidden (Show)
-
Breaking Remove
ConnectionIdlePingTime: #1042.- The
Connection Idle Ping Timeconnection string option is still accepted, but has no effect. - If
Connection Reset = False,MySqlConnection.Openwill 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.Openwill 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.
- The
- Add more values to
MySqlErrorCode: #1048. - Fix bug executing stored procedures with backticks in their names: #1029.
- Remove inner exception for
UnableToConnectToHostexception: #1035. - Fix rare
ObjectDisposedExceptionthat could be thrown when a connection timeout occurred. - Reword "recovering leaked sessions" log message.
-
Breaking Remove
netstandard1.3target framework: #1031. -
Breaking Seal
MySqlCommandBuilderandMySqlConversionException. - Fix incorrect value for
MySqlCommand.LastInsertedIdwhen executing multiple commands: #1026. - Add
[Category],[DefaultValue], and[Description]attributes to allMySqlConnectionStringBuilderproperties. - Fix
MySqlConnectionStringBuilder.TryGetValue: #1030. -
Breaking Change how option keys are serialized when retrieving the
MySqlConnectionStringBuilder.ConnectionStringproperty:- For example,
User Idis nowUser ID,DefaultCommandTimeoutis nowDefault 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/.
- For example,
- Support .NET 6.0 Preview 7
-
Breaking Update the
MySqlBatch(experimental API) to match the latest .NET 6.0 API changes.
-
Breaking Update the
- Throw an informative exception if
DELIMITERis used in a SQL statement: #1010. - Fix bug that failed to deserialize a binary row (from a prepared statement) correctly: #1018.
- Reduce default log message severity: #981.
- Make
MySqlError.Codeobsolete: #1011.- Use
ErrorCodeproperty instead.
- Use
- Remove
BackgroundConnectionResetHelper: #1013.-
MySqlConnectionStringBuilder.DeferConnectionResetis obsolete and will always be treated as if it'strue.
-
- Support .NET 6.0 Preview:
- Support
DateOnlyandTimeOnlystructs: #963. - Use
ZLibStreamfor compression: #957. - Use
X_OR_GREATERpreprocessor definitions: #958.
- Support
- Handle
NoBackslashEscapesfor binary parameter values: #999. - Fix
NotSupportedExceptionwhen cancelling aMySqlCommandin aTransactionScope: #1001. - Ignore
InvalidOperationExceptionthrown fromMySqlConnection.Cancel: #1002. - Set the default value of
DeferConnectionResettotrue; this disables background connection reset and restores the pre-1.3 behavior. - Thanks to @kpreisser for contributions to this release.
- Add support for SingleStore: #968.
- Thanks to @carlsverre and @tavanesov-ua for contributions to this release.
- Connections are now reset asynchronously in the background: #178.
- This speeds up
MySqlConnection.Open(Async)but still cleans up connections between uses. - Use
DeferConnectionReset=truein the connection string to revert to the old behaviour. -
Experimental Use
ConnectionIdlePingTime=300in the connection string to avoid any network I/O when retrieving a connection from the pool; this is fastest but may return invalid connections fromOpen. This setting is experimental and may change in the future.
- This speeds up
- Change default value of
IgnorePreparetofalse: #929.- Calling
MySqlCommand.Prepare(Async)will have an effect by default.
- Calling
- Implement Azure Server Redirection: #789.
- Support community protocol for server redirection: #945.
- Support
MemoryStreamas a value forMySqlParameter.Value: #943. - Implement
MySqlException.IsTransient: #849. - Implement
IComparable<MySqlDateTime>andIEquatable<MySqlDateTime>onMySqlDateTime. -
Breaking Remove
publicconstructor forMySqlConversionException.- This constructor was never intended to be
public.
- This constructor was never intended to be
- Implement serialization for exceptions.
- Report
CommandTimeoutExpiredconsistently: #939.- This changes the
MySqlException.ErrorCodefromQueryInterruptedtoCommandTimeoutExpired.
- This changes the
- Nagle's Algorithm is disabled on TCP sockets: #921.
- Adler32 checksum (for compressed packets) uses hardware acceleration: #865.
- Set timeouts for cancellation operations from
CancellationTimeoutconnection string option: #951. - Throw
OperationCanceledExceptionfromOpenAsyncwhen theCancellationTokenis cancelled: #931. - Use transaction for 'SHOW WARNINGS': #918.
- Improve exception message for unsupported parameter types: #925.
- Fix exception in server version parsing: #934.
- Fix silent failure to use TLS 1.3 (when explicitly requested) on older frameworks.
- Fix error deserialising
MySqlException.ErrorCodeproperty. - Prevent exceptions being thrown from
MySqlTransaction.Dispose: #923. - Fix nested
MySqlException(thrown in some scenarios fromExecuteReader). - Use .NET 5.0 methods to load PEM certificates.
- Thanks to @novak-as for contributions to this release.
- Adler32 checksum (for compressed packets) uses hardware acceleration: #865.
- Report
CommandTimeoutExpiredconsistently: #939. -
MySqlException.IsTransientis nowfalseforCommandTimeoutExpired: #940. - Support
MemoryStreamas a value forMySqlParameter.Value: #943. - Throw
OperationCanceledExceptionfromOpenAsyncwhen theCancellationTokenis cancelled: #931. - Support community protocol for server redirection: #945.
- Fix nested
MySqlException(thrown in some scenarios fromExecuteReader). - Remove public constructor for
MySqlConversionException. - Implement serialization for exceptions.
- Use .NET 5.0 methods to load PEM certificates.
- Thanks to @novak-as for contributions to this release.
- Implement Azure Server Redirection: #789.
- Change default value of
IgnorePreparetofalse: #929.- Calling
MySqlCommand.Prepare(Async)will have an effect by default.
- Calling
- Implement
IComparable<MySqlDateTime>andIEquatable<MySqlDateTime>onMySqlDateTime. - Improve exception message for unsupported parameter types: #925.
- Fix exception in server version parsing: #934.
- Fix silent failure to use TLS 1.3 (when explicitly requested) on older frameworks.
Badges
Extracted from project README
