Develop and modify database applications using elements of MySQL by accessing it with the ADO.NET driver. The utility enables data transfer and modification of files, code correction, and visualization. It supports integration with third-party software excluding the MySQL for Visual Studio.
MySQL Connector/NET enables you to develop .NET applications that require data connectivity with MySQL. It implements the required ADO.NET interfaces and integrates into ADO.NET-aware tools. The present version is compatible with all MySQL versions starting with MySQL 5.5. Additionally, MySQL Connector/NET 8.0 supports the new X DevAPI for development with MySQL Server 8.0.
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.
Feature-rich relational database known for its high performance and excellent concurrency
Mall Creeps
