MySQL Lists are EOL. Please join:

List:Packagers« Previous MessageNext Message »
From:Surabhi Bhat Date:April 25 2019 1:11pm
Subject:MySQL Connector/NET 8.0.16 has been released
View as plain text  
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


Thread
MySQL Connector/NET 8.0.16 has been releasedSurabhi Bhat25 Apr 2019