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

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.

.NET Connector for MySQL and MariaDB with ORM Support

dotConnect for MySQL is a high-performance ADO.NET data provider that grants simple access to MySQL and MariaDB databases when developing MySQL-based applications.

It fully supports Entity Framework (EF Core), Dapper, and NHibernate, along with a wide range of MySQL-specific features, such as secure SSL and SSH connections, embedded servers, compression protocol, HTTP tunneling, and others.

Broad compatibility with various MySQL and MariaDB versions and .NET platforms
ORM support: EF Core, Dapper, NHibernate, LinqConnect, etc.
Full compliance with ADO.NET
SSL, SSH, proxy servers, and HTTP tunnels support
Advanced encryption and data integrity
Integration with Visual Studio and design-time support

Connect to MySQL Worry-Free

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

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

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, and 8.0

NHibernate

1.x-5.x

Entity Framework

V1-v6

Dapper

1.x, 2.x

Learn more

Unlocking the Flexibility of ORM: One Connector to Rule Them All

Harmonize Speed and Reliability

dotConnect for MySQL supercharges the .NET development with seamless fetching of the background data, thus keeping the application responsive while 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

Broad Compatibility

dotConnect for MySQL is the only MySQL/MariaDB provider that supports modern platforms and technologies like .NET Core and Entity Framework Core, as well as multiple deprecated technologies, reducing the existing applications' support costs.

Platforms

.NET 5, 6, 7, 8
.NET Framework 2.0-4.8
.NET Core 1.x, 2.x, and 3.0
.NET Compact Framework 2.0 and higher
Mono 2.0 and higher

MySQL

All versions

MariaDB

All versions

Microsoft Visual Studio

Visual Studio 2008-2022

Features

Database-specific features

dotConnect for MySQL offers broad support for various database-specific features, including different connection modes and protocols, data types, and optimized components for bulk data operations and database script handling.

Advanced durability

The provider grants smooth data manipulation and management, including data fetching control (background, on-demand, pagination) and establishing server-side data relationships. Easy refreshment of specific records and selective column loading will allow for effective performance optimization.

Microsoft technology support

dotConnect for MySQL seamlessly integrates with Microsoft's data-oriented technologies, including Microsoft Enterprise Library, various ASP.NET providers, ExtendedMembership providers, and Microsoft Sync Framework.

Secure Connection

ODBC connections emphasize security through encryption protocols, including SSL and SSH, and enable the use of HTTPS tunneling.

Fast Data Loading

The MySqlLoader component enables users to import large datasets into MySQL databases with exceptional speed and efficiency. This ensures faster application initialization, data population, and overall improved performance during data-intensive operations.

Integration With Visual Studio

dotConnect integrates with Visual Studio for an improved design-time experience, offering features like Server Explorer connections and dataset management tools.

Leading companies choose dotConnect

Other .NET Connectors for Databases

Ready to get started?

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

.NET Connector for MySQL and MariaDB with ORM Support

Connect to MySQL Worry-Free

Advanced ORM Support

Entity Framework Core

NHibernate

Entity Framework

Dapper

Harmonize Speed and Reliability

Broad Compatibility

Platforms

MySQL

MariaDB

Microsoft Visual Studio

Features

Database-specific features

Advanced durability

Microsoft technology support

Secure Connection

Fast Data Loading

Integration With Visual Studio

Leading companies choose dotConnect

Other .NET Connectors for Databases

More articles

Connect to MySQL or MariaDB in .NET applications

Using Entity Framework Core with MySQL or MariaDB

MySQL Connection Strings

Ready to get started?

Get started with dotConnect for MySQL at no cost

Try dotConnect Universal

Need a hand?