All Projects β†’ mysql-net β†’ Mysqlconnector

mysql-net / Mysqlconnector

Licence: mit
Async MySQL Connector for .NET and .NET Core

Projects that are alternatives of or similar to Mysqlconnector

Sqlx
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL.
Stars: ✭ 5,039 (+434.93%)
Mutual labels:  async, mysql, mariadb
Mycat2
MySQL Proxy using Java NIO based on Sharding SQL,Calcite ,simple and fast
Stars: ✭ 750 (-20.38%)
Mutual labels:  async, mysql, mariadb
Phpmyadmin
A web interface for MySQL and MariaDB
Stars: ✭ 5,750 (+510.4%)
Mutual labels:  hacktoberfest, mysql, mariadb
Pomelo.entityframeworkcore.mysql
Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnector
Stars: ✭ 2,099 (+122.82%)
Mutual labels:  mysql, mariadb, dotnet-core
Liquibase
Main Liquibase Source
Stars: ✭ 2,910 (+208.92%)
Mutual labels:  hacktoberfest, mysql, mariadb
Dbbench
πŸ‹οΈ dbbench is a simple database benchmarking tool which supports several databases and own scripts
Stars: ✭ 52 (-94.48%)
Mutual labels:  hacktoberfest, mysql, mariadb
Yuniql
Free and open source schema versioning and database migration made natively with .NET Core.
Stars: ✭ 156 (-83.44%)
Mutual labels:  mysql, mariadb, dotnet-core
Mindsdb
Predictive AI layer for existing databases.
Stars: ✭ 4,199 (+345.75%)
Mutual labels:  hacktoberfest, mysql, mariadb
Migrate
Database migrations. CLI and Golang library.
Stars: ✭ 7,712 (+718.68%)
Mutual labels:  hacktoberfest, mysql, mariadb
Sqlancer
Detecting Logic Bugs in DBMS
Stars: ✭ 672 (-28.66%)
Mutual labels:  mysql, mariadb
Vertx Sql Client
High performance reactive SQL Client written in Java
Stars: ✭ 690 (-26.75%)
Mutual labels:  async, mysql
Tidb
TiDB is an open source distributed HTAP database compatible with the MySQL protocol
Stars: ✭ 29,871 (+3071.02%)
Mutual labels:  hacktoberfest, mysql
Practical Aspnetcore
Practical samples of ASP.NET Core 2.1, 2.2, 3.1, 5.0 and 6.0 projects you can use. Readme contains explanations on all projects.
Stars: ✭ 6,199 (+558.07%)
Mutual labels:  hacktoberfest, dotnet-core
Sequelize
An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js
Stars: ✭ 25,422 (+2598.73%)
Mutual labels:  mysql, mariadb
Dbshield
Database firewall written in Go
Stars: ✭ 620 (-34.18%)
Mutual labels:  mysql, mariadb
Lucid
AdonisJS official SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more
Stars: ✭ 613 (-34.93%)
Mutual labels:  hacktoberfest, mysql
Prologue
Prologue is an elegant web framework written in Nim.
Stars: ✭ 700 (-25.69%)
Mutual labels:  hacktoberfest, async
Nopcommerce
The most popular open-source eCommerce shopping cart solution based on ASP.NET Core
Stars: ✭ 6,827 (+624.73%)
Mutual labels:  mysql, dotnet-core
Mybb
MyBB is a free and open source forum software.
Stars: ✭ 750 (-20.38%)
Mutual labels:  hacktoberfest, mysql
Ansible Role Mysql
Ansible Role - MySQL
Stars: ✭ 826 (-12.31%)
Mutual labels:  mysql, mariadb

Async MySQL Connector for .NET and .NET Core

This is an ADO.NET data provider for MySQL. It provides implementations of DbConnection, DbCommand, DbDataReader, DbTransactionβ€”the classes needed to query and update databases from managed code.

Complete documentation is available at the MySqlConnector Documentation Website.

Why Use This Library?

Async Support

This library implements true asynchronous I/O for database operations, without blocking (or using Task.Run to run synchronous methods on a background thread). This greatly improves the throughput of a web server that performs database operations.

Performance

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

Benchmark 1 Benchmark 2

(Client: MySqlConnector 0.44.0, Windows 10 x64; Server: MySQL Server 5.6.21, Unix)

Bug Fixes

This library fixes dozens of outstanding bugs in Connector/NET.

License

This library is MIT-licensed and may be freely distributed with commercial software. Commercial software that uses Connector/NET may have to purchase a commercial license from Oracle.

ORMs

This library is compatible with popular .NET ORMs including:

For Entity Framework support, use:

Build Status

Appveyor Azure Pipelines NuGet
AppVeyor Azure Pipelines NuGet

Building

Install the latest .NET Core.

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

dotnet restore
dotnet test tests\MySqlConnector.Tests

To run the side-by-side tests, see the instructions.

Goals

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 the MySQL Protocol, not based on Connector/NET.

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

License

This library is licensed under the MIT License.

Contributing

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

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].