MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Surabhi Bhat Date:July 27 2018 7:50pm
Subject:MySQL Connector/NET 8.0.12 has been released
View as plain text  
Dear MySQL users,

MySQL Connector/NET 8.0.12 is the second general availability release of
MySQL Connector/NET to add support for the new X DevAPI. The X DevAPI
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 For more
information about how the X DevAPI is implemented in Connector/NET, see

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
5.7.12 or higher with the X Plugin enabled. For general documentation
about how to get started using MySQL as a document store, see

To download MySQL Connector/NET 8.0.12, see

Installation instructions can be found at

Changes in MySQL Connector/NET 8.0.12 (2018-07-27, General Availability)

    Known Limitation of This Release

    To create a model in Entity Framework (EF) Core v2.0 with
    scaffolding in this release, use the following alternative

     1. Downgrade to EF Core 1.0 or 1.1 in your project, install
        the MySql.Data.EntityFrameworkCore.Design NuGet
        and then create your model using the scaffoldingor
        migration command.

     2. With the model created, revert back to EF Core 2.0 in
        your project, update the
        NuGet package, and then remove the package
MySql.Data.EntityFrameworkCore.Design from your project.

    We are sorry for this temporary inconvenience.

      * Functionality Added or Changed

      * Bugs Fixed

Functionality Added or Changed

      * Optimistic locking using a database-generated field was
        improved with the inclusion of the
        attribute. Thanks to Tony Ohagan for the patch. (Bug
        #28095165, Bug #91064)

      * Members of several classes in the X DevAPI were added,
        modified, or removed.
MySqlX.XDevAPI.Collection and
MySqlX.XDevAPI.Collection<T> classes:

           + Remove(Object) method was marked

           + Remove(DbDoc) method was marked

           + CreateIndex() method was
modified to be a
direct-execute method (no longer requires .Execute()
             to execute).
MySqlX.XDevAPI.Common.Result class:

           + RecordsAffected property (now
obsolete) was replaced

           + WarningCount property (now
obsolete) was replaced
             with WarningsCount.
MySqlX.XDevAPI.CRUD.FindStatement class:

           + GroupBy() method was added.

           + Having() method was added.

           + Limit(Int64, Int64) method was
marked Obsolete.

           + Offset() method was added.

           + Sort() method was added.

           + OrderBy() method was removed.
MySqlX.XDevAPI.CRUD.ModifyStatement class:

           + ArrayInsert method was added.

           + ArrayAppend method was added.

           + Unset() method was modified to
accept an array of
             document paths.
MySqlX.XDevAPI.CRUD.RemoveStatement class:

           + Sort() method was added.

           + OrderBy() method was removed.
MySqlX.XDevAPI.Relational.RowResult class:

           + ColumnCount property was added.

           + ColumnNames property was added.
MySqlX.XDevAPI.Relational.SqlResult class:

           + AutoIncrementValue property was
marked Obsolete.
MySqlX.XDevAPI.Relational.TableSelectStatement class:

           + Limit(Int64, Int64) method was
marked Obsolete.

           + Offset() method was added.
MySqlX.XDevAPI.Session class:

           + Commit() method was changed to
be a direct-execute
             method and now it
returns void.

           + Rollback() method was changed to
be a direct-execute
             method and now it
returns void.

           + Uri property was added.

           + DefaultSchema property was
        (Bug #27732098, Bug #27732175, Bug #27732235)

      * The MySqlX.XDevAPI.MySqlXConnectionStringBuilder class
        was added to provide connection-string options that
        exclusively to X Protocol connections. In addition,
        Auth, SslCa, and SslCrl properties in the
MySql.Data.MySqlClient.MySqlConnectionStringBuilder class
        were marked Obsolete.

Bugs Fixed

      * X DevAPI: Decimal numbers passed to the DbDoc class were
        not parsed properly when the values included a
        separator other than a period (.) character. (Bug

      * X DevAPI: The list of members shown with IntelliSense did
        not match the members provided in the reference
        documentation. (Bug #27918879, Bug #90615)

      * The Entity Framework Core implementation did not render
        accented characters correctly on bases with
        UTF-8 encoding. Thanks to Kleber kleberksms for the
        patch. (Bug #27818822, Bug #90316)

      * The TreatTinyAsBoolean connection option was ignored when
        the MySqlCommand.Prepare() method was called. (Bug
        #27113566, Bug #88472)

      * All columns of type TINYINT(1) stopped returning the
        expected Boolean value after the connector
encountered a
        NULL value in any column of this type. Thanks to
        Warner for the patch. (Bug #22101727, Bug #78917)

On Behalf of MySQL Release Engineering team,
Surabhi Bhat

MySQL Connector/NET 8.0.12 has been releasedSurabhi Bhat27 Jul