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


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


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


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