v8.0 [Nov 30, 2017]
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.
- X DevAPI: The list of members shown with IntelliSense did not match the members provided in the reference documentation.
- 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.
- The TreatTinyAsBoolean connection option was ignored when the MySqlCommand.Prepare() method was called.
- 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.
Functionality Added or Changed:
- Optimistic locking for database-generated fields 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 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.
v6.4 [May 2, 2011]
- SchemaDefinition-5.5.ssdl was modified to treat CHAR(36) columns as a GUID. (Bug #61657, Bug #12708208)
- SqlFragment.QuoteIdentifier was modified to add MySQL quotes around identifiers. (Bug #61635, Bug #12707285)