dotConnect for MySQL History

This page lists the functionality added in each version of dotConnect for MySQL. To view the full changelog including bug fixes, consult the dotConnect for MySQL revision history.

12-Aug-10 New features in dotConnect for MySQL 6.00 Beta

Entity Developer

• Added Update Model From Database functionality
• Added multiselect support for properties

21-May-10 New features in dotConnect for MySQL 5.80

• Supported password salt in ASP.NET membership provider
• Implemented capability of extending base functionality of ASP.NET providers
• Supported keyboard-interactive SSH protocol authentication
• Improved Upgrade wizard
• Added support for Enterprise Library 5
• Changed the primary key of the aspnet_sessions table for ASP.NET Web providers (the ApplicationName column added)

LinqConnect (formerly known as LINQ to MySQL)

• LINQ to MySQL support is renamed to LinqConnect
• Added support for Complex type
• Added support for different configurable algorithms for primary key generation
• Automatic configurable compiled query caching supported
• Performance improved
• Added implementation of the ITable interface for the Table class
• Changed DataContext.Log output format for Microsoft compatibility reasons

Entity Developer

• Added possibility of renaming associations in the model

15-Apr-10 New features in dotConnect for MySQL 5.70

• Supported Visual Studio 2010
• Install Wizard improved (ability to automatically uninstall previous version added)
• ADO.NET Data Services v1.5 CTP2 supported
• Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors
• Supported geometry types via Well-Known Binary (WKB) format
• Added MySqlConnection.ClearAllPools(bool force) method
• Added support for SSH known_hosts file

LINQ to MySQL

• Added support for specific dynamic expressions

Entity Framework

• Supported ADO.NET Entity Framework 4
• Support for new Canonical aggregate and scalar functions added
• Ability to use standard DBMS functions in LINQ queries added
• Support for Model First (templates for DB generation) added
• Full support for Entity Data Model Wizard/Update Wizard added
• Added support for methods creating and deleting the database (EF v1 and EF v4)

Entity Developer

• Support for ADO.NET Entity Framework 4 added
• Support for multi-result set methods added
• Improved dialogs for editing model objects
• Full integration with Visual Studio implemented
• Added full support for ModificationFunctionMapping
• Improved Find in Model functionality
• Improved One-To-One associations handling

20-Nov-09 New features in dotConnect for MySQL 5.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

LINQ to MySQL

• Devart DbLinqDataSource added
• Linq performance improved
• Supported navigation using properties (not only keys)

Entity Developer

• New T4 like template engine with powerful editor added
• Updated code generation
  • Ability to generate separate files for classes added
  • Entity Framework Pregenerated Views support added
  • Improved null handling code generation
• Ability to execute LINQ and Entity SQL queries with data and native sql preview added
• Ability to preview and edit data displayed in Database Explorer added
• Table splitting added (emulation of deferred loading for "large" datatypes in EF)
• OnDelete support for associations added

14-Jul-09 New features in dotConnect for MySQL 5.40

• Visual Studio 2010 Beta supported
• The behavior of ConnectionTimeout corrected
• Ability to perform SSH authentication using public key added
• HTTP tunneling improved with the new PHP script
• The LocalFailover property and ConnectionLost event added for processing connection problems
• ASP.NET Web Providers: Added requiresUniqueEmail functionality

LINQ to MySQL

• Added support of the String.IsNullOrEmpty() method

Entity Developer 2.20

• Advanced mapping with Entity Framework QueryView supported
• Displaying of Navigation properties on diagram and project explorer implemented
• Ability to change properties order added
• Ability to edit Referential constraints added
• Ability to set OnDelete action added
• Ability to set Rows Affected parameter added
• Added advanced search on the model
• Added dialogs for suitable storage model editing
• Added support for storing connections in the configuration files
• Added Entity Set Pluralization Naming Rule

28-Apr-09 New features in dotConnect for MySQL 5.20

• The Charset property supported
• The PingInterval property for connection maintaining supported

LINQ to MySQL

• Supported extended errors processing
• Supported DataLoadOptions class and Include method for tuning data loading
• Supported DeferredLoadingEnable functionality
• Supported function import
• Supported stored procedures as insert/update/delete behavior
• Supported user-defined functions in selection part of a query
• Supported CreateDatabase() and DeleteDatabase() methods
• Supported SqlMethods class
• Supported returning new Dictionary from query

Entity Developer 2.00

• Supported Entity Framework
• Supported stored procedures and functions for LINQ to SQL
• Added naming rules for database objects
• Added Visual Studio integration
• Stability and performance improvements
• Validation schema improved
• Entity Framework Complex Type supported
• Entity Framework Storage Model editing supported
• Many-to-Many associations retrieving added
• Usability improvements

13-Nov-08 New features in dotConnect for MySQL 5.00

