dotConnect for MySQL Professional 6.80.350 - Changelog

What's new in dotConnect for MySQL Professional 6.80.350:

May 2nd, 2012

Entity Developer:
· The multiline popup editor for the Documentation.Summary property is implemented
· The bug with metadata processing in Visual Studio 11 Beta is fixed (Entity Framework models)

What's new in dotConnect for MySQL Professional 6.80.341:

April 12th, 2012

LinqConnect (formerly known as LINQ to MySQL):
· The bug with the performance issues when generating complex queries is fixed

Entity Developer:
· 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
· The bug with creating LinqConnect models is fixed
· The bug with detecting many-to-many associations is fixed (Entity Framework models)

What's new in dotConnect for MySQL Professional 6.80.332:

March 29th, 2012

· The handling of empty options in the connection string is improved
· The bug with freezing for a ConnectionTimeOut time in case of a connection error when using SSH protocol is fixed

LinqConnect (formerly known as LINQ to MySQL):
· The bug with the generation of SQL queries including grouping by the whole entity is fixed

Entity Developer:
· The bug with model saving after performing copy/paste of an element with a custom attribute is fixed
· The bug with incorrect generation of a create database script in the "Generate Database Script" wizard for Entity Framework models, which occurs when the Regenerate Storage check box is selected, is fixed
· The bug with code generation for association basing on several EntityKey properties when using POCO Entity and Self-Tracking Entity Visual Basic templates is fixed (Entity Framework models)
· The bug with the "Update Model From Database" wizard showing isVersion columns as changed is fixed (LinqConnect models)

Entity Framework support:
· Entity Framework 5.0 Beta 2 is supported
· The behaviour is changed: Devart.Data.MySql.Entity.Migrations.dll is built with the 4.3.1 version of EntityFramework.dll now
· The bug with using expression aliases in complex queries is fixed

What's new in dotConnect for MySQL Professional 6.80.325:

March 15th, 2012

· Visual Studio 11 Beta is supported

LinqConnect (formerly known as LINQ to MySQL):
· The bug with column order in queries including the UNION clause is fixed
· The bug with InvalidOperationException on disposing data contexts is fixed

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 bug with generating code when using stored procedures with multiple result set with the POCO Entity and Self-Tracking Entity templates is fixed (Entity Framework models)
· The bug with setting StoreGeneratedPattern to Identity for foreign key property of the child class when creating an association is fixed (Entity Framework models)
· The bug with generating mappings for many-to-many association of entity to itself is fixed

Entity Framework support:
· Entity Framework 5.0 Beta 1 is supported
· SQL generation for .Any method in LINQ to Entities is improved

What's new in dotConnect for MySQL Professional 6.70.311:

February 27th, 2012

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 bug with setting comments for columns and tables in database is fixed

Entity Framework support:
· Entity Framework 4.3 (Code First Migrations) is supported
· 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

What's new in dotConnect for MySQL Professional 6.70.302:

February 10th, 2012

Entity Developer:
· 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 bug with preserving the Validate Required property when saving the model is fixed
· The bug with Entity Developer tool windows being shown when debugging an application is fixed
· The bug with diagram representation in x64 environment is fixed

What's new in dotConnect for MySQL Professional 6.70.293:

January 27th, 2012

LinqConnect (formerly known as LINQ to MySQL):
· The bug with empty spaces in foreign key names generated by the CreateDatabase() method is fixed

Entity Developer:
· 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 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
· The bug with resetting the Validate Required property after reopening model is fixed
· The bug with generating System.ComponentModel.DataAnnotations.KeyAttribute() for Primary Key columns is fixed
· The bug with a workability of documentation links on Start Page is fixed
· The bug with resetting the StoreGeneratedPattern attribute by the Update Model From Database wizard is fixed (Entity Framework models)

Entity Framework support:
· Entity Framework 4.3 Beta 1 (Code First Migrations) is supported
· The bug with removing existing stored procedures from the model in Entity Data Model Wizard, when no new stored procedures are selected, is fixed

What's new in dotConnect for MySQL Professional 6.60.283:

January 13th, 2012

Entity Developer:
· 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
· The bug with adding diagrams when the Notation parameter of the diagram "Property Details Level" is set to "Name And Type" is fixed
· The bug with changing the Type property simultaneously for several inheritances is fixed
· The bug with invalid Properties grid data refreshing for the selected attribute in the Attributes dialog box is fixed
· The bug with formatting indents when generating code is fixed
· The bug with saving inheritance layout on the diagram is fixed
· The bug with incorrect model diagram saving after deleting a complex type from a diagram is fixed
· The bug with invalid parameter direction in wrapper methods of stored procedures from MySQL 5.5 servers is fixed (LinqConnect models)
· The bug when the names of constraints in the Store part of the model are not taken into account by Generate Database Script From Model wizard is fixed (Entity Framework models)
· The bug with Retrieve Data when using DbContext template is fixed (Entity Framework models)
· The bug with Table Per Hierarchy (TPH) when using abstract intermediate class between the base and derived classes is fixed (Entity Framework models)

Entity Framework support:
· The generation of SQL-literals for byte array is supported
· The bug with using slashes in string parameters of the .Contains method is fixed

What's new in dotConnect for MySQL Professional 6.60.268:

December 22nd, 2011

· The bug with MySqlType.TinyInt parameter binding for a prepared statement is fixed
· The bug with setting the PrimaryKey attribute of DataTable.Constraints when editing an existing DataSet using DataSet Wizard is fixed
· The bug with the MySqlConnection.GetSchema("Procedures",...) method returning an incorrect type of the "Comment" column of the metadata table, when connecting to MySQL servers v 5.5.0 or later, is fixed

LinqConnect (formerly known as LINQ to MySQL):
· The bug with inserting entities having a many-to-many association and auto-generated keys is fixed

Entity Developer:
· The bug with Visual Basic templates is fixed
· The bug with duplicating EntitySet attribute when using entity return type is fixed (Entity Framework models)

Entity Framework support:
· The bug with generating CROSS JOIN statement when using LINQ to Entities is fixed
· The bug with config.DmlOptions.InsertNullBehaviour for non-EntityKey columns with initialized DefaultValue and StoreGeneratedPattern is fixed

What's new in dotConnect for MySQL Professional 6.50.258:

December 8th, 2011

LinqConnect (formerly known as LINQ to MySQL):
· The bug with inserting both sides of a one-to-one relationship is fixed

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 bug with code generation for foreign key fields in Entity Framework models with fluent mapping is fixed
· The bug with code generation for default values of DateTime fields is fixed (LinqConnect models)
· The bug with 'losing' additional diagrams when re-opening a model is fixed

Entity Framework support:
· 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()
· The bug with generating SQL for EdmFunction is fixed
· The bug with adding unnecessary CASTs to SQL when working with DateTime and numeric columns and expressions is fixed

What's new in dotConnect for MySQL Professional 6.50.250:

November 24th, 2011

Entity Developer:
· The bug related to Visual Studio crashes at query execution is fixed
· The bug with removing associations when updating the model is fixed

Entity Framework support:
· The size of generated SQL is reduced by excluding redundant aliases

What's new in dotConnect for MySQL Professional 6.50.244:

November 11th, 2011

· The bug with freezing of a connection that is not taken from the connection pool when using stored procedure is fixed
· The bug with setting Port connection string parameter in Visual Studio connection editor to the value that is greater than 10000 is fixed
· The bug with returning invalid connections to pool is fixed

LinqConnect (formerly known as LINQ to MySQL):
· The bug with updating explicitly attached entities is fixed

Entity Developer:
· 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
· The bug with detecting whether Devart Entity Model is changed or not is fixed
· The bug with NRE being thrown when an invalid connection is used is fixed
· The bug with setting the Concealed Function property in Stored Procedure Editor is fixed
· The bug with the local settings used for the default value of DateTime fields is fixed (LinqConnect models)
· The bug with creating an association between classes participating in a TPC inheritance hierarchy is fixed (Entity Framework models)
· The bugs with storage synchronization for TPC inheritance classes is fixed

Entity Framework support:
· The bug with determining correct data types in columns of descendants in TPT and TPC hierarchies is fixed
· The bug with the TimeSpan parameters is fixed
· The bug with the Group By expression is fixed

What's new in dotConnect for MySQL Professional 6.50.237:

October 21st, 2011

· The GEOMETRYCOLLECTION, LINESTRING, MULTIPOINT, MULTIPOLYGON, and POINT data types are supported by MySqlCommandBuilder.DeriveParameters()
· The bug with license check in ILMerged assembly in Mobile Edition is fixed

LinqConnect (formerly known as LINQ to MySQL):
· The bug with getting wrong query from the compiled query cache is fixed
· The bug with ordering results of a query with eager loading options enabled is fixed
· The bug with inserting entity objects having multiple relations to other entity type with auto-generated primary key is fixed
· The bug with updating navigation properties based on a composite foreign key which intersects with the primary key is fixed

Entity Developer:
· The possibility of specifying the name of the connection string saved in the application configuration file is implemented
· The bug with saving the IsFlags property of enum types in Entity Framework models is fixed

Entity Framework support:
· The bug with config.Workarounds.DisableQuoting behaviour with checking DatabaseExists is fixed

What's new in dotConnect for MySQL Professional 6.50.228:

September 29th, 2011

LinqConnect (formerly known as LINQ to MySQL):
· The bug with ordering queries with eager loading options is fixed
· The bug with caching queries performed via the ExecuteQuery method is fixed
· The bug with .Equals(null) conditions in LINQ queries is fixed

Entity Developer:
· Disabling facets that are not applicable to the current field type is implemented (LinqConnect models)
· The 'Binary As Guid' connection string parameter is supported
· 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 bug with saving a new solution provided that the Visual Studio option for 'Projects and Solutions -> Save new projects when created' is unchecked is fixed
· The bug with pluralization algorithm is fixed when Naming rules are defined
· The 'The given key was not present in the dictionary' error in the Entity Developer version integrated into Visual Studio 2010 is fixed
· The bug with incorrect determining of association multiplicity (redundant 'many-to-many') in LinqConnect models is fixed
· The bug with setting Extended Properties for RelationProperty is fixed

