home.md

lastmod	date	title	weight	menu
2023-11-19	2016-10-16	Home	10	main url /

MySqlConnector: High Performance .NET MySQL Driver

About

MySqlConnector is a C# ADO.NET driver for MySQL Server, MariaDB, Amazon Aurora, Azure Database for MySQL, Google Cloud SQL for MySQL, Percona Server and more. It provides implementations of DbConnection, DbCommand, DbDataReader, DbTransaction — the classes needed to query and update databases from C# code.

Getting Started

Install MySqlConnector from NuGet: dotnet add package MySqlConnector

Connecting to your database is simple. For example, in C#:

using var connection = new MySqlConnection("Server=myserver;User ID=mylogin;Password=mypass;Database=mydatabase");
connection.Open();

using var command = new MySqlCommand("SELECT field FROM table;", connection);
using var reader = command.ExecuteReader();
while (reader.Read())
    Console.WriteLine(reader.GetString(0));

For more information, see how to install and a basic example of using the API. Many ORMs are supported.

Asynchronous I/O

MySqlConnector also fully supports asynchronous I/O. The C# example above can be rewritten as:

await using var connection = new MySqlConnection("Server=myserver;User ID=mylogin;Password=mypass;Database=mydatabase");
await connection.OpenAsync();

using var command = new MySqlCommand("SELECT field FROM table;", connection);
await using var reader = await command.ExecuteReaderAsync();
while (await reader.ReadAsync())
    Console.WriteLine(reader.GetString(0));

Server Compatibility

MySqlConnector is compatible with the following servers. Version numbers in bold indicate versions that are regularly tested by the integration tests run on every commit.

Server	Versions	Notes
Amazon Aurora RDS	2.x, 3.x	Use Pipelining=False for Aurora 2.x
Azure Database for MySQL	5.7, 8.0	Single Server and Flexible Server
Google Cloud SQL for MySQL	5.6, 5.7, 8.0
MariaDB	10.x (10.6, 10.11), 11.x (11.4, 11.6)
MySQL	5.5, 5.6, 5.7, 8.x (8.0, 8.4), 9.x (9.2)	5.5 is EOL and has some compatibility issues; 5.6 and 5.7 are EOL
Percona Server	5.6, 5.7, 8.0
PlanetScale		See PlanetScale MySQL compatibility notes
ProxySQL	2.x	Some compatibility issues
SingleStoreDB
TiDB

Performance

MySqlConnector outperforms Connector/NET (MySql.Data) on benchmarks:

(Client: MySqlConnector 2.3.1, MySql.Data 8.2.0, Ubuntu 23.04, .NET 8.0; Server: Azure Database for MySQL 8.0.34, TLS 1.2)

Why use MySqlConnector over Oracle’s MySQL Connector/NET?

MySqlConnector is a clean-room reimplementation of the MySQL Protocol and is not based on Oracle’s MySQL Connector/NET.

See MySqlConnector vs MySql.Data for reasons to switch to MySqlConnector and details on migrating.