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?

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 altogether.

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.

dotConnect for MySQL

.NET 10 available

PM> Install-Package Devart.Data.MySql

Supported Platforms

See in action

.NET Connector for MySQL and MariaDB With ORM Support

dotConnect for MySQL is a versatile enterprise-grade connector that enables access to MySQL/MariaDB data in .NET applications of any complexity. It delivers advanced ORM support, compatibility with multiple database server versions and .NET platforms, and easy integration with a variety of IDEs, including Visual Studio.

The connector undergoes regular security and performance testing to ensure reliability and consistent quality. It also includes premium support, frequent updates, and detailed documentation to help you get started quickly.

Advanced ORM support: EF Core, Dapper, NHibernate, LinqConnect, and more
Full compliance with ADO.NET standards
Secure SSL/SSH connections, proxy servers, embedded servers, and HTTP tunneling
Advanced encryption and data integrity
Maximum performance via pagination and selective loading
Comprehensive support for MySQL-specific data types
Integration with Visual Studio and design-time support

Trouble-free connection to MySQL

dotConnect for MySQL allows you to connect to MySQL and MariaDB databases via TCP/IP with no need for native clients, thus significantly simplifying application development and deployment.

C# Copy code

using Devart.Data.MySql;

class Program
{
  static void Main()
  {
    using MySqlConnection conn = new(
      "Host=127.0.0.1;" +
      "User Id=TestUser;" +
      "Password=TestPassword;" +
      "Database=Sakila;" +
      "License Key=your_license_key");
    conn.Open();
  }
}

Easy connection without any client libraries
Full support for MySQL-specific data types
Robust security features with advanced encryption and authentication
Flexible connectivity options for diverse operational environments
Cost-effective deployment

Access to the following databases and cloud services:

MySQL
MariaDB
Azure Database for MySQL

Amazon RDS for MySQL
Amazon Aurora
Google Cloud SQL for MySQL

Connection details

Advanced ORM support

dotConnect for MySQL offers enhanced ORM support with a bundled Entity Developer – visual designer for ORM models:

Entity Framework Core

1.x, 2.x, 3.x, 5.0, 6.0, 7.0, 8.0, 9.0

NHibernate

1.x-5.x

Entity Framework

v1-v6

Dapper

1.x, 2.x

Using Entity Developer for various ORM technologies enables automatic creation of entity classes and the DbContext class, simplifying the development and ensuring that the data model remains in sync with the database.

Explore the features

Maximum speed and reliability

dotConnect for MySQL facilitates .NET development with background data fetching, thus keeping the application responsive during data loading. Users can fine-tune performance with intelligent data management features like pagination and selective loading. Flexible error handling settings allow for retrieving comprehensive information to troubleshoot and maintain data integrity.

Performance details

Compatibility and integration

Platforms

.NET 5.0, 6.0, 7.0, 8.0, 9.0, 10.0
.NET Framework 2.0-4.8
.NET Core 2.0-3.1

MySQL and MariaDB

All versions

Visual Studio Extension

Data source connection
Database object explorer
Data retrieval and display

Compatibility with NuGet

Works in any NuGet-compatible IDE like VS Code, JetBrains Rider, etc.

Compatibility details

Features

Advanced connection configuration

Dynamically configure MySQL connections using tools such as MySqlConnectionStringBuilder, and enable server discovery and metadata access for flexible and robust database connectivity in .NET applications.

In-memory data management

Manage relational data offline using MySqlDataSet and MySqlDataTable, which support data binding, manipulation, and batch updates for scalable, disconnected MySQL applications.

Bulk data operations and backups

Efficiently import large datasets with MySqlLoader, and create database backups using MySqlDump to streamline data migrations and preserve data integrity in MySQL.

Secure connectivity
and configuration

Protect MySQL connections with SSH, SSL, HTTP tunneling, and encrypted storage to enable robust authentication and data protection for applications.

Event-driven monitoring
and change tracking

Monitor MySQL operations and data changes with MySqlDependency and MySqlMonitor for real-time diagnostics and more responsive applications.

Development wizards
in Visual Studio

Enhance MySQL development with Visual Studio wizards for connections, DataSets, and migrations to boost productivity and simplify database tasks.

View all features

Leading companies choose dotConnect

Other .NET connectors for databases

Your universal ADO.NET provider for multiple database systems

dotConnect Universal

dotConnect Universal offers universal access to data of different databases for the Microsoft .NET Framework. It supports the most popular database servers, including Microsoft SQL Server, Microsoft Access, Oracle Database, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.

$269.95

Developer edition

Buy now

Connect to MySQL in .NET

Explore how to establish a connection between .NET applications and MySQL or MariaDB using ADO.NET.

Connect to MySQL with EF Core

Find out how to connect MySQL and MariaDB databases to your application using EF Core and ADO.NET.

.NET MySQL Connection Strings

Learn how to set up connection strings properly when working with dotConnect for MySQL in .NET applications.

Get started with dotConnect for MySQL at no cost

Download a FREE, fully-functional trial version and elevate your database development and administration today!

Download for free

Try dotConnect Universal

Universal access to data of different databases for the Microsoft .NET Framework. It supports most of the major database servers, including Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird.

Get now

Need a hand?

If you need any help or have questions about our tools or purchasing options, just get in touch with our team.

Contact support

Try the 30-day trial of the full product. No limits. No card required. Start free trial

.NET Connector for MySQL and MariaDB With ORM Support

Trouble-free connection to MySQL

Access to the following databases and cloud services: