dotConnect for MySQL

by Devart (formerly Core Lab) - Product Type: Component / .NET Class / .NET Compact Framework / 100% Managed Code

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 5.0 and returning result sets from stored procedures.

Our regular prices are shown below. Please logon to see your discounted prices.

dotConnect for MySQL Data Provider V5.0 - Standard

Add to Cart	￦ 141,700	1 Developer License - with 1 Year Subscription		Download (3.2 MB)
Add to Cart	￦ 70,800	1 Developer License - Upgrade from Standard V3.x	Verify	Download (3.2 MB)
Add to Cart	￦ 637,900	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription		Download (3.2 MB)

dotConnect for MySQL Data Provider V5.0 - Professional

Add to Cart	￦ 255,100	1 Developer License - with 1 Year Subscription		Download (7.3 MB)
Add to Cart	￦ 99,200	1 Developer License - Upgrade from Professional V3.x	Verify	Download (7.3 MB)
Add to Cart	￦ 1,134,000	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription		Download (7.3 MB)

dotConnect for MySQL Data Provider V5.0 - Mobile

Add to Cart	￦ 212,600	1 Developer License - with 1 Year Subscription		Download (3.3 MB)
Add to Cart	￦ 99,200	1 Developer License - Upgrade from Mobile V3.x	Verify	Download (3.3 MB)
Add to Cart	￦ 921,400	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription		Download (3.3 MB)

dotConnect for MySQL Data Provider Standard Subscription Renewal

Add to Cart	￦ 70,800	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	￦ 311,800	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

dotConnect for MySQL Data Provider Professional Subscription Renewals

Add to Cart	￦ 99,200	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	￦ 425,200	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

dotConnect for MySQL Data Provider Mobile Subscription Renewals

Add to Cart	￦ 99,200	1 Developer License Subscription Renewal	Verify	Download (29 KB)
Add to Cart	￦ 425,200	1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal	Verify	Download (29 KB)

Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed above including volume licensing and previous versions.

Our regular prices are shown above. Please logon to see your discounted prices.

What's new in dotConnect for MySQL V5.0?

MyDirect .NET renamed to dotConnect for MySQL
Supported LINQ to MySQL
Added Entity Developer for LINQ to MySQL

What's new in dotConnect for MySQL V4.8x? - This version adds support for dbForge Fusion for MySQL 3.00 (formerly known as MyDeveloper Tools) and improves support for ADO.NET Entity Framework.

What's new in dotConnect for MySQL V4.7x?

Added DB server-based data paging for web applications
MySqlDataSource design time improvements
ASP.NET demo pack added
DotNetNuke 4.7 support added
Added support for CLIENT_INTERACTIVE connection option
MySqlSelectStatement.TryParse method added
DataLink.DataSource property can refer to another DataLink com

What’s new in V4.x?

Application development enhancement

Added DataSet Manager to control dataset instances in the project
Added DataSet Editor for convenient datasets manipulation
New MySqlDataSet class to use with MySqlDataTable
New component DataLink added for flexible data binding
New capabilities added to MySqlDataTable class
Added capability for cross-form components cooperation
Design time visualization extended
Supported addin, DataSet Wizard, and MySQL Developer Tools integration with Borland Developer Studio

.NET 2 features

Added MySqlDependency class to support Database Change Notification
Added MySqlDataSourceEnumerator class to support Server Enumeration feature
Added support for Batch Update in MySqlDataAdapter
Added support for returning provider-specific types in MySqlDataReader and MySqlDataAdapter
SQL Server 2005 Business Intelligence Solutions supported
Added data provider and set of data access modules for DotNetNuke
Added MySqlSelectStatement class for building SELECT statements
Added MySqlDecimal class to represent MySQL DECIMAL type
Added MySqlBinaryString class to represent BINARY and VARBINARY type
Added list of hosts in connection form and connection properties
Added MySqlLoader.LoadTable() method
Base level classes moved to the new assembly CoreLab.Data.dll
New demo projects added
Added DbLoader class that serves to load external data into database
Added MySQLDirect .NET information to Visual Studio 2005 splash screen and About box

dotConnect for MySQL 3.55.18 new feature:

Windows Vista support added

dotConnect for MySQL V3.50.10 new features:

Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource
Mono support added
ASP.NET 2.0 providers added: Membership Provider, Role provider, Session State Provider, Profile provider
Dataset Wizard added
Enterprise Library Data Access Application Block support added
OUT and INOUT parameters in stored procedures supported
Borland Delphi 2006 support added
Added support for stored procedures in FetchAll=true and Prepared modes
Provider invariant name changed
Added streaming support for MySqlScript
Added list of Frequently Asked Questions
MySQL Developer Tools installation separated from MySQLDirect .NET Professional installation
MySQLDirect .NET Professional is now compatible with version 1.70 of MySQL Developer Tools
Capability to call MySQLDirect .NET runtime assemblies by partially trusted code added
Licensing enhanced for applications that use DbProviderFactory
Migration wizard design enhanced

Editions: dotConnect for MySQL has three editions: Professional, Standard and Mobile. Standard edition includes ADO.NET core classes and classes for native data types only. Professional edition includes additional classes, design-time extensions and wizards. Mobile is for the .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

dotConnect for MySQL supports MySQL server version 5.0, 4.1, 4.0 and 3.23. The provider works with .NET Framework 1.0, 1.1, 2.0 and .NET Compact Framework, and can be used with the following development environments: