VOOZH about

URL: https://www.nuget.org/packages/Devart.Data.MySql

⇱ NuGet Gallery | Devart.Data.MySql 10.1.123




👁 Image
Devart.Data.MySql 10.1.123

Prefix Reserved
dotnet add package Devart.Data.MySql --version 10.1.123
 
 
NuGet\Install-Package Devart.Data.MySql -Version 10.1.123
 
 
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Devart.Data.MySql" Version="10.1.123" />
 
 
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Devart.Data.MySql" Version="10.1.123" />
 
Directory.Packages.props
<PackageReference Include="Devart.Data.MySql" />
 
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Devart.Data.MySql --version 10.1.123
 
 
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Devart.Data.MySql, 10.1.123"
 
 
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Devart.Data.MySql@10.1.123
 
 
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Devart.Data.MySql&version=10.1.123
 
Install as a Cake Addin
#tool nuget:?package=Devart.Data.MySql&version=10.1.123
 
Install as a Cake Tool
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

👁 NuGet Version
👁 NuGet Downloads
👁 Windows
👁 macOS
👁 Linux
👁 Docker
👁 Amazon (AWS)
👁 Microsoft Azure

Advanced C# Connection Provider 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, .NET Core, .NET.

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


  1. Install the NuGet Package
Install-Package Devart.Data.MySql
  1. Activate license
  • Free Trial License: Evaluate the full capabilities of dotConnect for MySQL in a non-commercial environment—ideal for development and testing. Start your free trial
  • Commercial License: Deploy dotConnect for MySQL in commercial applications and access full technical support with a valid license. Purchase a license

Work with EF Core and Entity Framework


For projects, using Entity Framework Core 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.

Compatibility


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

Frameworks Version support
.NET 10, 9, 8, 7, 6, 5
.NET Core 3.1, 3.0, 2.2, 2.1, 2.0
.NET Framework 4.8, 4.7, 4.6.2, 4.6.1

More information here

Key Features

  • Enterprise-Grade Security: Secure MySQL/MariaDB connectivity with SSL, SSH, HTTP tunneling, and multiple encryption algorithms. dotConnect for MySQL also follows rigorous security standards in product development, ensuring both secure communication and resilient code.
  • High Performance Data Access: Built-in MySQL-specific optimizations, efficient connection pooling, and fast bulk operations with MySqlLoader ensure low-latency access for high-throughput applications.
  • Full ADO.NET Compatibility: 100% compliant with ADO.NET standards, supporting key interfaces such as DbConnection, DbCommand, DataSet, and DataTable for seamless integration into .NET applications.
  • MySQL Feature Support: Native handling of MySQL-specific data types and commands ensures accurate operation across all major MySQL and MariaDB versions.
  • Broad Platform Compatibility: Fully compatible with .NET Framework, .NET Core, and .NET, supporting everything from legacy enterprise systems to modern cloud-native applications.
  • Disconnected Data Management: Manage relational data offline using MySqlDataSet and MySqlDataTable, with support for batch updates, UI data binding, and local data manipulation.
  • Real-Time Monitoring and Notifications: Track database operations using MySqlMonitor and respond to data changes in real time with MySqlDependency.
  • Visual Studio Integration: Accelerate development with wizards for connection setup, typed DataSet generation, and schema management—all embedded in Visual Studio.
  • Reliable Backups and Migrations: Use MySqlDump for consistent database exports and MySqlLoader for efficient bulk imports during data migrations.
  • Priority Support and Continuous Improvement: Backed by dedicated technical support and regular updates that deliver security enhancements, feature improvements, and long-term stability.

Usage


To help you get started quickly, here's a simple code example demonstrating how to connect to a MySQL database.

using Devart.Data.MySql;

class Program
{
 static void Main()
 {
 string connectionString = "" +
 "Server=127.0.0.1;" +
 "Port=3306;" +
 "UserId=TestUser;" +
 "Password=TestPassword;" +
 "Database=sakila;" +
 "LicenseKey=**********";

 using (MySqlConnection connection = new MySqlConnection(connectionString))
 {
 try
 {
 connection.Open();
 Console.WriteLine("Connection successful!");
 }
 catch (Exception ex)
 {
 Console.WriteLine($"Error: {ex.Message}");
 }
 }
 }
}

Basic Connection Strings

Property Meaning
Host or Server Specifies the hostname or IP address of the server.
Port Specifies the port number on which the server is listening.
User Id Specifies the user ID used to authenticate with the host.
Password Specifies the password for the user ID.
Database Specifies the default database to be used after connecting.
License Key Specify your license key in this parameter.

For more detailed tutorials, API reference, and advanced examples, visit our Getting Started guide.

Related Packages

Support Area

Product Versions Compatible and additional computed target framework versions.
.NET net5.0 net5.0 is compatible.  net5.0-windows net5.0-windows was computed.  net6.0 net6.0 was computed.  net6.0-android net6.0-android was computed.  net6.0-ios net6.0-ios was computed.  net6.0-maccatalyst net6.0-maccatalyst was computed.  net6.0-macos net6.0-macos was computed.  net6.0-tvos net6.0-tvos was computed.  net6.0-windows net6.0-windows was computed.  net7.0 net7.0 was computed.  net7.0-android net7.0-android was computed.  net7.0-ios net7.0-ios was computed.  net7.0-maccatalyst net7.0-maccatalyst was computed.  net7.0-macos net7.0-macos was computed.  net7.0-tvos net7.0-tvos was computed.  net7.0-windows net7.0-windows was computed.  net8.0 net8.0 was computed.  net8.0-android net8.0-android was computed.  net8.0-browser net8.0-browser was computed.  net8.0-ios net8.0-ios was computed.  net8.0-maccatalyst net8.0-maccatalyst was computed.  net8.0-macos net8.0-macos was computed.  net8.0-tvos net8.0-tvos was computed.  net8.0-windows net8.0-windows was computed.  net9.0 net9.0 was computed.  net9.0-android net9.0-android was computed.  net9.0-browser net9.0-browser was computed.  net9.0-ios net9.0-ios was computed.  net9.0-maccatalyst net9.0-maccatalyst was computed.  net9.0-macos net9.0-macos was computed.  net9.0-tvos net9.0-tvos was computed.  net9.0-windows net9.0-windows was computed.  net10.0 net10.0 was computed.  net10.0-android net10.0-android was computed.  net10.0-browser net10.0-browser was computed.  net10.0-ios net10.0-ios was computed.  net10.0-maccatalyst net10.0-maccatalyst was computed.  net10.0-macos net10.0-macos was computed.  net10.0-tvos net10.0-tvos was computed.  net10.0-windows net10.0-windows was computed. 
.NET Core netcoreapp2.0 netcoreapp2.0 was computed.  netcoreapp2.1 netcoreapp2.1 was computed.  netcoreapp2.2 netcoreapp2.2 was computed.  netcoreapp3.0 netcoreapp3.0 was computed.  netcoreapp3.1 netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 netstandard2.0 is compatible.  netstandard2.1 netstandard2.1 was computed. 
.NET Framework net461 net461 was computed.  net462 net462 was computed.  net463 net463 was computed.  net47 net47 was computed.  net471 net471 was computed.  net472 net472 was computed.  net48 net48 was computed.  net481 net481 was computed. 
MonoAndroid monoandroid monoandroid was computed. 
MonoMac monomac monomac was computed. 
MonoTouch monotouch monotouch was computed. 
Tizen tizen40 tizen40 was computed.  tizen60 tizen60 was computed. 
Xamarin.iOS xamarinios xamarinios was computed. 
Xamarin.Mac xamarinmac xamarinmac was computed. 
Xamarin.TVOS xamarintvos xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (10)

Showing the top 5 NuGet packages that depend on Devart.Data.MySql:

Package Downloads
Devart.Data.MySql.EFCore

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 2.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 the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. 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.

Devart.Data.MySql.Linq

dotConnect for MySQL is an enhanced database connectivity solution built over ADO.NET architecture and a development framework with advanced support for ORMs, such as Entity Framework and LinqConnect and offers a complete solution for developing DB-related applications and web sites. It introduces new approaches for designing a data access layer and boosts the productivity of database application development. It is the best alternative to Connector/NET for working with MySQL data. dotConnect for MySQL supports MySQL, including Embedded servers, MariaDB, Percona, and Amazon RDS Aurora. This package contains the .NET Standard/.NET Core compatible assemblies with LinqConnect-related functionality of dotConnect for MySQL. LinqConnect (LINQ to MySQL) is a fast ORM solution, having a LINQ to SQL-compatible interface, but also providing its own advanced features. This package contains only runtime features of dotConnect for MySQL. dotConnect for MySQL is also provided as an installation package (exe), which installs runtime assemblies for Full .NET Framework and a set of design-time tools, integrated into Visual Studio - Server Explorer integration, DataSet tools, Windows Forms components with powerful design-time, etc. It also includes visual ORM designer for Entity Framework, Entity Framework Core, and LinqConnect ORM models. You can download it at www.devart.com. The NuGet package initiates the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial.

Devart.Data.MySql.EF6

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 2.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 the retrieval of an activation key from the Devart website. This key is required to activate the product for a free trial. 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.

GenerativeObjects.Practices

Common utilities for Generative Objects applications

GenerativeObjects.BusinessLayer.HelperClasses

Generative Objects Helpers Library

GitHub repositories (1)

Showing the top 1 popular GitHub repositories that depend on Devart.Data.MySql:

Repository Stars
MightyOrm/Mighty
A new, small, dynamic micro-ORM. Highly compatible with Massive, but with many essential new features.
Version Downloads Last Updated
10.1.123 242 6/17/2026
10.1.100 2,329 5/25/2026
10.1.72 5,685 4/23/2026
10.1.35 9,651 3/6/2026
10.1.33 632 2/24/2026
10.0.0 16,205 12/19/2025
9.4.290 37,121 7/30/2025
9.4.235 5,689 4/25/2025
9.4.193 12,003 2/11/2025
9.4.191 30,169 1/15/2025
9.4.190 2,956 12/27/2024
9.3.104 19,957 11/8/2024
9.3.21 14,541 6/6/2024
9.3.20 3,936 5/30/2024
9.3.10 15,469 1/18/2024
9.2.0 20,989 11/17/2023
9.1.151 34,221 6/7/2023
9.1.134 61,960 3/4/2023
9.0.0 267,480 7/1/2022
8.21.2066 186,578 1/26/2022
Loading failed