Devart.Data.MySql
9.3.104
Prefix Reserved
dotnet add package Devart.Data.MySql --version 9.3.104
NuGet\Install-Package Devart.Data.MySql -Version 9.3.104
<PackageReference Include="Devart.Data.MySql" Version="9.3.104" />
paket add Devart.Data.MySql --version 9.3.104
#r "nuget: Devart.Data.MySql, 9.3.104"
// Install Devart.Data.MySql as a Cake Addin #addin nuget:?package=Devart.Data.MySql&version=9.3.104 // Install Devart.Data.MySql as a Cake Tool #tool nuget:?package=Devart.Data.MySql&version=9.3.104
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 4.6+, .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 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.
To activate your license, please download dotConnect for MySQL from our website.
Compatibility
The following table show which version of this package to use with which version of frameworks.
Frameworks | Version support |
---|---|
.NET | 8, 7, 6, 5 |
.NET Core | 3, 2, 1 |
.NET Framework | 4.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 = "User Id=root;Password=mypassword;Host=127.0.0.1;Port=3306;";
ASP.NET Core and Blazor
Configuration File Snippet (appsettings.json):
{
"ConnectionStrings": {
"DefaultConnection": "User Id=root;Password=mypassword;Host=127.0.0.1;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.
Related Packages
License
dotConnect for MySQL is available in several editions. See pricing options for ordering.
Support Area
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp1.0 was computed. netcoreapp1.1 was computed. netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard1.3 is compatible. netstandard1.4 was computed. netstandard1.5 was computed. netstandard1.6 was computed. netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen30 was computed. tizen40 was computed. tizen60 was computed. |
Universal Windows Platform | uap was computed. uap10.0 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 1.3
- Devart.Data (>= 6.0.104)
- Microsoft.Extensions.PlatformAbstractions (>= 1.1.0)
- Microsoft.NETCore.Portable.Compatibility (>= 1.0.1)
- Microsoft.Win32.Registry (>= 4.3.0)
- NETStandard.Library (>= 1.6.1)
- System.ComponentModel (>= 4.3.0)
- System.ComponentModel.Annotations (>= 4.3.0)
- System.ComponentModel.Primitives (>= 4.3.0)
- System.ComponentModel.TypeConverter (>= 4.3.0)
- System.Diagnostics.FileVersionInfo (>= 4.3.0)
- System.Net.NameResolution (>= 4.3.0)
- System.Net.Primitives (>= 4.3.0)
- System.Net.Requests (>= 4.3.0)
- System.Reflection (>= 4.3.0)
- System.Runtime.InteropServices.RuntimeInformation (>= 4.3.0)
- System.Security.Cryptography.Algorithms (>= 4.3.0)
- System.Security.Cryptography.Csp (>= 4.3.0)
- System.Threading.ThreadPool (>= 4.3.0)
- System.Xml.XmlDocument (>= 4.3.0)
-
.NETStandard 2.0
- Devart.Data (>= 6.0.104)
- System.Diagnostics.PerformanceCounter (>= 4.5.0)
NuGet packages (10)
Showing the top 5 NuGet packages that depend on Devart.Data.MySql:
Package | Downloads |
---|---|
Devart.Data.MySql.EFCore
ADO.NET data provider with advanced ORM support, such as Entity Framework and EF Core for MySQL, MariaDB, Amazon RDS, Amazon Aurora, Azure for MySQL, Percona. |
|
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. Besides, this installer generates the trial key files required for using this package on a trial basis. You can download it at www.devart.com. |
|
GenerativeObjects.Practices
Common utilities for Generative Objects applications |
|
Devart.Data.MySql.EF6
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 EF Core, and offers a complete solution for developing DB-related applications and web sites. |
|
NewenNetworks.Database.MySql
NewenNetworks Standard SDK |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
9.3.104 | 1,199 | 11/8/2024 |
9.3.21 | 4,039 | 6/6/2024 |
9.3.20 | 988 | 5/30/2024 |
9.3.10 | 8,545 | 1/18/2024 |
9.2.0 | 9,765 | 11/17/2023 |
9.1.151 | 21,673 | 6/7/2023 |
9.1.134 | 27,109 | 3/4/2023 |
9.0.0 | 159,266 | 7/1/2022 |
8.21.2066 | 132,736 | 1/26/2022 |
8.20.2042 | 79,196 | 12/21/2021 |
8.19.2014 | 10,098 | 11/9/2021 |
8.19.2001 | 101,887 | 10/21/2021 |
8.19.1985 | 6,087 | 9/28/2021 |
8.19.1944 | 75,312 | 7/30/2021 |
8.19.1930 | 42,099 | 7/8/2021 |
8.19.1905 | 108,976 | 6/3/2021 |
8.19.1866 | 103,185 | 4/9/2021 |
8.19.1860 | 7,155 | 4/1/2021 |
8.19.1836 | 9,317 | 2/18/2021 |
8.19.1812 | 13,401 | 1/14/2021 |
8.19.1792 | 9,350 | 12/17/2020 |
8.19.1782 | 7,633 | 12/3/2020 |
8.18.1759 | 37,950 | 10/29/2020 |
8.18.1739 | 13,882 | 10/1/2020 |
8.18.1730 | 7,912 | 9/17/2020 |
8.17.1696 | 9,609 | 7/30/2020 |
8.17.1686 | 8,722 | 7/16/2020 |
8.17.1666 | 8,132 | 6/17/2020 |
8.17.1612 | 46,957 | 4/2/2020 |
8.17.1583 | 32,790 | 2/20/2020 |
8.16.1541 | 11,024 | 12/23/2019 |
8.15.1519 | 103,583 | 11/21/2019 |
8.15.1504 | 8,067 | 10/31/2019 |
8.15.1499 | 5,422 | 10/24/2019 |
8.14.1470 | 7,134 | 9/13/2019 |
8.13.1437 | 9,765 | 7/25/2019 |
8.13.1422 | 97,993 | 7/4/2019 |
8.13.1402 | 8,898 | 6/6/2019 |
8.13.1366 | 42,232 | 4/12/2019 |
8.12.1357 | 6,576 | 3/28/2019 |
8.12.1328 | 8,651 | 2/14/2019 |
8.12.1307 | 12,975 | 1/10/2019 |
8.12.1278 | 7,412 | 11/29/2018 |
8.12.1253 | 12,707 | 10/25/2018 |
8.12.1229 | 14,432 | 9/20/2018 |
8.12.1216 | 5,850 | 8/31/2018 |
8.12.1202 | 7,778 | 8/10/2018 |
8.12.1190 | 9,905 | 7/19/2018 |
8.11.1172 | 6,381 | 6/22/2018 |
8.10.1152 | 6,214 | 5/25/2018 |
8.10.1134 | 6,218 | 4/27/2018 |
8.10.1115 | 6,235 | 3/30/2018 |
8.10.1086 | 6,792 | 2/15/2018 |
8.10.1061 | 7,947 | 1/11/2018 |
8.10.1031 | 5,864 | 11/23/2017 |
8.10.1013 | 5,527 | 10/30/2017 |
8.9.980 | 6,899 | 9/7/2017 |
8.9.958 | 6,747 | 8/4/2017 |
8.9.946 | 5,568 | 7/14/2017 |
8.9.931 | 5,442 | 6/23/2017 |
8.9.912 | 22,048 | 5/25/2017 |