Dear MySQL users,
MySQL Connector/NET 8.0.18 is the first version to support
.Net Core 3.0 and the sixth general availability release
of MySQL Connector/NET to add support for the X DevAPI, which
enables application developers to write code that combines the
strengths of the relational and document models using a modern,
NoSQL-like syntax that does not assume previous experience writing traditional SQL.
To learn more about how to write applications using the X DevAPI, see
http://dev.mysql.com/doc/x-devapi-userguide/en/index.html. For more
information about how the X DevAPI is implemented in Connector/NET, see
http://dev.mysql.com/doc/dev/connector-net.
NuGet packages provide functionality at a project level. To get the
full set of features available in Connector/NET such as availability
in the GAC, integration with Visual Studio's Entity Framework Designer
and integration with MySQL for Visual Studio, installation through
the MySQL Installer or the stand-alone MSI is required.
Please note that the X DevAPI requires at least MySQL Server version
8.0 or higher with the X Plugin enabled. For general documentation
about how to get started using MySQL as a document store, see
http://dev.mysql.com/doc/refman/8.0/en/document-store.html.
To download MySQL Connector/NET 8.0.18, see
http://dev.mysql.com/downloads/connector/net/
Installation instructions can be found at
https://dev.mysql.com/doc/connector-net/en/connector-net-installation.html
Changes in MySQL Connector/NET 8.0.18 (2019-10-14, General Availability)
Functionality Added or Changed
* Connector/NET now supports IPV6 connections made using
the classic MySQL protocol when the operating system on
the server host also supports IPV6. (Bug #29682333)
* Support for .NET Core 3.0 was added.
* In tandem with Microsoft, Connector/NET ends support for
.NET Core 1.0 and 1.1 (and also for Entity Framework Core
1.1, which depends on .NET Core 1.1).
* Previously, if the server restricted a classic
Connector/NET session to sandbox mode and the password on
the account expired, the session continued to permit the
use of SET statements. Now, SET statements in sandbox
mode with an expired password are prohibited and will
return an error message if used. The one exception is SET
PASSWORD, which is still permitted (see Server Handling
of Expired Passwords
(https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html)).
Bugs Fixed
* The Renci.SshNet.dll deployment was problematic for
Connector/NET 8.0.17 MSI installations. Some
applications, such as Microsoft Excel, were unable to
read MySQL data as a result. This fix removes unnecessary
dependencies on the DLL and also ensures that the MSI
installation deploys the correct Renci.SshNet.dll to the
GAC. (Bug #30215984, Bug #96614)
* Connector/NET returned an inaccurate value for the YEAR
type when a prepared command was used. (Bug #28383721,
Bug #91751)
* Entity Framework Core: A syntax error was generated
during an operation attempting to rename a table that was
previously migrated from code. Now, the primary key
constraint for an existing table can be dropped without
errors when the follow-on migration operation is
performed. (Bug #28107555, Bug #90958)
On Behalf of Oracle/MySQL Engineering Team
Sreedhar S