Entity Framework support:
· The 'Binary As Guid' connection string parameter is supported in Entity Framework runtime and Entity Data Model Wizard
· The bug with executing Function Imports with enabled BatchUpdates is fixed
· The bug with Entity Data Model Wizard when creating a model is fixed
· The bug when MySqlEntityProviderWorkaroundConfig.IgnoreSchemaName does not affect stored procedures is fixed
· The bug with canonical function CreateDateTime is fixed

What's new in dotConnect for MySQL Professional 6.50.214:

September 6th, 2011

· The MySqlDump.HexBlob property for making dump in hexadecimal format for BLOB is implemented
· The bug with the resource file in Mobile Samples which are shipped with provider is fixed
· The bug with MySqlConnection.Kill() method is fixed

LinqConnect (formerly known as LINQ to MySQL):
· Fluent Mapping support is added
· The bug with inserting a TPT 'child' entity in case its primary key column names differ from the 'parent' entity ones is fixed
· The bug with deleting dependent entities when other changes were made is fixed
· The bug with entity materialization for queries with multiple eager loading options is fixed
· The bug with saving (inserting or updating) System.Data.Linq.Binary objects is fixed

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
· Changed behaviour: when the FirstLetterUpperCase / FirstLetterLowerCase option is enabled in Naming rules, each letter after underscore will be capital/lower
· The bug with saving custom attribute properties with default values in .edml files is fixed
· The bug with changing property names ("Index was outside the bounds of the array") is fixed
· The bug with an incorrect generation of the private variables names in Entity Framework models is fixed

Entity Framework support:
· The possibility to turn off generation of fake updates for parent entities is implemented

What's new in dotConnect for MySQL Professional 6.30.202:

August 16th, 2011

· The support of events which occur when connections are taken and returned to pool for processing MySqlMonitor.TraceEvent is added

LinqConnect (formerly known as LINQ to MySQL):
· The bug with deleting dependent entities when the 'main' one is modified is fixed
· The bug with update commands for Table Per Type inheritance is fixed

Entity Developer:
· The pluralization algorithm is improved when Naming rules are defined

What's new in dotConnect for MySQL Professional 6.30.196:

July 28th, 2011

· The bug with batch insert in NHibernate support is fixed
· The bug with not closed connections by OracleInstanceStore is fixed

LinqConnect (formerly known as LINQ to Oracle):
· The bug with columns named as Oracle keywords is fixed

Entity Developer:
· The Entity Key handling for Views in Update From Database Wizard in Entity Framework models is improved
· The bug with XML comments generation in Entity Framework models is fixed
· The bug with wrong error placing in Model Explorer in Entity Framework models is fixed
· The bug with renaming the stored procedure parameter in Entity Framework models is fixed
· The bug with regeneration of the ed:Guid attribute of navigation properties after Update From Database wizard completes is fixed (Entity Framework models)

Entity Framework support:
· The "raw guid as string" SSDL type is implemented for text presentation of binary Guids
· The processing of LINQ expressions which work with literals is improved
· The bug with insert into Identity single-column table is fixed

What's new in dotConnect for MySQL Professional 6.30.185:

July 9th, 2011

· The bug with securityTrimmingEnabled option of Site Map provider is fixed
· LinqConnect (formerly known as LINQ to MySQL)
· The bug with the 'Cannot remove an entity that has not been attached' error when using compiled queries is fixed
· Entity Developer
· 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 bug with the 'condition' keyword in the script created by the Generate Database Wizard is fixed
· The bug with default value quotation in Entity Framework models is fixed
· The bug with Save All for the Read Only model files in Entity Framework models is fixed
· The bug with deleting associations on update from database in LinqConnect models is fixed
· The bug with Primary Key naming in case of many-to-many associations in Model First is fixed (LinqConnect models)
· Entity Framework support
· Entity Framework 4.2 June 2011 CTP is supported

What's new in dotConnect for MySQL Professional 6.30.172:

June 16th, 2011

LinqConnect (formerly known as LINQ to Oracle):
· The 'IsReference' mode of entity serialization is supported
· The bug with querying entity tables having no primary key is fixed
· The bug with ArgumentException on accessing DataContext.Table when the TEntity class has user-defined properties is fixed

Entity Developer:
· The bug with Extended Properties handling is fixed
· The bug with setting the multiplicity of updated constraint in Entity Framework models is fixed

Entity Framework support:
· The update functionality for default values is improved
· The bug with NUMBER Mappings in Entity Data Model Wizard is fixed
· The bug with Default Value and the Identity columns is fixed

What's new in dotConnect for MySQL Professional 6.30.165:

June 2nd, 2011

· The bug with license check in ILMerged assembly is fixed
· The bug with displaying table names in DataSet Wizard when connecting to MySQL server 4.1 is fixed
· LinqConnect (formerly known as LINQ to MySQL)
· Implemented fetch mode customization for eager loading of related entities
· The bug with NullReferenceException when selecting non-entity types is fixed
· The bug with type mismatch when using null parameters in LINQ queries is fixed
· The bug with refreshing entities with a changed entity reference is fixed
· The bug with updating entities that have associations based on unique (not primary) keys is fixed
· The bug with parameters of compiled queries not being refreshed is fixed
· Entity Developer
· The bug with configuring a sequence ID generator in LinqConnect models is fixed
· The bug with LinqConnect external mapping file in case entity classes belong to non-default namespace is fixed
· The bug with persisting associations between LinqConnect entity classes inherited from the same base class is fixed
· The bug with Visual Basic code generation for related entities sets is fixed
· The bug with Unicode symbols in template is fixed
· Entity Framework support
· Processing of Edm.StartsWith, Edm.Contains, and Edm.EndsWith is improved
· The concurrency check processing is improved for updatable entities with specified StoreGeneratedPattern

What's new in dotConnect for MySQL Professional 6.30.160:

May 18th, 2011

· DbTransactionBase class is added
· TransactionStateChanging and TransactionStateChanged events are added to the DbConnectionBase class
· Implemented GetUInt16(), GetUInt32(), GetUInt64(), and GetSByte() methods of MySqlDataReader class
· Policy file for the Devart.Data.MySql.Entity assembly is added
· The License Information Wizard is 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
· The "Use schema name" checkbox is added to DataSet Wizard
· The bug with Membership provider compatibility between .NET Framework 2.0 and 4.0 is fixed
· The bug with launching Devart documentation via Start menu is fixed
· The bug with "Bad handshake" exception when connecting to MySQL servers v 5.1.57 and 5.5.12 is fixed
· LinqConnect (formerly known as LINQ to MySQL)
· Implemented eager loading in case the related entities collection is referenced in the select clause of the query
· The bug with incorrect operation order during SubmitChanges() calls is fixed
· The bug with ArgumentExceptions thrown in background threads is fixed
· The bug with using public properties when refreshing or materializing an entity is fixed
· The bug with grouping a collection by a whole entity is fixed
· 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
· Implemented runtime support for literals specified in the 'Default Value' entity field property for LinqConnect models
· The "Preserve schema name in storage" option is added
· The bug with code generation for the 'Delete Rule' association property in LinqConnect models is fixed
· The bug with generation of attach/detach methods for many-to-many associations in LinqConnect models is fixed
· The bug with external mapping for LinqConnect models is fixed
· The bug with default values set via a function for string fields in LinqConnect models is fixed
· The bug with the "Access" combobox of the Association editor in LinqConnect models is fixed
· The bug with procedures that differ only by name in Database Explorer is fixed (Entity Framework models)
· Entity Framework support
· 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
· The bug with Entity Framework configurability is fixed

What's new in dotConnect for MySQL Professional 6.10.141:

April 19th, 2011

· LinqConnect (formerly known as LINQ to MySQL)
· Fixed bug with invalid aliases in queries that include the UNION clause
· Fixed bug with simultaneous insert of both sides of a one-to-one association when the 'master' side has auto-generated ID

Entity Framework support:
· Entity Framework 4.1 RTW supported

What's new in dotConnect for MySQL Professional 6.10.135:

April 6th, 2011

· Changed behaviour: OracleDbType.VarChar parameter's max size is increased from 4000 to 32767 symbols
· Fixed bug with upgrading *.cs files in App_Code folder when using Upgrade Wizard
· Fixed bug with exception in TransactionScope in case of enabled Microsoft Distributed Transaction Coordinator (MSDTC)
· Fixed bug with out parameters in ExecuteArray

LinqConnect (formerly known as LINQ to Oracle):
· Implemented the Attach(object entity, object original) method of the Devart.Data.Linq.ITable interface
· Fixed bug with passing GUID parameters to compiled queries

Entity Developer:
· Changed behaviour: when retrieving metadata for Oracle servers 9.2.0.5 and prior, the JOIN syntax of Oracle 8 is used now
· Fixed bug with multiplicity changing in the association editor (Entity Framework models)

Entity Framework support:
· Fixed bug with whitespace symbol not generated on update
· Fixed bug with parentheses generation on Take
· Fixed bug with CAST of the CLOB type
· Fixed bug with adding unnecessary model objects in Entity Data Model Wizard

What's new in dotConnect for MySQL Professional 6.10.126:

March 25th, 2011

· Supported Visual Studio 2010 Service Pack 1
· Fixed bug with upgrading *.ascx files when using Upgrade Wizard

LinqConnect (formerly known as LINQ to MySQL):
· Fixed bug with inserting 'detail' entities together with 'master' ones for one-to-one associations

Entity Developer:
· 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
· Fixed bug with generating incorrect code for models having one-to-one associations with a nullable property at the 'detail' side
· Fixed bug with generating script with duplicate columns for entities having two fields of the same complex type

Entity Framework support:
· Supported Entity Framework 4.1 Release Candidate
· Fixed bug with incorrect column name generation on update in case of Timestamp column having Computed StoreGenerationPattern

What's new in dotConnect for MySQL Professional 6.10.121:

