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.

04-April-13 New features in dotConnect for MySQL 7.6

The behaviour is changed: provider's build action is installed on the target workstation, on which .NET Framework is available, without Visual Studio integration

LinqConnect (formerly known as LINQ to MySQL)

LINQPad integration is supported
The possibility to disable query cache via the DataContext's 'EntityCachingMode' property is added

Entity Developer

A new MVC Controller template, generating a ASP.NET MVC controller with data access code, is added
A new MVC View Advanced template, generating an ASP.NET MVC view based in Twitter Bootstrap, is added
A new Data Transfer Object template for DTO classes generation is implemented
A new Data Annotation Metadata template, generating Data Annotation metadata classes and decorating classes and properties with data annotation attributes for validation, presentation and defining metadata, is added
A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart Entity Framework model is added
A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart LinqConnect model is added
Add Template dialog box is improved
The Namespace property of class, complex type, enum is implemented
The Entity Container Namespace properties of the model is implemented (Entity Framework models)
The support for enums declared in external assemblies is implemented
The capability for setting special rules for generating default names of database objects when using the Model First approach is implemented (a new Advanced page is added to the Synchronization->Database Naming section of the Model Settings dialog box)
The capability to customize properties that are automatically added when creating a new entity, and options that are automatically set when creating a new property is added (a new Initialization page is added to the Model->General section of the Model Settings dialog box)
The Refresh option in the Attributes tab of the Model Settings window is implemented; it updates the list of available attributes types in the referenced assemblies
The capability to modify custom attributes for several selected entities or properties at the same time is implemented
Automatic adding of references to Entity Framework specific assemblies when adding a new Devart Entity model to a project is implemented
The capability to cancel metadata reading in wizards and Database Explorer is added
The "Recreate Database Tables" check box, which allows to drop and recreate database tables, is added to the "Update To Database" wizard
New setting "Detect Table Per Type inheritances", which enables automatic detection of TPT inheritances, is added for Create Model Wizard and model
The "Include Drop" check box for including DROP commands for database objects to the generated script is added to Generate Database Script Wizard
A new shortcut menu command "Include Related", which allows making a copy of the related objects in the specified diagram, is added
A new shortcut menu command "Add To Model with Related", which allows adding tables, related to the selected one, to the model, is added to the shortcut menu of tables in Database Explorer
A new shortcut menu command "Add On Diagram With Related", which allows creating an object and all the objects related to it on a diagram, is added to the shortcut menu of classes, complex types, and enums in Model Explorer
New "Simple" diagram skin is added for displaying a diagram in metro style
The "Default Width" diagram property for specifying the default width for newly created diagram shapes (entities, complex types and enums) is added
The Save and Refresh buttons for persisting and reloading changes to / from a database is added to the Retrieve Data grid
DbContext template is improved: a "WCF Data Contract Attributes" setting for generation of DataContract, KnownType, and DataMember attributes for classes and properties is added (Entity Framework models)
DbContext template is improved: "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged" template settings are added (Entity Framework models)
DbContext template is improved: a new "Mapping Generation Strategy" property that determines the method of mapping generation is implemented (Entity Framework models)
POCO template is improved: a new "WCF Data Contract Attributes" setting for generating DataContract, KnownType, and DataMember attributes for classes and properties is added (Entity Framework models)
POCO template is improved: "Proxy Creation Enabled" setting is implemented (Entity Framework models)
POCO template is improved: new template settings, "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged", are added (Entity Framework models)
POCO Entity template is improved: new template setting, "Property Change Notifiers", is added (LinqConnect models)
Create Model Wizard is improved: it is now able to download and install the required 'EnityFramework' Nuget package for Entity Framework 6 models, and for models for Entity Framework 4 and 5 in case they use the DbContext template
The Storage Column Editor dialog box is improved: the possibility to specify different settings that were previously available only in the Properties docking window are implemented (Entity Framework models)
Class Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
Type Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
The "Rewrite connection string during regeneration" check box of Model Settings is implemented to determine whether to overwrite the connection string in the project config file with the one, currently set in Entity Developer for the model, each time when regenerating code for the model (LinqConnect models)
The behaviour is changed: "Save connection string in App.Config as" check box in Model Settings dialog box is renamed to "Use connection string from App.Config as" (LinqConnect models)
The behaviour is changed: now, when creating a new TPH discriminator column in Inheritance Editor, it has the string type by default
The behaviour is changed: the error is generated if the Abstract inheritance modifier is set for the class which is involved in the Table Per Type inheritance
The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of class property without assigned value
The behaviour is changed: a string default value for the property can be set without quotes in the Properties window
The behaviour is changed: the validation error is not generated when an abstract class is used in Table Per Type inheritance (Entity Framework models)

