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 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 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 http://dev.mysql.com/doc/refman/5.7/en/document-store.html. To download MySQL Connector/NET 8.0.12, 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.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 procedure: 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, DatabaseGenerated(DatabaseGeneratedOption.Computed)] 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 #28112229) * 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: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql