In some cases, the function that creates SQL queries did not specify an escape character properly. This fix adds a new method to handle the cases in which a string could require an escape character and applies it before building the SQL query. (Bug #103160, Bug #34498485)
When Connector/NET set the
'ANSI', it did so without considering the current value. (Bug #79678, Bug #22564126)
Connector/NET 8.0.27 implemented support for the SSPI Kerberos library on Windows, which was not capable of acquiring cached credentials previously generated by using kinit command. Connector/NET 8.0.32 also supports GSSAPI through the MIT Kerberos library to add that capability using the
authentication_kerberos_clientauthentication plugin on Windows.
A new connection option,
KerberosAuthMode, enables developers using the classic MySQL protocol to attempt authentication at run time using a mode value specified at design time. These mode values are permitted:
AUTO(default value) – Use SSPI and fall back to GSSAPI in case of failure.
SSPI– Use SSPI only and raise an exception in case of failure.
GSSAPI– Use GSSAPI only and raise an exception in case of failure.
Use of the
KerberosAuthModeconnection option is restricted to Windows. Its use raises an exception in non-Windows environments. For more information about the connector’s implementation of the client-side Kerberos authentication plugin, see authentication_kerberos_client.
This release of Connector/NET upgrades the NuGet package reference for
Google.Protobufto version 3.21.9, which has been publicly reported as not vulnerable to
CVE-2022-3171. (Bug #34859629)
To enhance the performance of connections, Connector/NET now determines whether a connection string has been analyzed already before performing the analysis for a second time. (Bug #102964, Bug #32680315)
It is now possible to pass a stream object to the
MySqlBulkLoader.Load()method for copying bulk data to a database. Our thanks to Alexander Reinert for the patch. (Bug #74392, Bug #21049228)
Connector/NET now fully supports .NET 7 and Entity Framework Core 7.0 (EF7) for applications that target .NET 7 exclusively. Previously, Connector/NET 8.0.31 supported the .NET 7 and EF7 previews.
Connector/NET could not authenticate a valid client user through Oracle Cloud Infrastructure pluggable authentication. Now, the connector implements new constraints to ensure that the client-side plugin loads the
OCI.DotNetSDK.Commonassembly, which contains the required functions needed to authenticate a client user. (Bug #34851463)
When unloading the assembly, the procedure recommended by Microsoft was not performed accurately for .NET Core frameworks. Our thanks to Gabriele Gervasi for the patch. (Bug #108837, Bug #34724334)
System.NullReferenceExceptionmessage was returned when the
MySqlCommand.Cancel()method was called for a command associated with a closed (or disposed)
MySqlConnectionobject. The issue is resolved with new validation in the method that now checks the connection state. (Bug #101507, Bug #32127591)
Some methods of the
MySqlDataReaderclass that should retrieve an integer value instead could return unexpected values. This behavior had multiple causes. First, the connector was not properly informed by the
TreatTinyAsBooleanproperty that it should treat type
BOOL. In addition, Connector/NET implemented the conversion to a different type inconsistently. (Bug #99091, Bug #31087580)
When executing multiple
INSERTstatements in one
LastInsertedIdproperty was set to zero because the connector read an extra
OKpacket from the server that omitted
LastInsertedId. Now, Connector/NET avoids overriding the value if it is set. (Bug #97061, Bug #30365157)
Improved validation now ensures that the
MySqlParameterCollection.Add()method behaves consistently when it checks whether a named parameter has been added already. (Bug #93370, Bug #28980952)
Values of the
SourceColumnNullMappingproperties were omitted during the copy operation performed by the
MySqlParameter.Clone()method. (Bug #92734, Bug #28777779)
MySqlException.Numberproperty for authentication-related exceptions always returned a value of zero. (Bug #78426, Bug #21830667)
Output parameters in combination with a command of type
CommandType.Textwere not supported. This fix changed how Connector/NET manages the parameters with an output direction for text commands. (Bug #75267, Bug #20259756)