Entity Framework

The config.CodeFirstOptions.TruncateLongDefaultNames configuration option (default value is False) is added to provide the possibility of truncating long default names of indexes, primary keys, and foreign keys generated by Code-First Migrations
The validation of the identifier name length in Code-First Migrations is implemented
The config.DatabaseScript.Table.StorageEngine option for possibility of setting MySQL storage engine for creating tables with CreateDatabase() and Code-First Migrations functionality is implemented
The NDB storage engine is added to the list of available MySQL storage engines for Code-First
The error messages about long identifiers when using CreateDatabase/DropDatabase are improved

28-February-13 New features in dotConnect for MySQL 7.5

ExtendedMembership (SimpleMembership) provider support is added

Entity Developer

The possibility of setting enum values via predefined dropdown list in the Retrieve Data window is implemented

Entity Framework

Entity Framework 6 Alpha 3 is supported

17-January-13 New features in dotConnect for MySQL 7.4

Entity Developer

The behaviour is changed: the serializing property and corresponding methods are not generated when using 'Fluent Mapping'/'POCO Entity' templates and Unidirectional mode (LinqConnect models)
The behaviour is changed: the MySQL TIMESTAMP data type is stored as 'timestamp' instead of 'datetime' in SSDL when creating or updating model (Entity Framework models)
The behaviour is changed: warnings about tables/views without primary keys are written to Error List window when generating a model (Entity Framework models)
The behaviour is changed: the EntityKey attribute is not assigned to each property of the class if there is no primary key in the corresponding table/view (Entity Framework models)
The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of Storage Column without assigned value (Entity Framework models)

Entity Framework

Entity Framework 6 Alpha 2 is supported
Devart.Data.MySql.Entity.dll assembly compiled with EntityFramework.dll 6.0 and NET Framework 4.0 is added
The possibility of setting the timestamp server data type for the property when using the Code-First mapping is implemented
The behaviour is changed: the name of analogue for MySQL TIMESTAMP is changed from 'Timestamp' to 'timestamp' in the list of data types used in storage part (SSDL) of the model
The behaviour is changed: the MySQL TIMESTAMP data type is stored as 'timestamp' instead of 'datetime' in SSDL when creating or updating model via Entity Data Model Wizard

20-December-12 New features in dotConnect for MySQL 7.3

The 'Disable Charset Sending' connection string parameter is implemented (defines whether the query 'SET NAMES charset_name' will be executed after MySqlConnection.Open when pooling is set to 'true')

Entity Developer

