Wide Coverage of MySQL Features
dotConnect for MySQL allows developers to harness the full capabilities of the MySQL server and optimize their database applications. dotConnect for MySQL stands out as the set of components with the widest support of MySQL functionality.
Flexible Connectivity
dotConnect for MySQL can operate in Direct mode without MySQL client library and in Client mode with usage of libmysql.dll. dotConnect for MySQL utilizes Secure Sockets Layer (SSL) protocol, Secure Shell (SSH) protocol, as well as connections through proxy servers and HTTP tunnels. dotConnect for MySQL supports all MySQL server versions since 3.23, including MySQL Embedded Server.
Optimized Code
The dotConnect for MySQL assemblies are implemented using optimized code and advanced data access algorithms.
Comprehensive Support for ADO.NET Technology Features
dotConnect for MySQL supports new ADO.NET features and technologies as soon as they are released. This includes base-class-based provider model, provider factories, connection string builder, metadata schemas, asynchronous commands, pooling enhancements, batch update support, provider-specific types, server enumeration, database change notification support and so on.
Database Application Development Extensions
dotConnect for MySQL has convenient design time component editors, wizards and managers for typed MySQL-specific components, toolset for live data binding and much more. dotConnect for MySQL integrates tightly with Visual Studio 2008 / 2010 / 2012 / 2013 / 2015 / 2017 / 2019, Visual Studio LightSwitch 2011 and 2012, Delphi, and SQL Server 2016 Business Intelligence Solutions. Last, but not least, there is dbForge Fusion for MySQL to design your database schema and manipulate table data - all within your favorite IDE.
Provider-Specific Technologies
dotConnect for MySQL has extra components designed to simplify some tasks and support MySQL-specific technologies. Particularly, MySqlScript serves to execute series of SQL statements, MySqlLoader serves to load external data into MySQL databases, and MySqlDump serves to backup or restore a whole database or its parts.
Visual Studio 2022 support
dotConnect for MySQL version 9.0 grants full support for Visual Studio 2022 (version 17.2 and version 17.3 Preview). You can use all features of this Microsoft IDE.
LinqConnect
dotConnect for MySQL includes support for LinqConnect (formerly LINQ to MySQL), a fast and easy to use ORM solution, completely compatible with the Microsoft LINQ to SQL technology, while extending it with its own features, such as TPT inheritance support, automatic compiled query caching, and advanced error processing.
ORM Model Designer
dotConnect for MySQL provides its own visual ORM Model Designer for both Entity Framework and LinqConnect models - Entity Developer. It offers you advanced support for Model-First and Database-First design approaches and flexible T4 template-based code generation for the model.
Both Connected and Disconnected Models
dotConnect for MySQL combines connected and disconnected data access models in a single MySqlDataTable component, which allows you to design the more flexible application architecture and use the full power of data binding.
Compatibility
The provider works with .NET Frameworks 2.0, 3.0, 3.5, 4.0, 4.5, 4.6, 4.7 or 4.8, .NET 5, NET 6 and .NET Compact Framework. dotConnect for MySQL supports Mono version 2.0 and above. The product is compatible with ADO.NET Entity Framework v1 - v6.4 and Entity Framework Core 1.x, 2.x, 3.0, 3.1, 5.0, and 6.0 (MySQL server 5.0 or higher is required for Entity Framework).
Additionally, dotConnect for MySQL provides .NET Standard 1.3 compatible assemblies, which are compatible with .NET Core 1.0 and higher and .NET Framework 4.6 and higher, and .NET Standard 2.0 compatible assemblies, compatible with .NET Core 1.x, 2.x and 3.0 and .NET Framework 4.6.1 and higher.
ADO.NET Entity Framework Support
dotConnect for MySQL supports all the Entity Framework versions - Entity Framework v1, v4, v5, and v6 and Entity Framework Core 1.1, 2.2, 3.1, 5.0, and 6.0.
BIS Support
dotConnect for MySQL can be used in SQL Server Business Intelligence Solution (BIS) projects. It provides native Devart MySql Source and Devart MySql Destination components for Data Flows in Integration Services projects and support Reporting Services and Analysis Services projects, including SQL Server 2016 Business Intelligence.
Development Environments
- Visual Studio 2022
- Visual Studio 2019
- Visual Studio 2017
- Visual Studio 2015
- Visual Studio 2013
- Visual Studio 2012
- Visual Studio 2010
- Visual Studio 2008