dotConnect for MySQL & MariaDB

.NET Connector for MySQL, MariaDB, Amazon RDS, Amazon Aurora, Azure MySQL, Percona with ORM Support

dotConnect for MySQL is a high-performance ORM enabled data provider for MySQL that builds on ADO.NET technology to present a complete solution for developing MySQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and facilitates the development of database applications.

Our ADO.NET MySQL provider supports a wide range of MySQL-specific features, such as secure SSL and SSH connections, embedded server, compression protocol, HTTP tunneling and others.

Features

Direct Mode

Allows your application to work with MySQL directly, without involving MySQL client library.

ASP.NET

Implements Role, Session State, Membership, Profile, Site Map, and other ASP 2.0 providers.

Performance

Uses many MySQL-specific performance features & optimizations to ensure the highest performance.

Monitoring

Allows per-component tracing of database events with a free dbMonitor application.

Security

Supports various encryption ciphers, SSL and SSH connections, etc.

Full list of features

Compatibility

The following table show which version of this package to use with which version of frameworks.

Frameworks	Version support
Entity Framework Core	8, 7, 6, 5, 3, 2, 1
.NET	8, 7, 6, 5
.NET Core	3, 2, 1
.NET Framework	4.8, 4.7, 4.6, 4.5

More information here

Usage

To establish a connection to server you have to provide some connection parameters to dotConnect for MySQL. This information is used by the MySqlConnection component to find the server and login with credentials of your account. The parameters are represented as connection string. You can compose the connection string manually or have dotConnect for MySQL construct it for you.

This snippet directly configures a MySQL connection using a connection string.

using Devart.Data.MySql;
...
MySqlConnection mySqlConnection = new MySqlConnection();
mySqlConnection.Host = "127.0.0.1";
mySqlConnection.Port = 3306;
mySqlConnection.UserId = "root";
mySqlConnection.Password = "mypassword";

Read the full documentation for connection here.

Enhanced ORM Support

dotConnect for MySQL offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our MySQL ADO.NET Provider supports the following ORMs:

Entity Framework v1 - v6
Entity Framework Core 1.x, 2.x, 3.x, 5.0, 6.0, 7.0, and 8.0
NHibernate
Dapper

Advanced Visual Studio Integration with MySQL

dotConnect for MySQL provides a vast number of GUI tools that increase your productivity. For example, it includes DataSet tools, such as DataSet Wizard, DataSet Editor, DataSet Manager, provide you an easy way to create and edit typed and untyped DataSets.

MySQL ADO.NET Provider supports advanced Visual Studio integration (DDEX) and provides convenient visual component editors to simplify component tweaking.

License

See pricing options for ordering.

Trial Limitations

The dotConnect for MySQL Evaluation License lets you try dotConnect for MySQL Trial Edition for a period of 30 days. You may not use applications developed using Trial versions of the Software for any commercial purposes.

Support Area

Devart Software