Model Refactoring feature is implemented; it speeds up creating complex types and Table Per Type and Table Per Concrete Type inheritances from several model entities
Create Storage and Mapping command, that allows automatically creating of the corresponding storage part object and defining mapping, is added to the shortcut menu of classes, properties, and associations (Entity Framework models)
Select Storage Object command, that allows quick navigation to the corresponding storage part object, is added to the shortcut menu of classes, properties, associations, and methods (Entity Framework models)
The possibility to delete the corresponding storage part objects automatically when deleting conceptual model objects is added (Entity Framework models)
The functionality of ignoring columns in the database in the "Update To/From Database" wizards if they were omitted once before is implemented
The Property Editor dialog is improved: fast access to the editor of the corresponding storage object and the possibility to specify different settings that were previously available only in the Properties docking window are implemented (Entity Framework models)
The Inheritance Editor dialog is improved: specifying Discriminator column for Table Per Hierarchy inheritance in the editor is implemented (Entity Framework models)
The Class Editor dialog is improved: fast access to the editor of the corresponding storage object is implemented (Entity Framework models)
The Method Editor dialog is improved: fast access to the editor of the corresponding storage object is implemented (Entity Framework models)
Warnings about objects that are not mapped are added
The naming algorithm for the newly-created columns, which correspond to complex type's properties, when using the Model First approach is improved (Entity Framework models)
A SHIFT+DELETE keyboard shortcut for deleting entity, complex type, or enum from diagram only is added
An INSERT keyboard shortcut for creating a new entity, adding property to the selected entity/complex type or new member to enum is added
The possibility to view notes, added through the "Documentation" property, for all the diagram objects via hints is implemented
Hints for diagram objects are improved
The behaviour is changed: Configure Behaviour dialog is renamed to Stored Procedure Mapping; options for hiding inappropriate and mapped stored procedures are added (Entity Framework models)
The behaviour is changed: Table Editor dialog is renamed to Storage Entity Editor (Entity Framework models)
The behaviour is changed: Stored Procedure Editor dialog is renamed to Storage Procedure Editor (Entity Framework models)
The behaviour is changed: Configure Behaviour dialog is renamed to Stored Procedure Mapping (LinqConnect models)
The behaviour is changed: now the 'Read Only' property is not set to true for autoincrement fields by default when creating/updating models (LinqConnect models)

06-September-12 New features in dotConnect for MySQL 7.2

Visual Studio 2012 is supported
The overload for the MySqlDependency.Start method with the MySqlConnection parameter is added

LinqConnect (formerly known as LINQ to MySQL)

The fluent mapping is improved: support of the ID generators for primary keys is added

Entity Developer

Support for ADO.NET Entity Framework 5 is added
Predefined template for generating Repositories and Unit of Work classes is added
Integration with Visual Studio refactoring for renaming model objects is implemented
The possibility to set different namespaces for the context and its entities when using the DbContext template is implemented (Entity Framework models)
The "Use Database Comments" option of Model Settings is implemented to determine whether comments for database objects, if supported by DBMS, will be used for model objects Documentation initialization and taken into account when executing model or database update operations
The "Implement IClonable" option for the generated classes based on the model entities is added to all templates
The 'Entity Base' class property, which allows specifying the ancestor class/interface for a particular entity type, is implemented (LinqConnect models)
The behaviour is changed: the "Save connection string in App.Config as" option is available for LinqConnect models in the standalone version Entity Developer (the entry in App.Config must be added manually afterwards)
The behaviour is changed: only particular (not all) property characteristics are regenerated when using Update Model From Database wizard after the metadata of the corresponding column have been changed (LinqConnect models)

Entity Framework

ADO.NET Entity Framework 5 is supported
The behaviour is changed: Devart.Data.MySql.Entity.Migrations.dll is built with the 4.4 version of EntityFramework.dll now

17-July-12 New features in dotConnect for MySQL 7.1

Entity Developer

The possibility to unload assemblies from the main application domain by using separate application domain is implemented
The possibility to disable such Database First Settings as type mapping rules is implemented
The design time copy/cut/paste functionality for enum members is added
The behaviour is changed: the warning, related to the missing property setter, is disabled (LinqConnect models)
The behaviour is changed: for the association, in which the many-side entity hasn't the primary key, the code and the mapping are not generated (LinqConnect models)
The behaviour is changed: the properties, that correspond autoincrement fields, are generated with a ReadOnly keyword in VB.NET (LinqConnect models)

Entity Framework

