Changes in MySQL Connector/NET 6.10.2 (2017-07-04, Beta)

• Deprecation and Removal Notes

• Functionality Added or Changed

• Bugs Fixed

Deprecation and Removal Notes

• The previously deprecated Old Syntax (OldSyntax, Use Old Syntax, UseOldSyntax) connection-string option was removed. (WL #10542)

Functionality Added or Changed

• EF Core: Tables from an existing database can be specified with command-line tools when scaffolding a DbContext for a database. The MySQL provider generates an entity type for each table in the DbContext. By default, all tables in the database are included unless a list of tables is provided.

  For Package Manager Console Tools, use the Scaffold-DbContext command with the -Table <tablename, tablename, ...> common parameter.

  For .NET Core CLI Tools, use the dotnet ef dbcontext scaffold command with the --table <tablename> option for each table to add. (WL #10669)

• EF Core: The MySQL provider now creates a new schema when the entity.ToTable method within a derived DbContext class specifies the name of a nonexistent schema. (WL #10695)

• EF Core: The Connector/NET implementation of EF Core now includes extended maximum lengths for several string data types to enable the use of longer strings. (WL #10705)

• Connector/NET no longer supports MySQL Fabric. (WL #10566)

Bugs Fixed

• EF Core: The --force option when used with the dotnet ef dbcontext scaffold command did not overwrite the existing output files as expected. (Bug #25493508)

• EF Core: The Database First command used to create a DbContext class emitted an error when used with either the sakila or world database sample. (Bug #25493336)

• EF Core: The Database First feature did not support the following data types: BINARY, VARBINARY, MEDIUMBLOB, LONGBLOB, SET, DATE, TIME, and YEAR. (Bug #25493209)

• EF Core: JSON data exchange format was not supported by the Database First feature. (Bug #25493143)

• EF Core: Database First support produced an error when the existing MySQL database included one or more views. (Bug #25493086)

• EF Core: Using System.ComponentModel.DataAnnotations.Schema.TableAttribute to initialize a new class instance that specified the name of an existing MySQL table produced incorrect mappings of table and column names. (Bug #25394223, Bug #84423)