MySQL Connector/NET 8.0.16 has been released

[Surabhi Bhat]

Dear MySQL users,
 
MySQL Connector/NET 8.0.16 is the fourth version to support
Entity Framework Core 2.1 and the sixth general availability release
of MySQL Connector/NET to add support for the new 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.16, 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.16 ( 2019-04-25, General Availability )


     * Functionality Added or Changed

     * Bugs Fixed

Functionality Added or Changed


     * Document Store: Support was added for the -> operator to
       be used with JSON document paths in relational
       statements. For example:
table.Select().Where("additionalinfo->$.hobbies = 'Reading'");

       (Bug #29347028)

     * Document Store: The performance for statements that are
       executed repeatedly (two or more times) is improved by
       using server-side prepared statements for the second and
       subsequent executions. This happens internally;
       applications need take no action and API behavior should
       be the same as previously. For statements that change,
       repreparation occurs as needed. Providing different data
       values or different OFFSET or LIMIT clause values does
       not count as a change. Instead, the new values are passed
       to a new invocation of the previously prepared statement.

     * Document Store: Connector/NET now supports the ability to
       send connection attributes (key-value pairs that
       application programs can pass to the server at connect
       time). Connector/NET defines a default set of attributes,
       which can be disabled or enabled. In addition,
       applications can specify attributes to be passed together
       with the default attributes. The default behavior is to
       send the default attribute set.
       The aggregate size of connection attribute data sent by a
       client is limited by the value of the
       performance_schema_session_connect_attrs_size server
       variable. The total size of the data package should be
       less than the value of the server variable. For X DevAPI
       applications, specify connection attributes as a
       connection-attributes parameter in a connection string.
       For usage information, see Options for X Protocol Only
       ( http://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html#connector-net-8-0-connection-options-xprotocol ).
       For general information about connection attributes, see
       Performance Schema Connection Attribute Tables
       ( http://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-attribute-tables.html ).

     * Document Store: Connector/NET now has improved support
       for resetting sessions in connection pools. Returning a
       session to the pool drops session-related objects such as
       temporary tables, session variables, and transactions,
       but the connection remains open and authenticated so that
       reauthentication is not required when the session is
       reused.

     * Connector/NET applications now can use certificates in
       PEM format to validate SSL connections in addition to the
       native PFX format (see Tutorial: Using SSL with Connector/NET
       ( http://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl.html )). 
       PEM support applies to both classic MySQL protocol 
       and X Protocol connections.

Bugs Fixed


     * Document Store: All methods able to execute a statement
       were unable to execute the same statement a second time.
       Now, the values and binding parameters remain available
       after the method is executed and string parameters are no
       longer converted to numbers. Both changes enable a
       follow-on execution to reuse the previous parameters.
       (Bug #29249857, Bug #29304767)

     * An exception was generated when the MySqlDbType
       enumeration was given an explicit value and then passed
       as a parameter to the MySqlCommand.Prepare method. (Bug
       #28834253, Bug #92912)

     * Validation was added to ensure that when a column is of
       type TIME and the value is 00:00:00, it takes the value
       instead of setting NULL. (Bug #28383726, Bug #91752)


On Behalf of MySQL Release Engineering Team,
Surabhi Bhat