March 10th, 2011

· Fixed bug with the "The message filter indicated that the application is busy" error during uninstall
· Fixed bug with DataLink.Find() method
· Fixed bug with System.OutOfMemoryException when retrieving BLOB values in SSL mode

LinqConnect (formerly known as LINQ to MySQL):
· Implemented implicit sorting by the entity key in queries with defined LoadWith rules
· Fixed bug with calling the base Devart.Data.Linq.DataContext constructor with the mapping argument

Entity Developer:
· Fixed bug with discarding changes in Navigation Properties names

Entity Framework support:
· Fixed bug with missing Order By clause in subqueries

What's new in dotConnect for MySQL Professional 6.10.111:

February 24th, 2011

· Added DDEX support in Express Edition
· Supported SQL Server Reporting Services x64
· 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 Professional 6.10.103:

February 15th, 2011

· Fixed bug with provider's workability on big-endian operating systems
· Fixed bug with SSL key container when it is used by several Windows accounts

LinqConnect (formerly known as LINQ to MySQL):
· Changed behaviour: update check is now disabled by default for properties that represent MySQL FLOAT columns
· Fixed bug with setting no reference to the Devart.Data.Linq.Web assembly when adding a DbLinqDataSource object to a web form
· Fixed bug with creating a new MySQL database with the DataContext.CreateDatabase method
· Fixed bug with retrieving entities participating in a many-to-many association with a composite key
· Fixed bug with continuing identity tracking for deleted entities
· Fixed bug with incorrect order of executing create/update/delete commands on SubmitChanges()

Entity Developer:
· 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: classes created with the Update From Database Wizard are now added to the current diagram
· Changed behaviour: the 'Update Check' is now set to 'Always' and disabled for properties that form the entity key (LinqConnect models)
· Fixed bug with wrong Complex Type properties in Stored Procedures
· Fixed bug with the 'Show Print Markup' button and 'Page Setup' menu item being disabled

What's new in dotConnect for MySQL Professional 6.10.96:

February 15th, 2011

· Fixed bug with provider's workability on big-endian operating systems
· Fixed bug with SSL key container when it is used by several Windows accounts
· LinqConnect (formerly known as LINQ to MySQL)
· Changed behaviour: update check is now disabled by default for properties that represent MySQL FLOAT columns
· Fixed bug with setting no reference to the Devart.Data.Linq.Web assembly when adding a DbLinqDataSource object to a web form
· Fixed bug with creating a new MySQL database with the DataContext.CreateDatabase method
· Fixed bug with retrieving entities participating in a many-to-many association with a composite key
· Fixed bug with continuing identity tracking for deleted entities
· Fixed bug with incorrect order of executing create/update/delete commands on SubmitChanges()
· Entity Developer
· 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: classes created with the Update From Database Wizard are now added to the current diagram
· Changed behaviour: the 'Update Check' is now set to 'Always' and disabled for properties that form the entity key (LinqConnect models)
· Fixed bug with wrong Complex Type properties in Stored Procedures
· Fixed bug with the 'Show Print Markup' button and 'Page Setup' menu item being disabled

What's new in dotConnect for MySQL Professional 6.00.86:

February 1st, 2011

· Changed behaviour: setting the DbDataTable.Connection property sets the InsertCommand.Connection, UpdateCommand.Connection, and DeleteCommand.Connection properties
· Fixed bug with incorrect case of data sources shown in the DataLink.DataSource property when using the Interform technology
· LinqConnect (formerly known as LINQ to MySQL)
· Fixed bug with incorrect detaching entities in the master/detail association
· Fixed bug with VB code generation for models with Unidirectional serialization
· Fixed bug with creating DataContext using external mapping
· Entity Developer
· Fixed bug with many-to-many and Update From Database Wizard
· Entity Framework support
· Added support for Entity Framework CTP 5
· Improved DatabaseExists functionality

What's new in dotConnect for MySQL Professional 6.00.69:

February 1st, 2011

· 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
· 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)
· Implemented support for custom type arguments in LinqConnect compiled queries
· Fixed bug with redundant subqueries and Order By clauses in commands generated for entities with configured load options
· Fixed bug with Visual Basic code generation for sequence-generated entity properties
· Fixed bug with the DataContext.Query method in the case when TResult is not an entity class
· Fixed bug with the 'The process was terminated due to an unhandled exception' error on severely loaded applications
· Fixed bug with inserting new rows into tables with auto-generated fields
· Entity Developer
· Fixed bug with the null-reference exception when adding LinqConnect model to web site folders other than App_Code
· Fixed bug with decimal default value generation
· Entity Framework support
· 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

What's new in dotConnect for MySQL Professional 6.00.58:

February 1st, 2011

