About dotConnect for MySQL

Data provider for direct access to MySQL.

dotConnect for MySQL is a full-featured 100% managed .NET data provider for direct access to MySQL for .NET Framework and .NET Compact Framework. The provider can access MySQL server using native MySQL network protocol directly or through MySQL client. dotConnect for MySQL provides functionality for connecting to MySQL database, executing commands, and retrieving results. Supports the latest versions of MySQL, all MySQL data types and Embedded server. Offers SSL connection to MySQL server and SSH client forwarding protocol support and provides stored procedures support for MySQL and returning result sets from stored procedures.

The Standard Edition represents a fully-featured ADO.NET data provider with design time support and advanced classes.

The Professional Edition adds more classes, tools, technologies, and integration capabilities.

The Developer Edition combines the whole featureset with dbForge Fusion, an advanced add-in for designing databases and easily manipulating data and schema objects from your IDE.

The Mobile Edition is equivalent to the Standard Edition for .NET Compact Framework.

dotConnect for MySQL is data provider to direct access to MySQL database server for the Microsoft .NET Framework and .NET Compact Framework. It completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology. dotConnect for MySQL data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider. The Data provider can access MySQL server either using native MySQL network protocol directly or through MySQL client library. It allows to create lightweight and fast applications working with MySQL.

dotConnect for MySQL provides functionality for connecting to MySQL database, executing commands, and retrieving results. Those results can be processed directly, or placed in an ADO.NET DataSet for further processing while in a disconnected state. While in the DataSet, data can be exposed to the user, combined with other data from multiple sources, or passed remotely between tiers. Any processing performed on the data while in the DataSet can then be reconciled to MySQL database.

dotConnect for MySQL data provider is designed to be lightweight. It consists of a minimal layer between MySQL database and your code. This extends functionality without sacrificing performance.

Following the main features of the dotConnect for MySQL Data Provider

  • Direct access to MySQL server
  • Doesn't require MySQL client library and uses MySQL protocol directly
  • 100% managed code
  • High performance
  • Easy to deploy
  • Supports the latest versions of MySQL server
  • All MySQL data types support
  • Compact Framework support
  • Stored procedures support
  • Support MySQL Embedded server
  • Connection pooling feature
  • Support multiple query execution
  • Fill DataSet with multiple query
  • MySqlScript component to execute scripts
  • MySqlLoader component for fast loading data
  • Ability to store data in DataReader object
  • Paginal access to query result
  • Named parameters support
  • Ability of monitoring query execution by DBMonitor
  • Advanced design-time editors
  • Integrated MySQL Developer Tools for browsing database schema, manipulate database objects and visual building queries
  • Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
  • Help integrated into Visual Studio .NET
  • Free support for registered users