dotConnect for MySQL - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

dotConnect for MySQL by Devart

URLs: dotonnect-for-mysql, dotonnect for mysql, dotonnectformysql, devart

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

What's new in dotConnect for MySQL V7.2?

Visual Studio 2012 support added.

What's new in dotConnect for MySQL V6.80?

Visual Studio 11 Beta support

What's new in dotConnect for MySQL V6.50?

Fluent Mapping support added

The bug inserting a TPT 'child' entity in case its primary key column names differ from the 'parent' entity ones is fixed

The bug deleting dependent entities when other changes were made is fixed

The bug entity materialization for queries with multiple eager loading options is fixed

The bug saving (inserting or updating) System.Data.Linq.Binary objects is fixed

The bug creating foreign keys in SQLite databases on DataContext.CreateDatabase is fixed

Support for enumerated types ("enums") in LinqConnect and Entity Framework June 2011 CTP models is implemented

New skins to improve the apllication appearance implemented

Selection driven highlighting implemented

Capability for changing the shape color for entities, complex types and enums mplemented

Capability for selecting the diagram skin type implemented

Changed behaviour: when the FirstLetterUpperCase / FirstLetterLowerCase option is enabled in Naming rules, each letter after underscore will be capital/lower

The bug saving custom attribute properties with default values in .edml files is fixed

The bug changing property names ("Index was outside the bounds of the array") is fixed

The bug incorrect generation of the private variables names in Entity Framework models is fixed

What's new in dotConnect for MySQL V6.30?

A DbTransactionBase class added

TransactionStateChanging and TransactionStateChanged events added to the DbConnectionBase class

Implemented GetUInt16(), GetUInt32(), GetUInt64(), and GetSByte() methods of the MySqlDataReader class

Policy file for the Devart.Data.MySql.Entity assembly added

License Information Wizard improved: it now generates licenses for projects that have Entity Framework models or refer to Devart.Data.MySql.Web, but have no direct references to Devart.Data.MySql.dll

"Use schema name" checkbox added to the DataSet Wizard

Bug fix: Membership provider compatibility between .NET Framework 2.0 and 4.0

Bug fix: Launching Devart documentation via Start menu

Bug fix: "Bad handshake" exception when connecting to MySQL servers v 5.1.57 and 5.5.12

What's new in dotConnect for MySQL V6.10?

Added DDEX support in Express Edition

Fixed bug with resetting CopyLocal property of Devart references to False after using Upgrade Wizard

Fixed bug with unicode characters when using Upgrade Wizard

Fixed bug with compatibility with Microsoft Team Foundation Server 2010 Power Tools (broken designers for WPF, Silverlight, etc)

Fixed Visual Studio integration conflict with Windows Phone Developer Tools

Fixed bug with generating commands by MySqlCommandBuilder on Mono

LinqConnect (formerly known as LINQ to MySQL)

Fixed bug with deserializing LinqConnect exceptions

Fixed bug with creating auto-incremented columns with the DataContext.CreateDatabase method

Fixed bug with attaching entities as modified to DataContext

Entity Developer

Added sorting in the 'Return Type' ComboBox for methods in the Properties window

Fixed code generation for many-to-many associations when the Unidirectional serialization mode is enabled (LinqConnect models)

Fixed some bugs in Table Per Concrete Type (TPC) design time support in Entity Framework models

Fixed bug with wrong Metadata Artifact Processing setting for Web Site projects in Entity Framework models

Fixed bug with the Update From Database Wizard showing no changes when connecting under a user account with limited privileges

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

Added the 'Validate Connection' connection string parameter to validate a connection from a pool

Fixed bug with WebSite projects in Delphi Prism

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

Supports password salt in ASP.NET membership provider

Supports keyboard-interactive SSH protocol authentication

Improved Upgrade wizard

Fixed bug with Upgrade Wizard on web sites

Fixed bug with disposing data table with InterForm ParentRelation

Fixed bug with lost InterForm connection

Fixed bug with filling DevExpress ASPxGridView in Auto DataPagingMode of MySqlDataSource

Fixed bug with hashed passwords in Membership provider

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

Supports Visual Studio 2010

Install Wizard improved (ability to automatically uninstall previous version added)

ADO.NET Data Services v1.5 CTP2 supported