· Added the 'Validate Connection' connection string parameter to validate connection on its retrieving from pool
· Fixed bug with validating connections in pool
· Fixed bug with WebSite projects in Delphi Prism
· 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
· Changed behaviour: retrieving master entity from details one now generates left outer join instead of inner join
· Fixed bug with default mappings for Medium-, Large- and TinyBlob data types
· Entity Developer
· Added Update Model From Database functionality
· Update To Database with Storage Synchronization functionality added
· Added possibility for changing the UpdateCheck property for several fields at once
· Added multiselect support for properties
· Improved large models handling
· Fixed bug with IndexOutOfRangeException on code generation
· Fixed bug with keyword quotation in the Source property
· Fixed bug with Unknown parameter direction
· Fixed "Cannot find column Position" bug
· Fixed bug with Visual Basic code generation for stored functions
· Fixed bug with not loading Master property in Detail entity of master/details associations
· Fixed bug with mapping One-to-One associations to One-to-Many
· Fixed bug with Default Value in Entity Framework models
· Fixed bug with default editor in Visual Studio
· Fixed bug with associations that crash Visual Studio
· Fixed bug with Guid and inheritance
· Fixed 'Model is not registered' bug
· Fixed bug with Retrieve Data
· Fixed some bugs in Team Foundation Server support

What's new in dotConnect for MySQL Professional 5.80.190:

February 1st, 2011

· Implemented integration with Visual Web Developer 2008 and 2010 Express editions
· Implemented the BackupQuery method of MySqlDump for dumping result sets
· LinqConnect (formerly known as LINQ to MySQL)
· 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
· Fixed bug with translating the IIf method in LINQ queries
· Fixed bug with custom methods in the 'select new' clause of LINQ queries
· Fixed bug with not loading associated entity when LoadWith is not used
· Fixed bug with creating tables with LongBlob fields on CreateDatabase()
· Entity Framework support
· Model First support improved
· Added more settings in Devart SSDLToMySql.tt file
· DROP statements generation added
· Schema name is not generated before each object

What's new in dotConnect for MySQL Professional 5.80.180:

February 1st, 2011

· Fixed bug with generating license resource for ILMerged assembly
· LinqConnect (formerly known as LINQ to MySQL)
· DataContext class is now CLS-Compilant
· Fixed bug with DataLoadOptions not working when object tracking is disabled
· Fixed bug with second-level details loading
· Fixed bug with creating compiled query using more than three parameters
· Fixed bug with select queries from tables with no primary key
· Fixed bug with constraint violation on inserting details before master data
· Fixed bug with ArgumentException when using System.Nullable.GetValueOrDefault in Visual Basic LINQ queries
· Fixed bug with incorrect marking of changed fields when using several DataContexts
· Fixed problem with recognizing MySql numeric type synonyms
· Entity Developer
· Added default bindings to entity fields in Insert(Update/Delete) MethodMappings
· Fixed bug with serializing entities loaded using DataLoadOptions
· Entity Framework support
· Added implementation for the DatabaseExists method

What's new in dotConnect for MySQL Professional 5.80.170:

February 1st, 2011

· Implemented host option for current process in dbMonitor
· Added possibility for tracing the distributed transactions in DBMonitor
· Fixed the 'Retrieving the COM class factory for component ... failed' error during installation on x64 machines
· Fixed bug with Minimal+LINQ installation
· Fixed bug with enlisting ASP.NET provider's activity to distributed transaction
· Fixed bug with assertion failure on show call tree in dbMonitor
· LinqConnect (formerly known as LINQ to MySQL)
· Fixed bug with editing Entity Key values
· Fixed bug with IndexOutOfRangeException on the DeleteOnSubmit call
· Fixed bug on inserting new rows into a table with many-to-many association
· Fixed bug with fetching records one-by-one from the 'detail' table in master/details relation
· Fixed bug with retrieving entities of an inherited type
· Fixed bugs with using the Contains method of empty arrays
· Fixed bug with the RejectChanges method not working
· Fixed bug with structs in queries
· Fixed bug with Command Timeout
· Fixed the 'invalid type mapping' bug when using TimeSpan in a primary key
· Entity Developer
· Fixed bug with VB Code generation for Associations
· Fixed bug with Unidirectional serialization mode
· Fixed design time bug with Referential constraints
· Fixed bug with generating code for stored procedures with out parameters

What's new in dotConnect for MySQL Professional 5.80.152:

February 1st, 2011

· Implemented capability of extending base functionality of ASP.NET providers
· Added support for Enterprise Library 5
· Changed the primary key of the aspnet_sessions table for ASP.NET Web providers (the ApplicationName column added)
· Fixed bug with DataTable in design time when using DevExpress XtraReport
· Fixed bug with creating connection in Server Explorer (connections are removed after uninstall now)
· LinqConnect (formerly known as LINQ to MySQL)
· Added implementation of the ITable interface for the Table class
· Changed DataContext.Log output format for Microsoft compatibility reasons
· Fixed bug with creating XmlMappingSource object when the File Per Class model property is set to true
· Fixed bug with IndexOutOfRangeException on the Refresh call
· Fixed bug with CompiledQueryCache
· Fixed bug with InvalidCastException on selecting a new anonymous type
· Fixed bug with FilePerClass and XMLMappingSource
· Entity Developer
· Added possibility of renaming associations in the model
· Fixed bug with change tracking for inherited tables
· Entity Framework support
· Fixed bug with association mapping in case of inheritance

