You're Invited:Meet the Socket Team at BlackHat and DEF CON in Las Vegas, Aug 4-6.RSVP
Socket
Book a DemoInstallSign in
Socket

Devart.Data.MySql

Package Overview
Dependencies
Maintainers
1
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

Devart.Data.MySql

dotConnect for MySQL is a high-performance ORM enabled data provider for MySQL 8.0+ including Embedded servers (starting with 4.1), MariaDB, Amazon RDS, Amazon Aurora, Azure MySQL, Percona that builds on ADO.NET technology. The provider works with .NET Frameworks 2.0+, .NET Core 1.0+, .NET 5+. It supports a wide range of MySQL-specific features, such as secure SSL and SSH connections, compression protocol, HTTP tunneling and others. Package provides advanced Visual Studio integration and convenient visual component editors to simplify component tweaking. More information at https://www.devart.com/dotconnect/mysql/ License dotConnect for MySQL is available in several editions https://www.devart.com/dotconnect/mysql/ordering.html The NuGet package initiates a 30-day free trial automatically, so no additional action is required. Key Features * Direct Mode: Allows your application to work with MySQL directly, without involving MySQL client library. * ASP.NET Core: Supports ASP.NET Core Identity. * 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. * Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

9.4.235
nugetNuGet
Version published
Maintainers
1
Created
Source

dotConnect for MySQL

dotConnect for MySQL is a high-performance ORM enabled data provider for MySQL 8.0+ including Embedded servers (starting with 4.1), MariaDB, Amazon RDS, Amazon Aurora, Azure MySQL, Percona that builds on ADO.NET technology.

The provider works with .NET Frameworks 2.0+, .NET Core 1.0+, .NET 5+.

It supports a wide range of MySQL-specific features, such as secure SSL and SSH connections, compression protocol, HTTP tunneling and others. Package provides advanced Visual Studio integration and convenient visual component editors to simplify component tweaking.

More information at dotConnect for MySQL.

Installation

For projects, using general ADO.NET functionality of dotConnect for MySQL, you need to install the Devart.Data.MySql package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.MySql

For projects, using Entity Framework Core 1, 3, 5, 6, 7, 8, 9 with MySQL, install the Devart.Data.MySql.EFCore package.

For projects that require integration with Entity Framework 6.4 (EF6), use the Devart.Data.MySql.EF6 package.

License

dotConnect for MySQL is available in several editions. See pricing options for ordering.

The NuGet package initiates a 30-day free trial automatically, so no additional action is required.

Compatibility

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

FrameworksVersion support
.NET9, 8, 7, 6, 5
.NET Core3, 2, 1
.NET Framework4.8, 4.7, 4.6

More information here

Usage

In this example, a new instance of the MySqlConnection class (part of the Devart.Data.MySql namespace) is created.

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

This snippet simplifies the connection setup by directly assigning a connection string to the ConnectionString property of the MySqlConnection object

сonnection.ConnectionString = "UserId=root;Password=mypassword;Host=127.0.0.1;Port=3306;";

ASP.NET Core and Blazor

Configuration File Snippet (appsettings.json):

{
  "ConnectionStrings": {
    "DefaultConnection": "Host=127.0.0.1;UserId=root;Password=mypassword;Port=3306;"
   }
}

Dependency Injection of IConfiguration:

private readonly IConfiguration configuration;

public YourController(IConfiguration config) 
{
    configuration = config;
}

Retrieving a Connection String:

var connectionString = configuration.GetConnectionString("DefaultConnection");
var connection = new MySqlConnection(connectionString);

For more information about secure connections using SSL or SSH connections read at our documentation.

Key Features

  • Direct Mode: Allows your application to work with MySQL directly, without involving MySQL client library.
  • ASP.NET Core: Supports ASP.NET Core Identity.
  • 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.
  • Support and updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

Support Area

Keywords

MySQL

FAQs

Package last updated on 25 Apr 2025

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts