MySqlConnector 2.1.2 Prefix Reserved

Install-Package MySqlConnector -Version 2.1.2

dotnet add package MySqlConnector --version 2.1.2

<PackageReference Include="MySqlConnector" Version="2.1.2" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add MySqlConnector --version 2.1.2

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: MySqlConnector, 2.1.2"

#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.

// Install MySqlConnector as a Cake Addin
#addin nuget:?package=MySqlConnector&version=2.1.2

// Install MySqlConnector as a Cake Tool
#tool nuget:?package=MySqlConnector&version=2.1.2

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

About

MySqlConnector is an ADO.NET data provider 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
using var connection = new MySqlConnection(builder.ConnectionString);
await connection.OpenAsync();

// create a DB command and set the SQL statement with parameters
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
using var reader = await command.ExecuteReaderAsync();
while (reader.Read())
{
	var id = reader.GetInt32("order_id");
	var date = reader.GetDateTime("order_date");
	// ...
}

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)

Related Packages

Entity Framework Core: Pomelo.EntityFrameworkCore.MySql
Logging: log4net, Microsoft.Extensions.Logging, NLog, Serilog

Feedback

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

.NETCoreApp 3.1
- System.Diagnostics.DiagnosticSource (>= 5.0.1)
.NETFramework 4.5
- System.Buffers (>= 4.5.1)
- System.Diagnostics.DiagnosticSource (>= 5.0.1)
- System.Memory (>= 4.5.4)
- System.Threading.Tasks.Extensions (>= 4.3.0)
.NETFramework 4.6.1
- System.Buffers (>= 4.5.1)
- System.Diagnostics.DiagnosticSource (>= 5.0.1)
- System.Memory (>= 4.5.4)
- System.Threading.Tasks.Extensions (>= 4.3.0)
.NETFramework 4.7.1
- System.Buffers (>= 4.5.1)
- System.Diagnostics.DiagnosticSource (>= 5.0.1)
- System.Memory (>= 4.5.4)
- System.Threading.Tasks.Extensions (>= 4.3.0)
.NETStandard 2.0
- System.Buffers (>= 4.5.1)
- System.Diagnostics.DiagnosticSource (>= 5.0.1)
- System.Memory (>= 4.5.4)
- System.Threading.Tasks.Extensions (>= 4.3.0)
.NETStandard 2.1
- System.Diagnostics.DiagnosticSource (>= 5.0.1)
net5.0
- No dependencies.
net6.0
- No dependencies.

NuGet packages (310)

Showing the top 5 NuGet packages that depend on MySqlConnector:

Package	Downloads
Pomelo.EntityFrameworkCore.MySql Pomelo's MySQL database provider for Entity Framework Core.	19.3M
AspNetCore.HealthChecks.MySql HealthChecks.MySql is the health check package for MySQL.	1.3M
Pomelo.EntityFrameworkCore.MySql.Design Package Description	1.0M
Hangfire.MySqlStorage Hangfire MySql Storage	822.8K
YesSql.Provider.MySql Package Description	655.6K

GitHub repositories (64)

Showing the top 5 popular GitHub repositories that depend on MySqlConnector:

Repository	Stars
dotnet/aspnetcore ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.	27.0K
DapperLib/Dapper Dapper - a simple object mapper for .Net	14.4K
aspnet/Mvc [Archived] ASP.NET Core MVC is a model view controller framework for building dynamic web sites with clean separation of concerns, including the merged MVC, Web API, and Web Pages w/ Razor. Project moved to https://github.com/aspnet/AspNetCore	5.7K
dotnetcore/CAP Distributed transaction solution in micro-service base on eventually consistency, also an eventbus with Outbox pattern	5.3K
quartznet/quartznet Quartz Enterprise Scheduler .NET	4.9K