The support of the MySQL full-text search functionality is implemented
The MySqlTextFunctions class for working with full-text search functions in LINQ to Entities is added
The MySqlCreateIndexConfiguration class for creating full-text indexes in CreateIndex operation in Code-First Migrations is added
The MySqlCreateTableConfiguration class for customizing the CreateTable operation (setting storage engine) in Code-First Migrations is added
The possibility of setting configuration options via the application config file is implemented
The Devart.Data.MySql.Entity.xsd file is added to the installation in order to simplify setting and validating the application config file settings when using the XML Editor
Code-First Migrations now supports specifying which schema (database) a table belongs to
The config.Workarounds.IgnoreDboSchemaName configuration option is added. The option is automatically set to True, if Code-First (Migrations) EF v4.x/5.x is used
The config.QueryOptions.UseCSharpNullComparisonBehavior configuration option for checking for NULL when comparing a nullable property (column) or an expression with a variable (parameter) in LINQ to Entities is implemented (by default, false)
CASE generation is improved
The behaviour is changed: in case of using Code-First (Migrations) EF v4.x/5.x the schema name 'dbo' will be ignored by default

22-May-12 New features in dotConnect for MySQL 7.0

Visual Studio 2012 Release Candidate is supported
The Initialization Command connection string parameter is implemented
The MemCryptStorage class for storing SSL certificates in the application memory is implemented
The 'Found Rows' connection string parameter is implemented (defines whether the MySqlDataReader.AffectedRows property counts all rows satisfying the WHERE clause of a command)
The behaviour is changed: the 'sender' parameter in MonitorEventHandler is a connection and the MonitorEventArgs.ExtraInfo property is filled with the connection string
The behaviour is changed: the access modifier of the connectionString field of web provider classes is changed from private to protected

LinqConnect (formerly known as LINQ to MySQL)

References to System.Data.Linq are removed; now LinqConnect uses only its own classes
Upgrade wizard for upgrading projects to the new version of LinqConnect automatically is added
The possibility to choose cache mode (classic mode for cases when DataContext is used as a unit of work, and self-cleaning mode for cases when DataContext is a long-lived object) is added
The possibility to map stored procedure out parameters of the CURSOR type to IEnumerable parameters of the corresponding methods is added
Tracking of complex object graphs with chains of parent-child objects is optimized
Number of database calls required for managing objects with a many-to-many association is reduced
Delete rule performance is improved
Compilation performance is improved
Materialization performance is improved
Compiled query cache is improved

Entity Developer

The precision facet for DateTime and Time properties is supported
The sticker notes for adding comments to diagrams are implemented
The possibility to add a stamp, specifying diagram author, company, version, copyrights, project name, and date, to a diagram is implemented
New Collapse All and Expand All menu commands for collapsing and expanding diagram shapes are added
The "Pluralize collection navigation properties" option for the possibility to turn off the pluralization of the many-end names of associations is implemented
The "sealed override" inheritance modifier for methods based on stored procedures and functions is added (LinqConnect models)
The behaviour is changed: context menu commands for working with diagram are grouped to the Diagram submenu of the context menu
The behaviour is changed: the possibility to change diagram shape color via the corresponding Shape -> Color context menu command is added
The behaviour is changed: when pasting a copied entity to a new diagram, a new entity is not created, the existing entity is added to this diagram
The behaviour is changed: when cutting an entity from the diagram, the entity is not cut from the model, only from the diagram
The behaviour is changed: "Update Model From Database" wizard places newly added properties to the base abstract class now instead of putting them into child classes where the mapping is (Entity Framework models)

Entity Framework

The config.CodeFirstOptions.RemoveSchemaFromDefaultConstraintName option for removing schema name from the default constraint name is implemented in Code-First Migrations (by default, true)
The config.CodeFirstOptions.AddTableNameInDefaultIndexName option for adding a table name to the default index name is implemented in Code-First Migrations (by default, true)
The MySqlRenameColumnConfiguration class is added for the possibility of setting column definition for the RenameColumn operation in Code-First Migrations
The MySqlAddForeignKeyConfiguration class for the customization of the AddForeignKey operation (setting ON UPDATE and ON DELETE actions) in Code-First Migrations is added
The behaviour is changed: an exception is generated for the default RenameColumn operation which is without column definition in Code-First Migrations
The behaviour is changed: ON UPDATE NO ACTION is generated for the AddForeignKey operation by default now in Code-First Migrations

15-Mar-12 New features in dotConnect for MySQL 6.80

Visual Studio 11 Beta is supported
The handling of empty options in the connection string is improved

Entity Developer

The copy/cut/paste functionality is added for objects of the conceptual part of a model
The possibility to drag&drop properties between classes in Model Explorer is implemented
The "HeaderTimestampVersionControlTag" generation template option is added for improving integration with version-control systems
The multiline popup editor for the Documentation.Summary property is implemented
The behaviour is changed: the Migrate option is added to the context menu of property in Model Explorer
The behaviour is changed: entities and enums on the designer surface are more resizable now

Entity Framework

Entity Framework 5.0 Beta 2 is supported
SQL generation for .Any method in LINQ to Entities is improved
The behaviour is changed: Devart.Data.MySql.Entity.Migrations.dll is built with the 4.3.1 version of EntityFramework.dll now

27-Jan-12 New features in dotConnect for MySQL 6.70

Entity Developer

The validation of method parameters in LinqConnect models is added
The context menu options for unchecking changed/added/dropped tables are implemented for the root nodes in the "Update To/From Database" wizards
The possibility to rename the storage part of the model in Model Explorer is implemented (Entity Framework models)
The diagram design is changed: an arrow (instead of a triangle) is used on the tip of an association now
The documentation generation for navigation properties is implemented
The "Recreate Model" option, allowing to rebuild the model from a scratch, is added to the "Update Model From Database" wizard
The "GeneratePartialClass" template property to generate a partial class, which will not be overwritten by the designer, for each class in the model is added
The stored procedures support in DbContext template in case of XML mapping is implemented (Entity Framework models)
The "Identifier Case Sensitive" check box, which enables case-sensitive processing of database object identifier names, is added to MySQL Server Options
The behaviour is changed: the MySqlDump.HexBlob property now affects Binary and VarBinary columns
The behaviour is changed: database column comments are transfered to the Summary attribute of the Documentation property now
The behaviour is changed: the TINYINT(1) data type is now used for the columns which correspond to the System.Boolean properties

Entity Framework

Entity Framework 4.3 (Code First Migrations) is supported
The validation of identifier name length in Code-First Migrations is implemented
The conversion of .StartsWith, .Contains, .EndsWith to LIKE clause in the generated SQL for the case of expression-based condition is supported
The Code-First Migrations behaviour is changed: if the nullable value of the property in migration is not set explicitly, the corresponding column will be created nullable

09-Dec-11 New features in dotConnect for MySQL 6.60

Entity Developer

Capability for customizing the default Type Mapping Rules is implemented
Capability for setting diagram options either globally for all diagram documents or separately for a particular one is implemented: the Diagram Appearance and Printing options can now be set through the Options dialog box
Capability for setting such options as Environment, Diagram and Servers' to adjust the Entity Developer behavior, Model diagram behavior and Type Mapping Rules to your needs is implemented
Capability for setting and defining the class property validation rules based on different engines (Data Annotation, Enterprise Library, NHibernate Validator) is added
The HasStream attribute of entity types, used retrieve binary data as a stream via Open Data Protocol, is supported (Entity Framework models)
The documentation generation for Enum members is implemented
The "Detect function-based column default value" option for automatic setting StoreGeneratedPattern to Identity for corresponding columns is implemented for Entity Framework models (by default, false)
The algorithm for forming the Navigation Properties names, when there are several FOREIGN KEY constraints between the same tables, is changed
The behaviour is changed: the Navigation Property will not be displayed on the diagram and in Model Explorer if "Generate" is set to false for the appropriate association end
The behaviour is changed: the Validate Max Length attribute is synchronized with the Max Length attribute of Property by default now
The behaviour is changed: the Validate Required attribute is synchronized with the Nullable attribute of Property by default now
The behaviour is changed: when selecting a property in the Model Explorer, the corresponding entity on the diagram does not expand if it is collapsed

Entity Framework

The generation of SQL-literals for byte array is supported
The behavior of the Database.Delete code-first method is changed: the constraints are now disabled when database objects are deleted
The config.QueryOptions.NoEscapeLike option is implemented to manage LIKE behaviour when using Linq to Entities extention methods .Contains() .EndsWith() .StartsWith()

06-Sep-11 New features in dotConnect for MySQL 6.50

The MySqlDump.HexBlob property for making dump in hexadecimal format for BLOB is implemented
The GEOMETRYCOLLECTION, LINESTRING, MULTIPOINT, MULTIPOLYGON, and POINT data types are supported by MySqlCommandBuilder.DeriveParameters()

LinqConnect (formerly known as LINQ to MySQL)

Fluent Mapping support is added

Entity Developer

Fluent Mapping template for LinqConnect models is added
Support for enumerated types ("enums") in LinqConnect and Entity Framework June 2011 CTP models is implemented
Import for selected stored procedures into the context model for Entity Framework models is implemented
New skins to improve the apllication appearance are implemented
Selection driven highlighting is implemented
Capability for changing the shape color for entities, complex types and enums is implemented
Capability for selecting the diagram skin type is implemented
Disabling facets that are not applicable to the current field type is implemented (LinqConnect models)
The 'Binary As Guid' connection string parameter is supported
The possibility of specifying the name of the connection string to be saved in the application configuration file is implemented
Default behaviour changed: now the Update To Database Wizard does not drop foreign keys of a table if the 'master' one is not represented in the LinqConnect model
The default attribute mapping source for LinqConnect models is made static
Behaviour is changed: table is not marked as "Changed" in Update Wizard if DefaultValue is set for its expression column

Entity Framework

The possibility to turn off generation of fake updates for parent entities is implemented
The 'Binary As Guid' connection string parameter is supported in Entity Framework runtime and Entity Data Model Wizard

17-May-11 New features in dotConnect for MySQL 6.30

DbTransactionBase class is added
TransactionStateChanging and TransactionStateChanged events are added to the DbConnectionBase class
The UnixSocket protocol type is supported
GetUInt16(), GetUInt32(), GetUInt64(), and GetSByte() methods of MySqlDataReader class are implemented
Pluggable Authentication via MySQL client library is supported
Policy file for the Devart.Data.MySql.Entity assembly is added
The License Information Wizard is improved: now it 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
The support of events which occur when connections are taken and returned to pool for processing MySqlMonitor.TraceEvent is added
The "Use schema name" check box is added to DataSet Wizard

LinqConnect (formerly known as LINQ to MySQL)

The 'IsReference' mode of entity serialization is supported
The generation of auto-increment columns on the CreateDatabase call is implemented
Implemented eager loading in case the related entities collection is referenced in the select clause of the query
Implemented fetch mode customization for eager loading of related entities
Processing of Edm.StartsWith, Edm.Contains, and Edm.EndsWith is improved
The concurrency check processing is improved for updatable entities with specified StoreGeneratedPattern

Entity Developer

New Templates are added:
- LinqConnect: POCO template with XML mapping generation
- Entity Framework: POCO template, Self-Tracking template, DbContext template with fluent mapping generation
Templates usability is improved
Template Editor is significantly improved
Ability to declare additional properties for model objects is added
Ability to specify .NET attributes for model objects is added
The possibility to export the diagram into an image file was added
The Tiny As Boolean connection string parameter handling is added in Entity Framework models
The possibility to restrict adding the connection string information to the application configuration file is added
The changes in the Entity name are now preserved by Update From Database Wizard (Entity Framework models)
The pluralization algorithm is improved when Naming rules are defined
The Entity Key handling for Views in Update From Database Wizard in Entity Framework models is improved
Runtime support for literals specified in the 'Default Value' entity field property for LinqConnect models is implemented
The "Preserve schema name in storage" option is added

Entity Framework

Entity Framework 4.2 June 2011 CTP is supported
Batch Updates support is added
Adjustable SQL Formatting for DML commands is added
Ability to configure the NULL values inserting behaviour is added
IgnoreSchemaName workaround (mainly for Code First) is added
DisableQuoting workaround is added
MySqlFunctions.Like support (including LINQ to Entities) is added
Configurable database deletion and creation support is added
Processing of Edm.StartsWith, Edm.Contains, and Edm.EndsWith is improved
The TINYINT(1) to Boolean mapping in Entity Data Model Wizard/Update From Database Wizard when connection string includes "Tiny As Boolean=true;" is supported
The processing of LINQ expressions which work with literals is improved
The concurrency check processing is improved for updatable entities with specified StoreGeneratedPattern
The update functionality for default values is improved