Supported geometry types via Well-Known Binary (WKB) format

Added MySqlConnection.ClearAllPools(bool force) method

Added support for SSH known_hosts file

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

Integration with improved dbMonitor added

Added orderid column for Site Map provider for custom map node ordering

Added some DataSet Wizard design-time improvements

Tiny As Boolean parameter added to connection string

Fixed bug with MembershipProvider.GetAllUsers() method

Fixed bug with DataLink.DataSource property after regeneration of DataSet

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

Charset property now supported

PingInterval property for connection maintaining now supported

Fixed bug with Entity Data Model Wizard in case of ANSI_QUOTES SQL Mode

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

Data provider for direct access to MySQL.

Pricing: dotConnect for MySQL Data Provider V7.2 - Standard 1 Developer License - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Standard 1 Developer License - Upgrade from Standard V3.x - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Standard 4 Developer Team License - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Standard 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Standard 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Standard V3.x - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 1 Developer License - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 1 Developer License - Upgrade from Professional V3.x - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 1 Developer License - Upgrade from Standard - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 1 Developer License - Upgrade from Developer - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 4 Developer Team License - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 4 Developer Team License - Upgrade from Standard - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 4 Developer Team License - Upgrade from Developer - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Professional V3.x - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Standard - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - Upgrade from Developer - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Mobile 1 Developer License - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Mobile 1 Developer License - Upgrade from Mobile V3.x - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Mobile 4 Developer Team License - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Mobile 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Developer 1 Developer License - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Developer 4 Developer Team License - with 1 Year Subscription, dotConnect for MySQL Data Provider V7.2 - Developer 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for MySQL Data Provider Standard Subscription Renewal 1 Developer License Subscription Renewal, dotConnect for MySQL Data Provider Standard Subscription Renewal 4 Developer Team License Subscription Renewal, dotConnect for MySQL Data Provider Standard Subscription Renewal 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal, dotConnect for MySQL Data Provider Professional Subscription Renewals 1 Developer License Subscription Renewal, dotConnect for MySQL Data Provider Professional Subscription Renewals 4

Evals & Downloads: Read the dotConnect for MySQL help file, Read the dotConnect for MySQL License Agreement, Download the dotConnect for MySQL V7.2 evaluation on to your computer - Limited Functionality

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Component

Component Type: .NET Class, .NET Compact Framework, 100% Managed Code

Built Using: Visual C# .NET

Compatible Containers: Microsoft Visual Studio 2012, Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2012, Microsoft Visual Basic 2010, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2012, Microsoft Visual C++ 2010, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2012, Microsoft Visual C# 2010, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Internet Information Server 5.0, Microsoft Internet Information Server 4.0, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, C#Builder, .NET Framework 4.5, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0, ASP.NET Web Matrix, MySQL 5.0

Product Class: Business Components

Keywords: corelab

crlab corelab

Database DB Connectivity

Database DB Management

SQL query language

Part numbers: PC-516026-492888 516026-492888 PC-516026-492898 516026-492898 PC-516026-492926 516026-492926 PC-516026-492894 516026-492894 PC-516026-492928 516026-492928 PC-516026-492890 516026-492890 PC-516026-492900 516026-492900 PC-516026-492936 516026-492936 PC-516026-492942 516026-492942 PC-516026-492932 516026-492932 PC-516026-492938 516026-492938 PC-516026-492944 516026-492944 PC-516026-492896 516026-492896 PC-516026-492934 516026-492934 PC-516026-492940 516026-492940 PC-516026-492946 516026-492946 PC-516026-492892 516026-492892 PC-516026-492902 516026-492902 PC-516026-492954 516026-492954 PC-516026-492904 516026-492904 PC-516026-492918 516026-492918 PC-516026-492950 516026-492950 PC-516026-492920 516026-492920 PC-516026-492906 516026-492906 PC-516026-492930 516026-492930 PC-516026-492908 516026-492908 PC-516026-492910 516026-492910 PC-516026-492948 516026-492948 PC-516026-492912 516026-492912 PC-516026-492914 516026-492914 PC-516026-492956 516026-492956 PC-516026-492916 516026-492916 PC-516026-492922 516026-492922 PC-516026-492952 516026-492952 PC-516026-492924 516026-492924