Repository files navigation

This is anADO.NET dataprovider forMySQL and other compatible servers includingMariaDB.It provides implementations ofDbConnection,DbCommand,DbDataReader,DbTransaction—the classesneeded to query and update databases from managed code.

Complete documentation is available at theMySqlConnector Documentation Website.

This library outperforms MySQL 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)

This library is compatible withmany MySQL-compatible servers, including MySQL 5.5 and newer and MariaDB 10.x and newer.MySql.Dataonly supports MySQL Server.

This libraryfixes dozens of outstanding bugs in Connector/NET.

This library implements the latest ADO.NET APIs, from async (introduced in .NET Framework 4.5), throughDbBatch (.NET 6.0) andDbDataSource (.NET 7.0).

This library isMIT-licensed and may be freely distributed with commercial software.Commercial software that uses Connector/NET may have to purchase acommercial licensefrom Oracle.

This library is compatible with popular .NET ORMs including:

• Dapper (GitHub,NuGet)
• Faithlife.Data (GitHub,NuGet)
• FreeSql (GitHub,NuGet)
• LINQ to DB (GitHub,NuGet) including ClickHouse support
• NHibernate (GitHub,NuGet)
• NReco.Data (GitHub,NuGet)
• Paradigm ORM (GitHub,NuGet)
• RepoDb (GitHub,NuGet)
• ServiceStack.OrmLite (GitHub,NuGet)
• SimpleStack.Orm (GitHub,NuGet)

For Entity Framework support, use:

• Pomelo.EntityFrameworkCore.MySql (GitHub,NuGet)

For ASP.NET Core health checks, use:

• AspNetCore.HealthChecks.MySql (GitHub,NuGet)

Install the latest.NET.

To build and run the tests, clone the repo and execute:

dotnet restoredotnet test tests\MySqlConnector.Tests

To run the integration tests, seethe instructions.

The goals of this project are:

1. .NET Standard support: It must run on the full .NET Framework and all platforms supported by .NET Core.
2. Async: All operations must be truly asynchronous whenever possible.
3. High performance: Avoid unnecessary allocations and copies when reading data.
4. Lightweight: Only the core of ADO.NET is implemented, not EF or Designer types.
5. Managed: Managed code only, no native code.
6. Independent: This is a clean-room reimplementation of theMySQL Protocol, not based on Connector/NET.

Cloning the full API of Connector/NET is not a goal of this project, althoughit will try not to be gratuitously incompatible. For typical scenarios,migrating to this package shouldbe easy.

This library is licensed under theMIT License.

If you'd like to contribute to MySqlConnector, please read ourcontributing guidelines.

Development of MySqlConnector is supported by:

Devolutions

Faithlife (View jobs)