MySqlConnector 2.5.0

About

MySqlConnector is a C# ADO.NET driver for MySQL, MariaDB, Amazon Aurora, Azure Database for MySQL and other MySQL-compatible databases.

More documentation is available at the MySqlConnector website.

How to Use

// set these values correctly for your database server
var builder = new MySqlConnectionStringBuilder
{
	Server = "your-server",
	UserID = "database-user",
	Password = "P@ssw0rd!",
	Database = "database-name",
};

// open a connection asynchronously
await using var connection = new MySqlConnection(builder.ConnectionString);
await connection.OpenAsync();

// create a DB command and set the SQL statement with parameters
await using var command = connection.CreateCommand();
command.CommandText = @"SELECT * FROM orders WHERE order_id = @OrderId;";
command.Parameters.AddWithValue("@OrderId", orderId);

// execute the command and read the results
await using var reader = await command.ExecuteReaderAsync();
while (reader.Read())
{
	var id = reader.GetInt32("order_id");
	var date = reader.GetDateTime("order_date");
	// ...
}

ASP.NET

For ASP.NET, use the MySqlConnector.DependencyInjection package to integrate with dependency injection and logging.

var builder = WebApplication.CreateBuilder(args);

// use AddMySqlDataSource to configure MySqlConnector
builder.Services.AddMySqlDataSource(builder.Configuration.GetConnectionString("Default"));

var app = builder.Build();

// use dependency injection to get a MySqlConnection in minimal APIs or in controllers
app.MapGet("/", async (MySqlConnection connection) =>
{
    // open and use the connection here
    await connection.OpenAsync();
    await using var command = connection.CreateCommand();
    command.CommandText = "SELECT name FROM users LIMIT 1";
    return "Hello World: " + await command.ExecuteScalarAsync();
});

app.Run();

Key Features

Full support for async I/O
High performance
Supports .NET Framework, .NET Core, and .NET 5.0+

Main Types

The main types provided by this library are:

MySqlConnection (implementation of DbConnection)
MySqlCommand (implementation of DbCommand)
MySqlDataReader (implementation of DbDataReader)
MySqlBulkCopy
MySqlBulkLoader
MySqlConnectionStringBuilder
MySqlConnectorFactory
MySqlDataAdapter
MySqlException
MySqlTransaction (implementation of DbTransaction)

Dependency Injection: MySqlConnector.DependencyInjection
Entity Framework Core: Pomelo.EntityFrameworkCore.MySql

Feedback

MySqlConnector is released as open source under the MIT license. Bug reports and contributions are welcome at the GitHub repository.

Showing the top 20 packages that depend on MySqlConnector.

Packages	Downloads
FreeSql.Provider.MySqlConnector FreeSql 数据库实现，基于 MySql 5.6，Ado.Net 驱动是 MySqlConnector	69
Hangfire.MySqlStorage Hangfire MySql Storage	71
Hangfire.MySqlStorage Hangfire MySql Storage	75
Hangfire.MySqlStorage Hangfire MySql Storage	77
Pomelo.EntityFrameworkCore.MySql MySQL provider for Entity Framework Core	69
Pomelo.EntityFrameworkCore.MySql Pomelo's MySQL database provider for Entity Framework Core.	162
Pomelo.EntityFrameworkCore.MySql Pomelo's MySQL database provider for Entity Framework Core.	172
Pomelo.EntityFrameworkCore.MySql Pomelo's MySQL database provider for Entity Framework Core.	624
Quantum.Framework.Core.StandardLib Package Description	69
Quantum.Framework.Core.StandardLib Package Description	73
Quantum.Framework.Core.StandardLib Package Description	75
Quantum.Framework.Core.StandardLib Package Description	76
Quantum.Framework.Core.StandardLib Package Description	77
Quantum.Framework.Core.StandardLib Package Description	80
Quantum.Framework.Core.StandardLib Package Description	84
Quantum.Framework.Core.StandardLib Package Description	92
Quantum.Framework.Core.StandardLib Package Description	96
Quantum.Framework.Core.StandardLib Package Description	103
Quantum.Framework.Core.StandardLib Package Description	106

https://mysqlconnector.net/overview/version-history/