What's new in dotConnect for MySQL Professional 5.80.146:

February 1st, 2011

· Fixed bug with membership provider (connection is not opened on Initialize() now)
· Fixed bug with model registration in web applications
· Fixed bug with Guid parameters for Unicode database
· Fixed bug with mapping of binary fields in typed DataSets
· Fixed bug with the MySQLCommand.Prepare method for stored procedures
· Fixed bug with 'release' reserved keyword
· LinqConnect (formerly known as LINQ to MySQL)
· Improved select performance
· Improved insert performance
· Added support for the DatabaseExists method
· Fixed bug with Concat()
· Fixed bug with the CacheStoreReader and Cast
· Entity Developer
· Fixed bug with column Summary serialization
· Fixed bug with Visual Basic code generation template
· Entity Framework support
· Fixed bug with the DevartEntityDeploy build action
· Fixed bug with the unnecessary trigger and sequence generation

What's new in dotConnect for MySQL Professional 5.80.140:

May 22nd, 2010

· Supported password salt in ASP.NET membership provider
· Supported 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
· 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
· Fixed bug with DbLinqDataSource and RadGrid paging
· Fixed bug with 'Nop' node translation
· Fixed bug with empty type in specific Group By clause
· Fixed bug with ArgumentNullException on DataContext.Query().Contains()
· Fixed bug with Cast() method
· Fixed bug with binary primary keys
· Entity Developer
· Fixed bug with Properties window
· Fixed bug with Discriminator property drag&drop
· Fixed bug on Customization window load
· Fixed bug with property editor grid updating
· Fixed bug with Document.Reload
· Fixed bug with LINQ models on Windows XP 64-bit
· Entity Framework support
· Fixed bug with string concatenation
· Fixed bug with data type mapping in function result set

What's new in dotConnect for MySQL Professional 5.70.124:

May 22nd, 2010

· Supported Visual Studio 2010
· Entity Developer
· Support for ADO.NET Entity Framework 4 added
· Entity Framework support
· Supported ADO.NET Entity Framework 4

What's new in dotConnect for MySQL Professional 5.70.120:

May 22nd, 2010

· Supported Visual Studio 2010 Release Candidate
· 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
· Fixed bug with licensing in Visual Studio 2010 Release Candidate projects
· Fixed bug with exception in License Information window
· Fixed bug with no exception on command timeout
· Fixed bug with multiple rows constraint generation
· LINQ to MySQL
· Added support for specific dynamic expressions
· Fixed bug with Refresh() method
· Fixed bug with LoadWith() method
· Fixed the 'Unable to cast object' problem
· Fixed bug with Where() and nullable parameter
· Fixed bug with multiple LoadWith() calls
· Fixed bug with calling a method in the Select clause
· Fixed "Cannot Refresh Entity" error
· Fixed bug with nullable boolean and null comparison
· Fixed "Cannot access a disposed object" error
· Fixed bug with "select new"
· Fixed bug with insert of autoincremented values
· Fixed bug with NotImplementedException and IGrouping.Count
· Fixed the problem with group by and ordering
· Fixed bug with exception on the master-detail insert
· Fixed bug with Int32 instead of Int64
· Entity Developer
· Support for ADO.NET Entity Framework 4 Release Candidate 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
· Fixed bug with different namespaces and procedure code generation
· Fixed bug with Unicode facet serialization
· Fixed problem with DevartEntityDeploySplit
· Fixed problem with metadata resources generation
· Fixed bug with App_Code subfolders
· Fixed bug with Many-to-Many associations
· Fixed several bugs in VB.NET code generation templates
· Fixed bug with "Trial period expired" on 64-bit Windows
· Fixed the "MSL Parsing failed" problem on some model opening
· Fixed bug with Read Only attribute
· Fixed bug with Storage attribute setting
· Fixed bug with OtherKey attribute setting
· Fixed bug with model opening in case of manual association edit
· Fixed bug with Generate related property check box
· Entity Framework support
· Supported ADO.NET Entity Framework 4 Release Candidate
· 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)
· Fixed bug with Returning SQL
· Fixed bug with exception on Generate Database from Model
· Fixed bug with EndsWith method

What's new in dotConnect for MySQL Professional 5.50.79:

January 14th, 2010

· Supported parameterized commands in Reporting Services
· Supported stored procedures with cursors in reporting projects
· Fixed bug with inability to "Copy data from one or more tables or views" in SQL Server Import and Export Wizard
· Fixed bug with non-complete uninstall of dotConnect

LINQ to MySQL:
· Fixed the "Destabilize the runtime" problem

Entity Developer:
· Fixed bug with incorrect updating of the Project Explorer root node names

Entity Framework support:
· Fixed bug with EntitySQL BigCount function
· Fixed bug with 5.4.3 server version

What's new in dotConnect for MySQL Professional 5.50.62:

December 19th, 2009

LINQ to MySQL:
· Added support for case-insensitive comparison
· Changed exception type on the Single method not returning value
· Fixed bug with redundant quering of the nullable association end
· Fixed bug with DataContext.CommandTimeout