• MyDirect .NET renamed to dotConnect for MySQL
• Supported LINQ to MySQL
• Added Entity Developer for LINQ to MySQL
• Added free Express Edition with basic connectivity features
• Added Developer Edition, which is equivalent to the Professional Edition plus dbForge Fusion Standard
• Support for .NET Framework 1.x is discontinued
• Renamed assemblies, namespaces, and classes (for information on upgrading your projects please refer to FAQ, section Subscriptions and Upgrades)

Entity Framework support

• Supported data type synonyms CHARACTER VARYING and CHAR BYTE
• NULLs can now be used in typed expressions

20-Aug-08 New features in MyDirect .NET 4.85

• Supported .NET Framework 3.5 Service Pack 1
• Supported Visual Studio 2008 Service Pack 1

11-Aug-08 New features in MyDirect .NET 4.80

• Supported dbForge Fusion for MySQL (formerly known as MyDeveloper Tools)
• Improved ADO.NET Entity Framework support

29-May-08 New features in MyDirect .NET 4.70

• Supported .NET Framework 3.5 Service Pack 1 Beta
• Supported Visual Studio 2008 Service Pack 1 Beta
• Improved support for ADO.NET Entity Framework

26-Feb-08 New features in MyDirect .NET 4.50

• 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 component

20-Dec-07 New features in MyDirect .NET 4.30

• Visual Studio 2008 supported
• Entity Framework Beta 3 supported
• Added Licensing Information dialog

25-Oct-07 New features in MyDirect .NET 4.25

• .NET Entity Framework Beta 2 supported
• Visual Studio 2008 Beta 2 supported
• Added Visual Basic versions to CRM, WinForms, and Web samples

30-Aug-07 New features in MyDirect .NET 4.20

• MySQLDirect .NET renamed to MyDirect .NET
• MySQL Developer Tools renamed to MyDeveloper Tools
• Supported Visual Studio codename Orcas Beta 1
• Supported .NET Entity Framework
• Added support for x64 architecture
• Enhanced command builder with generation of row refresh statements
• Added detailed warning information to MySqlInfoMessageEventArgs class
• Added DbCommand.GetRecordCount() method to determine rows count of a request
• Added INullable interface for provider specific types
• Supported data binding for provider-specific types
• Supported client side validation for huge MySqlDecimal values
• Network communication optimized for better performance
• Added capability to store connection strings in application settings
• Improved integration with MyDeveloper Tools
• Extended drag'n'drop capabilities in DataSet Manager
• Add-in menu moved to Visual Studio package
• Demo projects reorganized
• Added CRM (Customer Relationship Management) demo project
• Added Ping demo project for Mobile Edition

13-Apr-07 New features in MyDirect .NET 4.00

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 MyDeveloper 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

Other features

• 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 MyDirect .NET information to Visual Studio 2005 splash screen and About box

MyDeveloper Tools 2.00 improvements

• Added stored procedure and SQL script debuggers
• Added a project management framework for bookmarking related scripts and organizing database developments
• Enhanced SQL Editor with context-sensitive code completion, code navigation, incremental search, and more
• Enhanced working with data, including possibility to print data directly from data editor
• Added search in object data and stored procedure source code
• Added an extensive collection of SQL and stored routine code templates
• Added fully customizable keyboard mapping schemes
• Completely redesigned Security Manager to control user accounts
• Added a Session Manager for controlling and analyzing user sessions
• Added a Service Manager to find and control MySQL services

12-Dec-06 New features in MyDirect .NET 3.55

• Windows Vista support added

17-Apr-06 New features in MyDirect .NET 3.50

• 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, Profile Provider, Role Provider, Session State 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
• Added streaming support for MySqlScript
• MySQLDeveloper Tools installation separated from MyDirect .NET installation
• Added list of Frequently Asked Questions
• Capability to call MyDirect .NET runtime assemblies by partially trusted code added
• Licensing enhanced for applications that use DbProviderFactory
• Migration wizard design enhanced

13-Dec-05 New features in MyDirect .NET 3.20

• Supported .NET Framework 2.0 release version
• Supported Visual Studio 2005 release version
• Compact .NET Framework 2.0 supported

MyDeveloper Tools improvements (Professional edition only)

• User and privileges management support
• Database export/import to/from SQL script
• Trigger support
• Script support
• Stop execution feature
• Execution of the selected SQL fragment feature
• Data Export feature
• Dynamic data viewing of the tables and views in DbExplorer
• Paginal data access mode
• LOB viewer/editor
• Database object search
• Secure SSL and SSH connections support
• Query plan tool
• Duplicate object feature
• DDL generation wizard
• Embedded server support
• Data grid colors customizing

18-Oct-05 New features in MyDirect .NET 3.05

• DumpMode enumeration added

11-Jul-05 New features in MyDirect .NET 3.00

• SSL connection to MySQL server support added
• SSH client forwarding protocol support added
• Support for compression protocol added
• Returning result sets from stored procedures supported
• View editing supported
• MySqlConnection.Kill method added
• Metadata support extended
• MySQL Embedded server 4.1 support added
• MySqlCommandBuilder.UpdatingFields property added
• MySqlLoader now inherits from DbLoader

