MySQL Blog Archive
For the latest blogs go to blogs.oracle.com/mysql
MySQL Connector/NET 8.0.20 has been released

Dear MySQL users,

MySQL Connector/NET 8.0.20 is the latest General Availability release of
the MySQL Connector/NET 8.0 series. This version supports .NET Core 3.1
and 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.20, 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.20 (2020-04-27, General
Availability)

    * Functionality Added or Changed

    * Bugs Fixed

Functionality Added or Changed

    * Connector/NET now supports Entity Framework Core 3.1.1 on
      all platforms with NET Standard 2.0 support. Microsoft
      Entity Framework Core 3.1.1 is not compatible with the
      previous versions of EF Core and those previous versions
      (2.1, 2.0, 1.1) are not supported by this release of
      Connector/NET (see Entity Framework Core Support
(https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core.html)).
      In addition, the MySql.Data.EntityFrameworkCore.Design
      NuGet package is deprecated and the functionality
      provided by that package now is merged with the
      MySql.Data.EntityFrameworkCore package.

    * Connector/NET now provides compression of X Protocol
      payload data, which can be configured using the new
      Compression connection option. The option is set to
      preferred mode by default to compress the payload data if
      the MySQL server instance also supports compression. For
      a description of each option value, see Options for X
      Protocol Only
(https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html#connector-net-8-0-connection-options-xprotocol).

    * Document Store: Connector/NET now provides JSON schema
      validation for a collection to enforce a certain
      structure that documents must adhere to before they are
      permitted to be inserted or updated. Schema validation is
      performed by the server, which returns an error message
      if a document in a collection does not match the schema
      definition or if the server does not support validation.
      The existing Schema.CreateCollection method now is
      overloaded and can be used to pass a
      CreateCollectionOptions object with a schema definition
      to a MySQL server. The ReuseExistingObject parameter of
      the original method is set as an option within
      CreateCollectionOptions when using the new overloaded
      method. The level of enforcement (off or strict, strict
      by default) and schema definition are specified using the
      validation option, for example:
var collOptions = CreateCollectionOptions() {
    reuseExistingObject = false,
    validation = Validation() {
        level = ValidationLevel.Strict,
        schema = “{\”id\”: \“http://json-schema.org/geo\”,”
                        + “\”$schema\”: \“http://json-schema.org/draft-06/schema# \”,”
                        +               ” \”description\”: \”A geographical coordinate\”, ”
                        +               ” \”type\”: \”object\”,”
                        +               ” \”properties\”: {”
                        +                    ” \”latitude\”: {”
                        +                         ” \”type\”: \”number\””
                        +                    ” },”
                        +                      ” \”longitude\”: {”
                        +                          ” \”type\”: \”number\””
                        +                     ” }”
                        +                ” },”
                        +                ” \”required\”: [\”latitude\”, \”longitude\”]”
                        +  ” }”
             }
};

var coll = schema.CreateCollection(“longlang”, collOptions);
            In addition, a new method permits the schema validation
            of an existing collection to be reset. The
            Schema.ModifyCollection method passes a
            ModifyCollectionOptions object to the server. The
            validation collection option must include either a
             modified level value or schema value (or both), for
            example:
var collOptions = ModifyCollectionOptions() {
    validation = Validation() {
        level = ValidationLevel.Off
            }
};

var coll = schema.ModifyCollection(“longlang”, collOptions);
           The ReuseExistingObject option is not supported for
           modifications and returns an error message if it is used.

Bugs Fixed

    * A connection made to a named server with multiple DNS
      entries pointing to different IP addresses for the same
      server generated an exception. Now, only the first
      element is returned when multiple elements are found.
      (Bug #30970949, Bug #97448)

    * The MySQL.Data NuGet package for Connector/NET 8.0.19
      included an unsigned version of Ubiety.Dns.Core.dll,
      which produced an exception when loaded. (Bug #30798305,
      Bug #98204)

    * Scaffolding a MySQL database with EF Core 3.0 was not
      implemented by Connector/NET and the connector returned
      an exception in response to its use. Support for EF Core
      3.1.1 in this release adds scaffolding capabilities. (Bug
      #30677382, Bug #98011)

    * The get_info method was not included in any of the Entity
      Framework Core versions (1.1, 2.0, and 2.1) that
      Connector/NET supported. Connector/NET now supports EF
      Core 3.1.1 and implements the
      MySql.Data.EntityFrameworkCore.Infrastructure.MySQLOption
      sExtension.Internal.get_info method. (Bug #30347893, Bug
      #96990)

    * The MySqlDbType.JSON type when used as a parameter in a
      prepared statement produced code errors. Connector/NET
      now interprets MySqlDbType.JSON as MySqlDbType.VarChar.
      No code changes are required to specify a JSON column.
      (Bug #29959124, Bug #95984)

    * Blank spaces mixed with values in the IN() list of a
      SELECT statement generated an error. (Bug #29838254)

    * An attempt to read the record of a model class defined to
      correspond to a MySQL table with a property of type bool?
      (nullable Boolean), using the EF Core database context,
      returned an error message. (Bug #29833103, Bug #93028)

    * Access to the MySqlDataReader object was restricted when
      the parent MySqlCommand object was closed. This fix
      modifies MySqlCommand.Dispose() to no longer call the
      ResetReader method. (Bug #27441433, Bug #89159)

On Behalf of MySQL Release Engineering Team,
Tvarita Jain