27-Jan-11 New features in dotConnect for MySQL 6.10

Supported Visual Studio 2010 Service Pack 1
Added DDEX support in Express Edition
Supported SQL Server Reporting Services x64
Supported IFormattable interface in MySqlDecimal class
Added BeginTransaction value to the MonitorEventType enum
Implemented the DbMonitor.EventQueueLimit property which allows to set the maximal allowed number of messages waiting for being processed by the dbMonitor application

LinqConnect (formerly known as LINQ to MySQL)

Implemented the Attach(object entity, object original) method of the Devart.Data.Linq.ITable interface
Implemented implicit sorting by the entity key in queries with defined LoadWith rules
Changed behaviour: update check is now disabled by default for properties that represent MySQL FLOAT columns

Entity Developer

Added possibility to split model into several diagrams for better handling of large models
Implemented possibility to disable automatic recognition of many-to-many associations
Added ConstraintSet property for Constraints in the Store part of the Entity Framework model
Added mapping for Function Import result types (Entity Framework v4 only)
Changed behaviour: when adding two related entities with the corresponding properties having different types, an invalid association is created now
Changed default mapping for signed TinyInt columns: they are mapped to SByte now

Entity Framework

Entity Framework 4.1 RTW supported

29-Nov-10 New features in dotConnect for MySQL 6.00

Supported Visual Studio 2010 Service Pack 1 Beta
Implemented the MySqlScript.Delimiter property
Added "Transaction Scope Local" connection string option that enables the support for non-distributed transactions in the TransactionScope implementation
Improved interface in DbLoader class - added string and integer indexers
Added overloads for methods of DbDataReaderBase class with column name parameter
Added the 'Validate Connection' connection string parameter to validate connection on its retrieving from pool
Changed behaviour: when clearing the pool, the number of connections specified in 'Min Pool Size' is never removed

LinqConnect (formerly known as LINQ to MySQL)

Ability to execute DML statements in batches on SubmitChanges added
Table Per Type inheritance supported
Supported ASP.NET Dynamic Data with ASP.NET Dynamic Data project templates
PLINQ support added (connection manager redesigned for thread safety)
Supported Visual Studio Debugger Visualizer with SQL syntax highlighting for the DataQuery objects
Implemented overloads of DataContext.CreateDatabase and DeleteDatabase methods with boolean parameters specifying whether to create/delete database or not
Implemented support for custom type arguments in LinqConnect compiled queries

Entity Developer

Update To Database with Storage Synchronization functionality added
Added possibility for changing the UpdateCheck property for several fields at once
Added Update Model From Database functionality
Added multiselect support for properties
Improved large models handling

Entity Framework

Entity Data Model Wizard and Update Model from Database Wizard in Visual Studio 2010 Service Pack 1 Beta supported
Improved SQL generation for IN (Entity SQL) and Contains (LINQ to Entities) clauses

20-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)
Implemented integration with Visual Web Developer 2008 and 2010 Express editions
Implemented the BackupQuery method of MySqlDump for dumping result sets
Implemented host option for current process in dbMonitor
Added possibility for tracing the distributed transactions in DBMonitor

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
Added support for the DatabaseExists method
DataContext class is now CLS-Compilant
Improved transaction behaviour in case when exception is thrown
Added support for the String.Equals(string, StringComparison) overload, allowing to specify whether to use or not the binary string comparison

Entity Developer

Added possibility of renaming associations in the model
Added default bindings to entity fields in Insert(Update/Delete) MethodMappings

Entity Framework

Added implementation for the DatabaseExists method
Model First support improved
- Added more settings in Devart SSDLToMySql.tt file
- DROP statements generation added
- Schema name is not generated before each object

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