Version	Downloads	Last updated
2.5.0	48	11/13/2025
2.5.0-beta.1	26	10/30/2025
2.4.0	97	11/14/2024
2.4.0-beta.2	52	11/09/2024
2.4.0-beta.1	57	11/16/2024
2.3.7	134	04/28/2024
2.3.6	62	05/01/2024
2.3.5	301	05/06/2024
2.3.4	53	12/02/2024
2.3.3	45	11/24/2024
2.3.2	55	11/28/2024
2.3.1	58	11/29/2024
2.3.0	57	12/04/2024
2.3.0-beta.2	53	08/04/2023
2.3.0-beta.1	57	04/14/2023
2.2.7	48	12/06/2024
2.2.6	51	12/06/2024
2.2.5	156	05/24/2024
2.2.4	47	11/12/2024
2.2.3	49	10/31/2024
2.2.2	53	04/28/2024
2.2.1	59	11/27/2024
2.2.0	55	11/29/2024
2.1.13	62	05/22/2024
2.1.12	54	11/19/2024
2.1.11	64	11/27/2024
2.1.10	51	11/27/2024
2.1.9	51	11/26/2024
2.1.7	55	11/23/2024
2.1.5	45	11/28/2024
2.1.1	63	04/21/2022
1.3.14	41	11/26/2024
1.3.13	61	07/15/2022
1.3.12	48	11/28/2024
1.3.9	55	11/27/2024
1.3.5	53	11/27/2024
1.3.4	52	12/02/2024
1.3.3	58	04/21/2022
1.3.2	50	11/26/2024
1.3.1	49	11/11/2024
0.69.10	13,784	04/25/2022
0.69.9	72	04/27/2022
0.69.8	43	11/27/2024
0.69.7	53	12/02/2024
0.69.6	48	11/27/2024
0.69.5	43	11/12/2024
0.69.4	44	11/12/2024
0.69.1	50	12/08/2024
0.69.0	59	11/28/2024
0.68.1	58	11/27/2024
0.67.0	43	12/10/2024
0.66.0	50	11/12/2024
0.64.2	53	11/14/2024
0.64.1	56	04/21/2022
0.63.2	46	11/12/2024
0.60.4	49	11/26/2024
0.60.1	43	11/12/2024
0.60.0	45	12/06/2024
0.59.1	45	11/28/2024
0.59.0	42	11/27/2024
0.58.0	56	11/12/2024
0.57.0	49	12/06/2024
0.56.0	42	11/01/2024
0.55.0	43	12/17/2024
0.52.0	47	12/10/2024
0.51.1	46	11/28/2024
0.50.0	40	11/27/2024
0.49.3	49	11/28/2024
0.49.0	46	11/27/2024
0.48.2	50	12/04/2024
0.48.1	44	11/12/2024
0.48.0	41	11/12/2024
0.47.0	46	11/27/2024
0.46.2	42	11/27/2024
0.46.1	44	12/14/2024
0.46.0	54	11/12/2024
0.45.0	50	11/27/2024
0.44.1	43	11/25/2024
0.44.0	47	12/06/2024
0.42.3	49	11/12/2024
0.42.2	49	12/06/2024
0.42.1	48	11/12/2024
0.42.0	39	11/11/2024
0.41.0	46	11/26/2024
0.40.3	47	11/27/2024
0.40.2	42	11/27/2024
0.36.0	41	12/05/2024
0.35.0	45	11/12/2024
0.32.0	45	11/27/2024
0.30.0	50	11/28/2024
0.29.4	34	11/28/2024
0.29.2	52	04/21/2022
0.26.4	47	11/12/2024
0.26.2	48	11/27/2024
0.26.1	49	11/12/2024
0.25.0	52	11/28/2024
0.20.0	43	11/27/2024
0.19.3	44	11/29/2024
0.16.2	32	12/02/2024
0.9.0	45	12/11/2024
0.7.4	36	11/29/2024
0.7.0	49	11/27/2024
0.6.0	45	11/30/2024
0.5.0	49	12/01/2024
0.2.1	43	05/02/2024
0.2.0	53	05/31/2024

MySqlConnector 2.5.0

Readme

About

How to Use

ASP.NET

Key Features

Main Types

Related Packages

Feedback

Used By

Release Notes

Dependencies

.NET Framework 4.6.2

.NET Standard 2.1

.NET Standard 2.0

.NET 10.0

.NET 9.0

.NET 8.0

.NET 6.0

.NET Framework 4.7.1

.NET Framework 4.8

Versions