.NET Connector for MySQL Database with ORM Support

Q: How to Install dotConnect for MySQL?

Devart dotConnect for Oracle supports the Direct Mode, which enables the user's applications to work with Oracle diractly via TCP/IP, avoiding usage of Oracle Client alltogether.

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.

With 17 years of development history, dotConnect for MySQL provides an ultimate pack of robust data connectivity features and already empowers thousands of data-related .NET apps.

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.

Advanced Visual Studio Integration with MySQL

ADO.NET Provider with .NET Core and Entity Framework Support

dotConnect for MySQL was the first MySQL database provider to support .NET Core and Entity Framework Core, and we work hard to support new platforms and development technologies as soon as they are released.

MySQL support: from 3.23 to 8.0, Percona, and MariaDB (version 11, 10, 5)
Visual Studio support: 2008 – 2022
Platforms support:
- .NET 5.0, 6.0, 7.0 compatibility
- macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support
- Windows 11 is supported
- Full .NET Framework 2.0 – 4.8
- .NET Core 1.x, 2.x, and 3.0
- .NET Compact Framework 2.0 and above
- Mono 2.0 and above

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, and 7.0
NHibernate
LinqConnect
Dapper

Other .NET Connectors for Databases

dotConnect for MySQL Provider 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.

BIS

Enables Integration Services to export and import data to/from MySQL servers.

Monitoring

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

Security

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

What our customers say

More testimonials Your testimonials

I tried a trial version and looks fantastic - by the way keep up the good work. The great thing is that it is simple and easy to implement and with samples of code it is a pure beauty.

Zahir Virani

LinqConnect and dotConnect for MySQL is simply awesome and mindblowing. I use LINQ a lot with MSSQL, but now with dotConnect and LinqConnect for MySQL, I see no difference in performance or coding. Its quick as a snap and truly love it! I don't think there is a better product in market for using LINQ with MySQL. Thanks Devart!!!

Chetan A. Sharma

I currently use dotConnect for MySQL and I've been very happy with the tool.

Dave Caplan

President, Auction Software Systems

Frequently Asked Questions

What is the best way to connect MySQL with .NET/C#?

You need to assign a valid connection string to mySqlConnection1 beforehand, and then use the mySqlConnection1.Open(); command to open a connection.

How to Install dotConnect for MySQL?

You can install dotConnect for MySQL using a single setup package that contains all files for full .NET Framework functionality and documentation

Are there any demo projects to try MySQL Connector?

Devart dotConnect for MySQL comes with demo projects: general samples. General Samples are demos, that demonstrate working with MySQL classes, components, and technologies.