Version	Downloads	Last updated
2.1.2	20,923	12/23/2021
2.1.1	1,902	12/21/2021
2.1.0	48,946	11/28/2021
2.0.0	202,677	11/9/2021
1.3.14	132,377	10/20/2021
1.3.13	375,984	10/2/2021
1.3.12	113,932	9/11/2021
1.3.11	354,009	7/2/2021
1.3.10	811,659	6/16/2021
1.3.9	213,964	5/27/2021
1.3.8	150,239	4/30/2021
1.3.7	773,288	4/24/2021
1.3.6	505	4/24/2021
1.3.5	5,403	4/23/2021
1.3.4	51,634	4/21/2021
1.3.3	77,898	4/12/2021
1.3.2	145,182	3/22/2021
1.3.1	84,635	3/11/2021
1.3.0	85,459	3/7/2021
1.2.1	474,249	12/12/2020
1.2.0	98,385	11/26/2020
1.1.0	1,251,206	11/10/2020
1.0.1	637,384	8/13/2020
1.0.0	385,560	7/11/2020
0.69.10	523,934	10/21/2020
0.69.9	2,217,916	8/20/2020
0.69.8	102,199	7/20/2020
0.69.7	2,224	7/16/2020
0.69.6	87,990	7/7/2020
0.69.5	41,614	7/1/2020
0.69.4	19,512	6/25/2020
0.69.3	104,265	6/16/2020
0.69.2	10,127	6/12/2020
0.69.1	5,603	6/10/2020
0.69.0	11,677	6/8/2020
0.68.1	2,123	6/8/2020
0.68.0	1,465	6/6/2020
0.67.0	32,041	5/30/2020
0.66.0	273,214	5/7/2020
0.65.0	14,307	5/3/2020
0.64.2	9,319	4/28/2020
0.64.1	17,910	4/26/2020
0.64.0	36,618	4/18/2020
0.63.2	143,684	4/9/2020
0.63.1	171,758	4/4/2020
0.63.0	37,986	3/26/2020
0.62.0	148,614	2/29/2020
0.61.0	4,928,741	11/5/2019
0.60.4	11,385	11/4/2019
0.60.3	184,009	10/28/2019
0.60.2	118,287	10/21/2019
0.60.1	3,449	10/20/2019
0.60.0	6,198	10/19/2019
0.59.2	997,433	10/4/2019
0.59.1	12,094	9/30/2019
0.59.0	14,965	9/25/2019
0.58.0	37,961	9/24/2019
0.57.0	2,556	9/23/2019
0.56.0	1,408,010	5/26/2019
0.55.0	8,630	5/24/2019
0.54.0	49,156	5/11/2019
0.53.0	118,746	4/19/2019
0.52.0	122,408	4/11/2019
0.51.1	98,128	3/27/2019
0.51.0	5,495	3/27/2019
0.50.0	26,340	3/18/2019
0.49.3	164,017	1/24/2019
0.49.2	3,024,340	1/16/2019
0.49.0	5,378	1/12/2019
0.48.2	103,548	12/12/2018
0.48.1	5,336	12/10/2018
0.48.0	13,849	12/8/2018
0.47.1	2,382,311	11/4/2018
0.47.0	2,339	11/3/2018
0.46.2	12,198	10/25/2018
0.46.1	63,169	10/16/2018
0.46.0	7,139	10/12/2018
0.45.1	452,982	9/29/2018
0.45.0	26,170	9/13/2018
0.44.1	1,014,077	8/24/2018
0.44.0	6,292	8/21/2018
0.43.0	115,765	7/27/2018
0.42.3	41,387	7/6/2018
0.42.2	65,889	6/30/2018
0.42.1	769,269	6/16/2018
0.42.0	14,093	6/9/2018
0.41.0	2,655	6/8/2018
0.40.4	567,715	5/19/2018
0.40.3	57,171	4/26/2018
0.40.2	20,754	4/19/2018
0.36.0	30,170	2/16/2018
0.35.0	39,530	1/21/2018
0.32.0	704,954	11/24/2017
0.30.0	69,792	10/31/2017
0.29.4	23,254	10/31/2017
0.29.2	55,903	10/26/2017
0.26.5	17,271	9/22/2017
0.26.4	250,736	9/13/2017
0.26.3	2,209	9/13/2017
0.26.2	29,547	9/7/2017
0.26.1	25,349	9/3/2017
0.26.0	23,979	8/25/2017
0.25.1	94,261	8/17/2017
0.25.0	21,736	8/13/2017
0.20.0	2,960	6/1/2017
0.19.5	12,412	5/26/2017
0.19.4	3,716	5/13/2017
0.19.3	2,645	5/11/2017
0.19.2	1,013,071	5/1/2017
0.16.2	18,630	4/2/2017
0.10.0	5,602	12/29/2016
0.9.0	3,147	12/13/2016
0.8.0	3,251	12/7/2016
0.7.3	42,014	11/28/2016
0.6.2	22,595	10/28/2016
0.1.0	12,880	10/4/2016

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

MySqlConnector 2.1.2 Prefix Reserved

About

How to Use

Key Features

Main Types

Related Packages

Feedback

.NETCoreApp 3.1

.NETFramework 4.5

.NETFramework 4.6.1

.NETFramework 4.7.1

.NETStandard 2.0

.NETStandard 2.1

net5.0

net6.0

NuGet packages (310)

GitHub repositories (64)