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 package,
       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 MySql.Data.EntityFrameworkCore
       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 [ConcurrencyCheck,
       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 Obsolete.

          + Remove(DbDoc) method was marked Obsolete.

          + 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
            with AffectedItemsCount.

          + 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 added.
       (Bug #27732098, Bug #27732175, Bug #27732235)

     * The MySqlX.XDevAPI.MySqlXConnectionStringBuilder class
       was added to provide connection-string options that apply
       exclusively to X Protocol connections. In addition, the
       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 decimal
       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 different
       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 David
       Warner for the patch. (Bug #22101727, Bug #78917)

On Behalf of MySQL Release Engineering team,
Surabhi Bhat

MySQL General Mailing List
For list archives:
To unsubscribe:

Reply via email to