Entity Developer:
· Fixed bug with 'Generate Related property' serialization

What's new in dotConnect for MySQL Professional 5.50.57:

December 7th, 2009

· Implemented MySqlGuid class

Entity Developer:
· Fixed bug with the Custom.After.Microsoft.Common.targets file appending
· Fixed bug with inheritance and primary keys

What's new in dotConnect for MySQL Professional 5.50.54:

November 24th, 2009

· 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

LINQ to MySQL:
· Devart DbLinqDataSource component added
· Linq performance improved
· Supported navigation using properties (not only keys)
· Fixed issue with removing entities from EntitySet
· Fixed bug with EntitySet onAdd action
· Fixed bug with updating the detached object
· Fixed the security problem in medium trust environment

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
· Corrected the setting of Source and Table attribute for non-database objects
· Fixed bug with attach_Entity methods
· Fixed bug with access and inheritance modifiers for properties
· Fixed bug with out-parameters of stored procedures
· Fixed bug with LINQ to SQL code generation for out-parameters
· Fixed bug with procedures returning nullable types

Entity Framework support:
· Fixed bug with CommandText in case of stored procedures
· Fixed bug with out parameters in stored procedures

What's new in dotConnect for MySQL Professional 5.40.49:

October 22nd, 2009

· Added SchemaTable property to DbDataTable
· Added Enlist parameter to connection string

LINQ to MySQL:
· Fixed bug with the Attach() method
· Fixed bug with updating the associated entities
· Fixed the "Constant cannot be sequence" error
· Fixed bug with populating DataContext.GetCommand().Parameters collection
· Fixed bug with Single() method

Entity Developer:
· Fixed bug with wrong IDE configuration path
· Fixed bug with VS template
· Fixed bug with model placed in non-root project folder

What's new in dotConnect for MySQL Professional 5.40.44:

September 29th, 2009

· Fixed bugs in DataSet Wizard with Web Service projects
· Fixed bug with licensing projects using wizard in nested folders of solution

· LINQ to MySQL
· Supported DataContext.CommandTimeout property
· Supported DeleteOnNull attribute of association and changed default behaviour (DeleteOnNull=false now)

· Entity Developer
· Added support for EF Precision and Scale facets
· Improved MS EDM Designer compatibility
· Fixed bug with using Entity Developer in Web Site projects

· Entity Framework support
· Increased performance for StartsWith, Contains and EndsWith methods

What's new in dotConnect for MySQL Professional 5.40.42:

September 19th, 2009

· Fixed bug with licensing Startup projects
· Fixed bug with using String.Format function computed at client side
· Fixed bug with TransactionScope on Dispose()

LINQ to MySQL:
· Fixed some CompiledQuery bugs
· Fixed bug with using objects from different contexts
· Fixed bug with String.IsNullOrEmpty() function

Entity Developer:
· Added design time support for some EF facets
· Enabled adding Schema name as prefix
· Fixed bug with the connection reopen on refresh

What's new in dotConnect for MySQL Professional 5.40.39:

August 12th, 2009

· TransactionScope supported
· Added some installation command line options
· Fixed bug with dotConnects and dbForge Fusion integration

Entity Developer:
· Fixed bug with Entity Set pluralization naming rule
· Fixed bug with EntitySet property deserialization
· Fixed bug with Source property for the added classes
· Fixed bug with connection string quotation for the standalone projects
· Fixed bug with the serialization of property accessors

What's new in dotConnect for MySQL Professional 5.40.37:

July 18th, 2009

· 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
· Fixed bug with special symbols in the names of database objects

LINQ to MySQL:
· Added support of the String.IsNullOrEmpty() method
· Fixed bug with nested LoadWith() methods on the query level
· Fixed bug with inserting parent and several child entities in one InsertOnSubmit() when keys are db-generated
· Fixed bug with the AssociateWith() method and VB.NET
· Fixed bug with stored procedures and INOUT params

Entity Developer:
· 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
· Fixed bug with namespaces
· Fixed bug with invisible OK button in Association Editor
· Fixed bug with tags
· Fixed bug with XML Comments serialization

What's new in dotConnect for MySQL Professional 5.20.29:

May 14th, 2009

· The Charset property supported
· The PingInterval property for connection maintaining supported
· Fixed bug with Entity Data Model Wizard in case of ANSI_QUOTES SQL Mode
· 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
· Fixed bug with OnValidate()
· Fixed bug with associations based on non-Primary keys
· Fixed bug with SingleOrDefault and BLOBs
· Fixed bug with update of entities that declare a version member
· Fixed bug with transactions
· Fixed bug with ArgumentException in the Contains() method
· 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

What's new in dotConnect for MySQL Professional 5.20:

May 14th, 2009

· 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

What's new in dotConnect for MySQL Professional 5.00 Beta:

November 11th, 2008

· 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)

What's new in dotConnect for MySQL Professional 4.50:

February 28th, 2008

· 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

What's new in dotConnect for MySQL Professional 4.00:

May 7th, 2007

· 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
· 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 MySQLDirect .NET information to Visual Studio 2005 splash screen and About box
· MySQL Developer 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