dotConnect for MySQL

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

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