dotConnect for MySQL

General usability

Direct access to server data not requiring a MySQL client library
Real RAD for database applications
Fully compliant with ADO.NET
100% managed code
Highly usable design time support
Easy to deploy

Network and connectivity

In Direct mode does not require a MySQL client library and works directly through TCP/IP
Both connected and disconnected data access models
SSL connection to MySQL server
SSH client forwarding protocol
Connection through proxy servers
Connection through HTTP tunnels
Support for compression protocol
Unicode connections
Failover support
Load Balancing support

Compatibility

Full support of the latest versions of MySQL, including Embedded Server, Percona, and MariaDB
Support for both x64 and x86 architecture
Windows, Linux, MacOS support
.NET 6 support
.NET 5 support
.NET Core 3.x, 2.x, and 1.x support
.NET Standard 2.1, 2.0 1.6, 1.5, 1.4, and 1.3 support
.NET Frameworks 4.8, 4.7, 4.6, 4.5, 4.0, 3.5, 2.0 support
.NET Compact Framework support
Mono Framework support
Microsoft Visual Studio 2022, 2019, 2017, 2015, 2013, 2012, 2010, and 2008 support
CodeGear Delphi 2007 support
Embarcadero Delphi Prism support
SQL Server 2008 - 2016 Business Intelligence Solutions support
Sync Framework support

MySQL technology support

All MySQL data types support
Stored procedures support
Returning result sets from stored procedures
View editing
MySqlDump component to store a database or its parts as a script and then restore it
MySqlLoader component for fast data loading
Support for multiple query execution
Fill DataSet with multiple query
Ability to store data in the MySqlDataReader object in the FetchAll mode
Session identifer retrieval for session management

Performance

High overall performance
Intelligent fetch block size control
Advanced connection pooling
High performance batch processing
Support for the prepared statements in the protocol for maximum performance

ADO.NET technology support

Full support for ADO.NET Entity Framework v1 - v6
Entity Framework Core 1.x, 2.x, 3.x, 5.0, and 6.0 support
Server enumeration
Batch update support
Extended metadata information retrieval
Advanced CommandBuilder component with automatic refresh SQL
Enhanced pooling control through connection string
Connection string builder
Provider factory for generating key data access classes
Asynchronous command execution
Provider-specific types support
Password change API
Database Change Notification Support
Possibility to retrieve last auto-incremented value
Retrieval of output parameters from stored procedures and functions

ADO.NET Entity Framework

Conceptual approach to enterprise development
High performance
Wide support for LINQ to Entities
Entity Framework Code First support
Entity Framework Code First Migrations support
Wide support for EntitySQL
Full CRUD (Create, Retrieve, Update, Delete) support
Wide support for server data types
Entity Framework Spatials support
Entity Framework Core Spatials support
Change tracking support
Object data caching
Inheritance mapping support (TPH, TPT, and TPCT models)
Ability to use stored procedures when manipulating data
Stored procedure import support
Ability to build database-independent applications
Full-text search support
Visual Studio EDM Wizard support
Reverse engineering of database objects to entity model
Support for most Entity Framework Canonical Functions
Visual model creation and code generation with Entity Developer
- Update Model From Database functionality for Entity Developer
- Update To Database with Mapping Synchronization functionality for Entity Developer
Illustrated tutorial to get started with Entity Framework in 5 minutes

LinqConnect (formerly known as LINQ to MySQL)

Easy to use
High performance
Interchangeable with Microsoft LINQ to SQL
Plain CLR classes used (no need to use a common base class)
Full CRUD (Create, Retrieve, Update, Delete) support
Ability to execute DML statements in batches on SubmitChanges
Fluent Mapping support
Complex type support
PLINQ support (connection manager redesigned for thread safety)
Support for different configurable algorithms for primary key generation
Inheritance mapping support (Table Per Hierarchy and Table Per Type)
Support of Visual Studio Debugger Visualizer for the DataQuery objects
ASP.NET Dynamic Data support with ASP.NET Dynamic Data project templates
Automatic configurable compiled query caching
Change tracking support
Object data caching
Data binding support
Wide support for LINQ capabilities
Wide support for server data types
Load on demand (lazy load)
Database transactions support
Server-independent interface
Visual model creation and code generation with Entity Developer
- Update Model From Database functionality for Entity Developer
- Update To Database with Mapping Synchronization functionality for Entity Developer
Illustrated tutorial to get started with LinqConnect in 5 minutes

Workflow Foundation Support

Extended data access technologies and functionality

Powerful MySqlDataTable component for manipulating individual tables or query result
NonBlocking mode allows fetching data asynchronously in the background
On-demand data fetch for data-bound controls
Paginal access to query result
Server side master-detail relation based on queries
Ability to refresh individual records in MySqlDataTable component
Support for Enterprise Library Data Access Application Block (DAAB)
Object-oriented building of SELECT statements
Extended warning and error information retrieval
Extended interface for processing execution exceptions
MySqlDataAdapter.Fill method with sequential fetch support
Ability to defer fetching of some columns in a resultset

Business Intelligence Solutions Support

SQL Server Integration Services (SSIS) 2019, 2017, 2016, 2014, 2012, and 2008 support
SSIS DataFlow Source and Destination components
Analysis Services support
Reporting Services support

WinForms-specific features

Flexible data binding with the DataLink component
InterForm technology for cross-form components cooperation
Global position synchronization within a data source

ASP.NET-specific features

ASP.NET Identity 1 and 2 support
ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
ASP.NET SimpleMembership providers support
The MySqlDataSource web component
The MySqlCacheDependency component to control Cache item dependencies in ASP.NET applications

Script execution

Advanced script execution features with the MySqlScript component
Support for executing individual statements in scripts
Support for executing huge scripts stored in files with dynamic loading

SQL execution monitoring

Extended SQL tracing capabilities with MySqlMonitor component
Support for the dbMonitor utility for advanced tracing analysis and control
Per-component SQL tracing
Optional log output to IDE toolwindows

Design-time enhancements

Automatic component registration in the toolbox
Advanced integration with Visual Studio 2008, 2010, 2012, 2013, 2015, 2017, 2019, and 2022, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component MySqlDataSource
DataSet Wizard to create and edit typed MySQL-oriented datasets
DataSet Manager to list and bind datasets in the project
DataSet Editor to edit dataset contents
Advanced design-time component and property editors
IntelliSense descriptions for dotConnect for MySQL classes
Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
Syntax highlighting and SQL code completion in design-time editors
TableMappings editor
Convenient instant data preview and management at design time

dbForge Fusion for MySQL main features

Integration with dotConnect for MySQL for enhanced component designers and drag and drop features
Stored routines and SQL script debugger
SQL code completion and navigation
Visual query builder
Database Explorer
Visual object editors
Database search engine
Code template library
Security Manager
Session Manager
Export/Import Wizards

Product clarity

Complete documentation sets integrated into Visual Studio and CodeGear Delphi
Integration with Visual Studio and MSDN help collections
Documentation available as a standalone chm file
A large amount of helpful demos in C#, VB, C++, and Delphi

Licensing and support

Included annual dotConnect for MySQL Subscription with Priority Support
Licensed royalty-free per developer, per team, or per site