MySQL Connector Net versions

Creates .NET database apps utilizing MySQL
8.0
Nov 30, 2017
Review
6.9
May 2, 2014
Review
6.8
Nov 1, 2013
Review
6.7
Apr 11, 2013
6.6
Jul 29, 2012
Review
6.5
Dec 26, 2011
Review
6.4
May 2, 2011
Review
6.3
Mar 2, 2010
6.2
Oct 26, 2009
6.1
Jul 22, 2009
Review
5.2
Jul 25, 2008
5.1
Mar 2, 2008

What's new

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)

Alternative downloads

MySQL Connector C++
MySQL Connector C++
Free
rating

MySQL Connector/C++ is a MySQL database connector for C++.

PL/SQL Developer
PL/SQL Developer
rating

Manage databases, execute SQL scripts, and develop program units for Oracle DBs.

MySQL-Front
MySQL-Front
Free
rating

Connect to and edit MySQL databases and local data files.

EMS MySQL Manager Lite
EMS MySQL Manager Lite
Free
rating

EMS SQL Manager Lite for MySQL is an excellent freeware graphical tool.

dbDeveloper
dbDeveloper
rating

Visual development tool for multiple databases.