20-Apr-05 New features in MyDirect .NET 2.80

• Support for quoting and unquoting names that consist of numbers only or contain quotes added
• Detection of MySqlConnection closing added to MySqlDataReader
• Bug with several same-named columns in MySqlDataReader fixed
• DbTools renamed to MyDeveloper Tools

MyDeveloper Tools improvements (Professional edition only):

• View support added
• Reference key support added
• Data editor improved
• Charset and collation support added for database, table and column
• "Show all databases" option added to connection editor
• Table editor re-designed and extended
• Index editor extended with additional options
• "Primary key" option added to column editor
• Minor changes in stored procedure and UDF editors
• Query timing added to output
• Bug with "Parameter is not correct" message on Visual Studio .NET startup fixed

05-Nov-04 New features in MyDirect .NET 2.70

• Support for .NET Framework 2.0 added with ADO.NET 2 features
• Support for Microsoft Visual Studio .NET 2005 Beta 1
• Support for metadata schemas added
• The Base-Class-Based provider model used
• Connection pooling enhancements functionality added, that allows you to programmatically "drain" the connection pool.
• New MySqlConnectionStringBuilder component to build connection strings to represent data sources
• SQL parameters support added to DbTools
• Stored procedures support for MySQL 5.0.1-alpha added to DbTools
• Syntax highlight and member list features for SQL editors in component designers
• DbTools help is now integrated into Visual Studio IDE
• Context help support added to DbTools

13-Aug-04 New features in MyDirect .NET 2.50

• Design-time tools are completely revised, extended, rewritten in managed code and called DbTools
• Query Builder tool rewritten and improved
• SQL editor tool added
• Support for stored procedures added to DbExplorer
• Ability to drag connections, tables and stored procedures from DbExplorer to Form Designer added
• Component designers more tightly integrated with DbTools
• New component MySqlDataTable added
• New methods for asynchronous working added
• Support for paginal access to query result added
• Performance increased
• Tested with MySQL 4.1.2

07-Jun-04 New features in MyDirect .NET 2.40

• Support for Compact Framework added
• Support for multiple ExecuteReader added
• MySqlDataReader.HasRows property added
• Retrieve InsertId to dataset autoincrement columns added
• Support for connection timeout added
• Support for command timeout added

10-May-04 New features in MyDirect .NET 2.30

• MySQL 5.0 support added
• Stored procedures support added for MySQL 5.0
• Prepared statements supported for MySQL 4.1.1 and MySQL 5.0
• New component MySqlLoader added
• New component MySqlDump added
• Method MySqlConnection.Ping added to validate open connection
• New component MySqlDataSourceControl for extended WebMatrix support added
• C++ sample added

27-Jan-04 New features in MyDirect .NET 2.00

• Access to MySQL server without client library
• MySQL 4.1.1 alpha support added
• DbExplorer tool to explore MySQL database schema
• Support for Named pipe and Shared memory protocol added
• Support for transferred data compression added
• Unicode support added for MySQL 4.1.1
• Native classes MySqlBlob and MySqlText to represent MySQL blob types
• New ConnectionString editor implemented
• Component designers enhanced
• Support for Borland Delphi 8 added
• Support for Microsoft ASP.NET Web Matrix added

23-Sep-03 New features in MyDirect .NET 1.80

• Connection pooling support
• Support for multiple query execution added
• Ability to store data in MySqlDataReader object added
• Migration wizard from ODBC and OLE DB .NET Data Providers
• Support for Borland C#Builder added
• New sample applications added

20-Jun-03 New features in MyDirect .NET 1.60

• Visual Studio .NET 2003 support added
• Support MySQL server version 4.1
• Enabled access to MySQL Embedded server
• ODBC parameter format '?' supported
• MySqlCommand.InsertId property added
• MyDirect .NET help integrated into Visual Studio .NET
• Component properties and events descriptions for "Properties Window" added
• XML documentation for code completion added
• DBMonitor support moved to CoreLab.MySql from CoreLab.DBMonitor assembly

14-Feb-03 New features in MyDirect .NET 1.50

• MySQL 4.0 gamma support
• New MySqlScript component to execute scripts
• New component MySqlMonitor added. Allows to monitor dynamic SQL execution in applications that use MyDirect .NET. Extended monitoring capabilities are provided with DBMonitor application.
• Designer form for MySqlDataAdapter component setup added
• MySqlCommand component designer functionality extended
• Typed dataset generation mechanism enabled for MySqlDataAdapter
• Automatic component registration (in toolbox) mechanism added
• MySQLBuilder tool for visual query building

05-Jul-02 New features in MyDirect .NET 1.20

• Transaction support added
• Support TIMESTAMP data type
• Support TEXT and BLOB data types
• Mapping TIME to System.TimeSpan type

27-May-02 First release of MyDirect .NET 1.00