dotConnect for MySQL Changelog

What's new in dotConnect for MySQL 9.3.10

Jan 18, 2024

.NET 8 compatibility
Visual Studio 2022 version 17.9 Preview is supported
Entity Framework support:
Entity Framework Core 8.0.0 is supported
Entity Framework Core 7.0.14 is supported
Entity Framework Core 6.0.25 is supported
LinqConnect (formerly known as LINQ to MySQL):
.NET 8 compatibility
Entity Developer:
EF Core 8 is added to the list of available Entity Framework versions in Create Model Wizard and Model Settings in EF Core Model
.NET 8 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF, EF Core, and LinqConnect models
The new extended property Do Not Generate OnConfiguring Method is added for the model in EF Core Model
The bug with naming of local variables in the code generated for invoking stored procedures and functions with parameters in EF Core is fixed
The bug with unnecessary generation of the GetByKey() method in a repository for entities without primary key (QueryType=True) in EF Core is fixed
The bug with wrongly turned on without the ability to turn off options "Detect Many-to-Many associations" and "Detect Table-Per-Type inheritances" in Model Settings of EF Core 1, 2, 3 models is fixed
The bug with the availability of the "Table-Per-Type Hierarchy (TPT)" option in the "Model Refactoring" dialog of EF Core 1, 2, 3 models is fixed
The bug with the availability of the "Table-Per-Concrete-Type Hierarchy (TPC)" option in the "Model Refactoring" dialog of EF Core 1, 2, 3, 5, 6 models is fixed
The hang of Visual Studio 2022 when saving the model is fixed

New in dotConnect for MySQL 9.2.0 (Nov 17, 2023)

New in dotConnect for MySQL 9.1.151 (Jun 6, 2023)

New in dotConnect for MySQL 9.1.134 (Mar 3, 2023)

New in dotConnect for MySQL 9.0.0 (Jul 1, 2022)

New in dotConnect for MySQL 8.21.2066 (Jan 25, 2022)

Entity Developer:
The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
The behavior is changed: Devart.Data.MySql.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models
Entity Framework support:
Mapping of internet/intranet data type System.Uri to MySQL string data types is supported in EF Core 3, EF Core 5, EF Core 6
Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to MySQL string data types is supported in EF Core 5 and EF Core 6
The SQL translation of the following class members used in LINQ query is supported in EF Core 3, EF Core 5, EF Core 6:
static method IsNullOrWhiteSpace() of the String class
static property Today and instance property DayOfWeek of the DateTime class
static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the Math class
The SQL translation of the following class members used in LINQ query is supported in EF Core 5 and EF Core 6:
static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the MathF class
The SQL translation of the following class members used in LINQ query is supported in EF Core 6:
static method Log2() of the Math and MathF classes
The new EntityEF5net47Devart.Data.MySql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
The new EntityEF5net47Devart.Data.MySql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
The new EntityEF5net47Devart.Data.MySql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added
The new methods ExtractAsByte(), ExtractAsSByte(), ExtractAsInt16(), ExtractAsInt32(), ExtractAsInt64(), ExtractAsSingle(), ExtractAsDouble(), ExtractAsDecimal(), ExtractAsDateTime() are added to the MySqlJsonFunctions class for working with the JSON data type in LINQ to Entities queries
The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed

New in dotConnect for MySQL 8.20.2042 (Dec 21, 2021)

New in dotConnect for MySQL 8.19.2014 (Nov 9, 2021)

New in dotConnect for MySQL 8.19.2001 (Oct 21, 2021)

New in dotConnect for MySQL 8.19.1985 (Sep 28, 2021)

New in dotConnect for MySQL 8.19.1944 (Jul 30, 2021)

New in dotConnect for MySQL 8.19.1930 (Jul 8, 2021)

New in dotConnect for MySQL 8.19.1905 (Jun 3, 2021)

New in dotConnect for MySQL 8.19.1866 (Apr 11, 2021)

New in dotConnect for MySQL 8.19.1860 (Apr 1, 2021)

Visual Studio 2019 version 16.10 Preview is supported:
Using SslStream to create SSL connections for .NET Standard (.NET Core) Projects is implemented
Additional mode of parameter substitution in the query in the SSIS Data Flow Source component: substitution as is, without escaping
The bug with a DateTime variable in the SSIS Source component is fixed
Entity Developer:
.NET 6.0 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF Core, EF6, LinqConnect models
The new extended property Record Type is added for classes in the case of C# EF Core template to generate records instead of classes in C# 9.0 or higher and .NET 5 or higher
The new options "Private setter for store generated properties" and "Constructor parameter" are added to Model Settings in EF Core for controlling visibility of setter for store generated properties
The new options "Don't show this message again" in the prompt window and "Prompt before generating code when there are model validation warnings" in the menu Options are implemented in a standalone Entity Developer to provide the ability not to stop code generation by warnings
The new extended property Do Not Generate Default Constructor is added to EF Core Model for model, classes, and complex types
The new extended property Do Not Generate Mapping is added to EF Core Model for class properties
The JSON (Newtonsoft.Json, Microsoft.Text.Json) and YAML (YamlDotNet) serializations are supported in EF Core (via EF Core template) and EF6 (via DbContext template):
The new template property Serialization Library is added for specifying the library used for serialization
The new template property Serialize Original Column Names is added for controlling the appearance of original column names in serialization
The new template property Serialize Navigation Properties is added for controlling the appearance of navigation properties in serialization
The new template property Serialize Null Value is added for managing the behavior of nullable properties
The new extended property Do Not Serialize is added for properties and navigation properties to exclude them from serialization
The new extended property Serialization Name is added for properties and navigation properties to set custom names in serialization
The Data Transfer Object template is improved:
The new template property Serialization Library is added for specifying library used for serialization, possible values are Data Contract, JSON (Newtonsoft.Json), JSON (Microsoft.Text.Json), YamlDotNet
The new extended property Do Not Serialize is added for properties and navigation properties to exclude them from serialization
The new extended property Serialization Name is added for properties and navigation properties to set custom names in serialization
The behavior is changed: WCF Data Contract Attributes is set to False by default now
The following properties are marked as obsolete:
the Generate Data Contracts property of the EF Core template
the Do Not Generate Data Contract Attribute extended property of navigation properties in EF Core Model
the WCF Data Contract Attributes property of the DbContext and Data Transfer Object templates
the WCF DataMember Attribute on Navigation Properties property of the DbContext and Data Transfer Object templates
The bug with creating app.config in Visual Studio .NET Core projects is fixed
The bug with detecting the existing classes with QueryType=True by Update From Database Wizard in EF Core Model is fixed
The bug with incorrect detecting DatabaseGeneratedOption.Identity for the properties with DEFAULT NULL in a database, when "Detect function-based column default value" is selected in Create Model Wizard, is fixed in EF4/EF5/EF6
Entity Framework support:
Entity Framework Core 5.0.4 is supported
Entity Framework Core 3.1.13 is supported

New in dotConnect for MySQL 8.19.1836 (Feb 19, 2021)

New in dotConnect for MySQL 8.19.1812 (Jan 15, 2021)

The bug with blocking thread during retrieving a connection from the pool, when connections from the same pool are used in several threads, is fixed
Entity Developer:
The new attribute DisplayName is implemented for model objects' extended properties which are available via template properties
The new options --ContextNamespace and --DefaultNamespace are added to the Create-Model command of Console Entity Developer
The new extended model property Base Context Type is added for specifying a parent class for the generated context in EF Core Model
The new extended properties Base Type for complex types and Base Complex Type for model are implemented in EF Core Model
The %type name% keyword is supported in the Base Type extended property of entities and complex types, and in Base Complex Type, Base Entity Type, Base Context Type extended model properties for setting generic base type in EF Core Model
Code generation is improved: RelationalIndexBuilderExtensions.HasDatabaseName is generated now instead of RelationalIndexBuilderExtensions.HasName in EF Core 5
Display names of extended properties in EF Core Model are updated: Entity Base is renamed to Base Type in class properties, Entity Base is renamed to Base Entity Type in model properties, Context Base is renamed to Base Context Type in model properties
The bug with setting additional keyboard mapping scheme via menu Options on Windows with German display language is fixed
LinqConnect (formerly known as LINQ to MySQL):
The new property Local is added to the Table and Table<T> classes to return a collection of the entities attached to the context
The new method GetEntityState(object entity) is added to Table class and ITable interface to return one of the EntityState values
The bug with throwing "Bad key member '...' in association '...' of type '...'." in runtime by .NET Standard compliant assemblies is fixed
Entity Framework support:
Entity Framework Core 5.0.2 is supported
Entity Framework Core 3.1.11 is supported
The new metadata to describe autoincremental columns via annotations in EF Core Code-First Migrations are implemented

New in dotConnect for MySQL 8.19.1792 (Dec 17, 2020)

New in dotConnect for MySQL 8.19.1782 (Dec 3, 2020)

New in dotConnect for MySQL 8.18.1759 (Oct 29, 2020)

New in dotConnect for MySQL 8.18.1739 (Oct 1, 2020)

New in dotConnect for MySQL 8.18.1730 (Sep 17, 2020)

New in dotConnect for MySQL 7.18.1730 (Sep 17, 2020)

New in dotConnect for MySQL 8.17.1696 (Jul 30, 2020)

New in dotConnect for MySQL 8.17.1686 (Jul 16, 2020)

New in dotConnect for MySQL 8.17.1666 (Jun 17, 2020)

Visual Studio 2019 version 16.7 Preview is supported
The sqlite3.dll library that is included into the installation package is updated to version 3.32.2
Entity Developer:
.NET 5 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF6, EF Core, LinqConnect models
The new option "Execute procedures for result set detection" is added to Model Settings of EF Core Model to control obtaining metadata of a procedure or function result set
The new option "Use NULL parameter values" is added to Model Settings of EF Core Model to specify whether NULL parameter values are used for stored procedure execution
The new option "Add complex types to diagram" is added to Model Settings of EF Core Model to control behavior of Create Model Wizard and Update Model From Database Wizard
The new option "Add new complex types to the current diagram" is added to Update Model From Database Wizard of EF Core Model
The new Primitive Default Value Generation property is added to EF, EF Core templates to determine whether to generate initialization for a primitive property based on database DEFAULT column value
The new property Collection Property Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used as a property type for the Many end of associations
The new property Collection Initialization Type is added to EF template "DbContext" and EF Core template "EF Core" to determine .NET type used for initialization of the Many end of association; if it is set to None, then no initialization is generated
The new property "Nullable Reference Types" is added to C# templates of EF, EF Core models to specify whether C# 8 nullable reference types and non-nullable reference types must be generated
The new partial method is added to the OnModelCreating(DbModelBuilder modelBuilder) method generated by DbContext template of EF model
The EF Core model deserialization is improved: Entity Developer shows the full list of detected errors and tries to load the model with invalid elements or ignores such elements if their deserialization is not possible
Console Entity Developer improvements:
Import of stored procedures and functions via Create-Model command is supported
The new options --Procedures and --Functions are added to Create-Model command for filtering stored procedures and functions; by default all procedures/functions are imported
The new option --Execute is added to Create-Model command for executing procedures/functions to get metadata from result set
The asterisk symbol (*) is supported in --Tables and --Views parameters of Create-Model to include all objects
The bug with opening connection via some supported providers is fixed
The bug with enumerating values separated with comma and without whitespace in --Templates, --Schemas, --Tables parameters is fixed
The DbProviderFactories registration is implemented in Create Model Wizard for EF6 models and .NET Framework provider assemblies
The new property Target Framework is added to Create Model Wizard and Model Settings of EF6 models
The compatibility issue with JetBrains ReSharper is fixed
The behavior is changed: the definition of auto-implemented property is put now on the single line with
C# DbContext template of Devart Entity Model when ImplementINotifyPropertyChanging=False and ImplementINotifyPropertyChanged=False and PropertyChangePartialMethods=False
C# EF Core template of Devart EF Core Model when PropertyChangeNotifiers=False and PropertyChangePartialMethods=False
The behavior for the new EF, EF Core models is changed: Primitive Default Value Generation is set to Literal now instead of LiteralOrExpression
The behavior is changed: the names of system types are generated without "System." prefix now in EF Core models; for example, it is DateTime instead of System.DateTime
The behavior is changed: only one confirmation for executing stored procedure is requested by Entity Developer when drag&drop-ing procedure from Database Explorer to Model Explorer or diagram surface
The behavior is changed: now the EF Core template generates an additional partial class for the context class when "File Per Class" and "Generate Partial Class" are set to True
The bug with detecting strings, being expressions, as string literals when generating initialization of string properties basing on database columns' default values in EF, EF Core models is fixed
The bug with missing default value in the generated code basing on DEFAULT value in a database, when any of ImplementINotifyPropertyChanging, ImplementINotifyPropertyChanged, PropertyChangePartialMethods options of DbContext template in EF is turned on, is fixed
The bug with code generation for zero-or-one to zero-or-one association in the EF6 model with the DbContext template (Fluent Mapping=True) is fixed
The bug with generating .HasMany end of one-to-many association in EF Core Model is fixed
The bug with generating TPH mapping in EF Core 3 model is fixed
The bug with false appearing the "Table or view '...' has no primary key columns, and the entity key for the corresponding storage entity was calculated automatically from other fields." warning in the Error List window is fixed
The bug with generating new Guid() with Primitive Default Value Generation=Literal in EF, EF Core models is fixed
LinqConnect (formerly known as LINQ to SQLite):
The bug with materializing elements, the types of which are explicitly converted from non-nullable to nullable on the client side, is fixed
The bug with incorrect detection of altered column comment in a many-to-many association join table by Update From Database Wizard is fixed
Entity Framework support:
Entity Framework 6.4.4 is supported
The translation of the DateTime.AddMinutes() method in LINQ query into SQL statement in EF Core is supported
The bug with adding / subtracting DateTime and TimeSpan, DateTimeOffset and TimeSpan values in LINQ query in EF Core 3 is fixed
The bug with SQL generation in EF Core 3, when enum values are used in CASE and COALESCE statements, is fixed
The EF6 provider registration used with .NET Standard compliant assemblies is improved: the [DbConfigurationType(typeof(SQLiteEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation

New in dotConnect for MySQL 8.17.1612 (Apr 2, 2020)

New in dotConnect for MySQL 8.17.1583 (Feb 20, 2020)

New in dotConnect for MySQL 8.16.1541 (Dec 23, 2019)

Visual Studio 2019 version 16.5 Preview is supported
The bug with using Toolbox component MySqlDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
The bug with enabling Devart DataSet Editor in Visual Studio 2017 and Visual Studio 2019 is fixed
LinqConnect (formerly known as LINQ to MySQL):
The bug with using Toolbox component DbLinqDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
Entity Developer:
The bug with creating one-to-one association basing on an optional FK in EF Core Model is fixed
The bug with code generation for oneOrZero-to-one and one-to-many associations based on an optional FK in EF Core Model is fixed
The bug with generating a mapping for a unique constraint specified in owned type property of EF Core Model is fixed
Entity Framework support:
Entity Framework 6.4 is supported
Entity Framework Core 3.1 is supported
The new EntityEFCore3Devart.Data.Oracle.Entity.EFCore.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
The new config.CodeFirstOptions.TruncateAllLongNames option (default value is False) is added to use EF Core 2/EF Core 3 implementation for truncating long names of columns and PK/FK/IX/UX
The config.DatabaseScript.ForeignKey.IndexCreation configuration option is supported in EF Core 1/EF Core 2/EF Core 3
The RenameColumn operation translated to ALTER TABLE RENAME COLUMN is supported for MySQL 8.0 and higher via Code-First Migrations in EF4/EF5/EF6/EF Core 1/EF Core 2/EF Core 3
The behavior is changed: System.Decimal is mapped now to MySQL data type DECIMAL(58,29) instead of DECIMAL by Code-First Migrations in EF Core 1/EF Core 2/EF Core 3
The bug with creating a unique constraint in the database via EF Core Code-First Migrations is fixed
The bug with applying .ValueGeneratedOnAdd() to the string, guid, byte[] properties with .Key() and without .HasDefaultValueSql() in EF Core is fixed
The error message with notification about missing annotation for the RenameColumn operation translated to ALTER TABLE CHANGE COLUMN in case of MySQL versions lower than 8.0 is fixed
The bug with detecting implicit database column type, when model mapping and migration mapping are different, via EF Core Code-First Migrations is fixed
The bug with generating SQL when using explicit cast in LINQ queries in EF Core 1/EF Core 2 is fixed
The bug with throwing the "Null TypeMapping in Sql Tree" error by methods in LINQ query in EF Core 3 is fixed

New in dotConnect for MySQL 8.15.1519 (Nov 21, 2019)

New in dotConnect for MySQL 8.15.1504 (Oct 31, 2019)

New in dotConnect for MySQL 8.15.1499 (Oct 24, 2019)

New in dotConnect for MySQL 8.14.1470 (Sep 13, 2019)

New in dotConnect for MySQL 8.13.1437 (Jul 25, 2019)

New in dotConnect for MySQL 8.13.1422 (Jul 4, 2019)

New in dotConnect for MySQL 8.13.1402 (Jun 6, 2019)

New in dotConnect for MySQL 8.13.1366 (Apr 12, 2019)

New in dotConnect for MySQL 8.12.1357 (Mar 28, 2019)

New in dotConnect for MySQL 8.12.1328 (Feb 14, 2019)

New in dotConnect for MySQL 8.12.1307 (Jan 10, 2019)

The behavior is changed: now "Unicode=true;" sets client character set to utf8mb4 for MySQL Server 5.5.3 and higher
The bug with connecting to database with .NET Standard 1.3 compatible assemblies on .NET Framework 4.6.0 run-time is fixed
LinqConnect (formerly known as LINQ to MySQL):
The new overload DataContext.Refresh(bool ignoreErrors, RefreshMode mode, object entity) is added for ignoring errors during refresh
The existing overload DataContext.Refresh(RefreshMode mode, object entity) is improved: its check avoids the try to refresh the entity that is added to the context but not submitted to the database
The type and text of the error generated by the DataContext.Refresh(RefreshMode mode, object entity) method, when the passed entity doesn't exist in database, is fixed
The bug with generating the COALESCE expression is fixed
Entity Developer:
The multiple select functionality in EF Core Model is improved: now it allows setting PrimaryKey, ValueGenerated, Concurrency for several properties simultaneously
The bug with detecting order of columns in composite primary key with two or more columns by Update To Database and by Update From Database wizards in EF Core is fixed
The bug with using ASP.NET Core Web Application (.NET Framework) and Azure Functions v1 (.NET Framework) projects in Visual Studio 2017 is fixed
Entity Framework support:
Entity Framework Core 2.2.1 is supported
The new extension method Database.IsMySql() in EF Core 2 is implemented
The config.QueryOptions.NullStringCollation option is implemented to use the COLLATE operator with a required collation when comparing null strings in "equal" and "not equal" cases
The bug with applying config.Workarounds.IgnoreSchemaName=true to the .ToTable() functionality in EF Core 2 is fixed
The bugs with using the GuidToStringConverter, EnumToStringConverter, ValueConverter classes in EF Core 2 are fixed
The bug with constructing the LIKE clause in EF Core 2 is fixed
The bug with generating a subselect within the SELECT list in EF Core 2 is fixed
The bug with applying an aggregate function to the result of a subselect in EF Core 2 is fixed

New in dotConnect for MySQL 8.12.1278 (Nov 29, 2018)

Access to the aspnet_membership table is optimized
The bug with the incorrect type of the "Comment" column in the metadata table, returned by the MySqlConnection.GetSchema("Procedures",...) method or DESCRIBE query for MySQL 8.0, is fixed
LinqConnect (formerly known as LINQ to MySQL)
The bug with throwing "Operation could destabilize the runtime." during materialization of result set, when query includes a cast to the base unmapped class, is fixed
Entity Developer
The new Generate GeneratedCode Attributes option (by default, False) is added to the DbContext template in EF4/EF5/EF6 and the EF Core template
The new Generate Dummy Comments option (by default, False) is added to the DbContext template in EF4/EF5/EF6
The code formatting is fixed in the DbContext template in EF4/EF5/EF6 and the EF Core template
The code generation of DateTime.Now for the DateTime property mapped to the column with the default value NOW() is supported in EF and EF Core
The code generation of DateTimeOffset.Now for the DateTimeOffset property mapped to the column with the default value NOW() is supported in EF and EF Core
The bug with generating fluent mapping for the TPC inheritance by VB.NET version of DbContext template in EF4/EF5/EF6 is fixed
Entity Framework support
The bug with quoting the table alias, that includes an invalid character, in the SQL query generated by EF Core is fixed
The bug with generating a subquery within the IN clause in EF Core 2 is fixed
The bug with generating a subselect within the CASE clause in EF Core 2 is fixed
The bug with comparing columns, that use a value converter, to parameters and constants in EF Core 2 is fixed
The bug with loading both Devart.Data.MySql.Entity.EF4.dll and Devart.Data.MySql.Entity.EF5.dll in the process of EF4 application is fixed
The bug with loosing precision of DateTimeOffset properties in EF6 / EF Core Code-First is fixed
The bug with quoting the zero date default value in the generated SQL by CreateDatabase() in EF4/EF5/EF6 is fixed

New in dotConnect for MySQL 8.12.1253 (Oct 25, 2018)

New in dotConnect for MySQL 8.12.1229 (Sep 20, 2018)

New in dotConnect for MySQL 8.12.1216 (Aug 31, 2018)

New in dotConnect for MySQL 8.12.1202 (Aug 9, 2018)

New in dotConnect for MySQL 8.12.1190 (Jul 19, 2018)

New in dotConnect for MySQL 8.11.1172 (Jun 22, 2018)

New in dotConnect for MySQL 8.10.1152 (May 25, 2018)

New in dotConnect for MySQL 8.10.1134 (Apr 27, 2018)

New in dotConnect for MySQL 8.10.1115 (Mar 30, 2018)

The behavior is changed: the License Key connection string parameter value is not sent to the dbMonitor instance when "Persist Security Info=false;"
The bug with throwing the "IDE not supported" exception by DataSet Manager in Visual Studio 2017 of versions 15.6.* is fixed
LinqConnect (formerly known as LINQ to MySQL)
The XmlMappingSource.FromResource method is supported in .NET Standard provider assemblies
The behavior is changed: all existing overloads of the method DataContext.Query() are replaced with DataContext.Query(String,params Object[])
The behavior is changed: the License Key connection string parameter value is not sent to the LinqMonitor instance when "Persist Security Info=false;"
Entity Developer
The new Retrieve Cross Database Relations option is implemented in Model Settings for detecting FK relations between tables in different databases
The new SQL Type, Size, Precision, Scale options are added to the Parameters tab in Method Editor of EF Core Model (Entity Framework models)
The process of synchronizing methods and parameters with database stored procedures in EF Core Model is improved (Entity Framework models)
The bug with adding entry to appsettings.json, when "Use the following connection string from App.Config" and "Rewrite connection string during regeneration" in Model Settings are turned on, is fixed (Entity Framework models)
The bug with throwing the "Multiple constructors accepting all given argument types have been found in type '...'. There should only be one applicable constructor." error by the code generated with the MVC Controller template in ASP.NET Core Web Application is fixed (Entity Framework models)
The bug with missing DataMember attribute on the Many end of an association, when using the EF Core template with "Generate Data Contracts=True", is fixed (Entity Framework models)
The bug with the Retrieve Data functionality on the base class of TPH inheritance is fixed
The bug with the Find Next functionality of T4 Editor embedded into Visual Studio is fixed
The bug with throwing the "IDE not supported" exception by Entity Developer in Visual Studio 2017 of versions 15.6.* is fixed
Entity Framework support
Entity Framework Core 2.0.2 is supported

New in dotConnect for MySQL 8.10.1086 (Feb 15, 2018)

New in dotConnect for MySQL 8.10.1061 (Jan 12, 2018)

New in dotConnect for MySQL 8.10.1031 (Nov 24, 2017)

New in dotConnect for MySQL 8.10.1013 (Oct 30, 2017)

New in dotConnect for MySQL 8.9.980 (Sep 7, 2017)

New in dotConnect for MySQL 8.9.958 (Aug 4, 2017)

New in dotConnect for MySQL 8.9.946 (Jul 13, 2017)

New in dotConnect for MySQL 8.9.931 (Jun 23, 2017)

New in dotConnect for MySQL 8.9.912 (May 25, 2017)

New in dotConnect for MySQL 8.8.862 (Mar 17, 2017)

New in dotConnect for MySQL 8.7.852 (Mar 3, 2017)

New in dotConnect for MySQL 8.7.837 (Feb 9, 2017)

New in dotConnect for MySQL 8.7.832 (Feb 2, 2017)

New in dotConnect for MySQL 8.7.819 (Jan 17, 2017)

New in dotConnect for MySQL 8.7.804 (Dec 27, 2016)

New in dotConnect for MySQL 8.7.794 (Dec 9, 2016)

The 'Do not install assemblies in the GAC' check box that allows disabling placing the provider assemblies to the GAC is added to the Install Wizard
The bug with looking up a column with decimal(19,4) type for MySQL is fixed
The bug with generating an error when using MySqlMonitor on Linux is fixed
The bug with the "Query execution was interrupted" exception after invoking the Cancel method of MySqlCommand is fixed
The bug with not using parameters value in ParentRelation data in MySqlDataTable.SelectCommand is fixed
The bug with looking up a column with decimal(19,4) type for MySQL is fixed
LinqConnect:
The exception message for invoking CreateDatabase() for the model which includes an association with missing end is improved
The bug with submitting records to the database via a TPT inheritance is fixed
The bug with throwing System.InvalidCastException when inserting / updating the System.Object properties is fixed
Entity Developer:
The possibility to choose whether to add new entities to a diagram or not in Update From Database Wizard is implemented
The behaviour is changed: now the DbContext template generates an additional partial class for the context class when "File Per Class" and "Generate Partial Class" are set to True (Entity Framework models)
Entity Framework support:
Entity Framework Core 1.1.0 is supported
The Scaffold-DbContext NuGet command of Package Manager Console for generating a model basing on the existing database schema is supported in EF Core
Batch Updates support in EF Core is added
The MySqlJsonFunctions class is implemented in EF4/EF5/EF6 to use JSON functions in LINQ to Entities queries
The JSON datetype is supported in EF mapping
Signed versions of NetTopologySuite GIS library are supported in EF5/EF6
NetTopologySuite 1.14 is supported in EF5/EF6
GeoAPI 1.7.4 is supported in EF5/EF6
The NetTopologySuiteSigned and NetTopologySuiteUnsigned members are added to the SpatialServiceType enum in EF5/EF6
The config.DatabaseScript.Schema.DeleteDatabaseBehaviour option is supported in EF Core
The behaviour is changed: now by default System.DateTimeOffset is mapped to the datetime MySQL data type using CreateDatabase()/Code-First approach
The behaviour is changed: the functionality of SpatialServiceType.NetTopologySuiteSigned is moved to Devart.Data.MySql.Entity.EF5.dll / Devart.Data.MySql.Entity.EF6.dll
The bug with generating incorrect data types for 'tinytext', 'text', 'mediumtext' columns set via attribute / fluent mapping in the Code-First CreateDatabase/CreateDatabaseScript functionality is fixed
The bug with shortening PK, FK, IX, UX names in the Code-First CreateDatabase/CreateDatabaseScript functionality when config.CodeFirstOptions.TruncateLongDefaultNames=True is fixed
The bug with comparison in LINQ query when config.QueryOptions.UseCSharpNullComparisonBehavior=true is fixed
The bug with setting binary data types via Code-First mapping in EF4/EF5/EF6 is fixed
The bug with requesting extra privileges when preparing stored procedure is fixed
The bugs with logical expressions in EF Core are fixed

New in dotConnect for MySQL 8.6.763 (Oct 27, 2016)

New in dotConnect for MySQL 8.6.753 (Oct 18, 2016)

New in dotConnect for MySQL 8.6.743 (Sep 22, 2016)

New in dotConnect for MySQL 8.6.729 (Sep 22, 2016)

New in dotConnect for MySQL 8.6.714 (Aug 11, 2016)

New in dotConnect for MySQL 8.6.699 (Jul 22, 2016)

New in dotConnect for MySQL 8.6.687 (Jul 7, 2016)

New in dotConnect for MySQL 8.6.677 (Jun 24, 2016)

New in dotConnect for MySQL 8.6.667 (Jun 10, 2016)

New in dotConnect for MySQL 8.5.658 (May 29, 2016)

New in dotConnect for MySQL 8.5.649 (May 17, 2016)

New in dotConnect for MySQL 8.5.639 (Apr 25, 2016)

New in dotConnect for MySQL 8.4.616 (Mar 18, 2016)

New in dotConnect for MySQL 8.4.592 (Feb 11, 2016)

New in dotConnect for MySQL 8.4.583 (Jan 23, 2016)

New in dotConnect for MySQL 8.4.563 (Jan 22, 2016)

New in dotConnect for MySQL 8.4.558 (Jan 22, 2016)

New in dotConnect for MySQL 8.4.543 (Jan 22, 2016)

New in dotConnect for MySQL 8.4.535 (Jan 22, 2016)

New in dotConnect for MySQL 8.4.521 (Oct 22, 2015)

New in dotConnect for MySQL 8.4.506 (Oct 10, 2015)

New in dotConnect for MySQL 8.4.497 (Sep 18, 2015)

New in dotConnect for MySQL 8.4.492 (Sep 14, 2015)

New in dotConnect for MySQL 8.4.478 (Sep 14, 2015)

New in dotConnect for MySQL 8.4.464 (Jul 30, 2015)

New in dotConnect for MySQL 8.3.457 (Jul 17, 2015)

New in dotConnect for MySQL 8.3.447 (Jul 2, 2015)

New in dotConnect for MySQL 8.3.437 (Jun 22, 2015)

New in dotConnect for MySQL 8.3.422 (Jun 22, 2015)

New in dotConnect for MySQL 8.3.407 (May 7, 2015)

New in dotConnect for MySQL 8.3.397 (Apr 23, 2015)

New in dotConnect for MySQL 8.3.389 (Apr 9, 2015)

New in dotConnect for MySQL 8.3.379 (Mar 26, 2015)

New in dotConnect for MySQL 8.3.359 (Feb 26, 2015)

New in dotConnect for MySQL 8.3.352 (Feb 13, 2015)

New in dotConnect for MySQL 8.3.344 (Feb 2, 2015)

New in dotConnect for MySQL 8.3.342 (Jan 29, 2015)

New in dotConnect for MySQL 8.3.333 (Jan 15, 2015)

New in dotConnect for MySQL 8.3.313 (Dec 18, 2014)

New in dotConnect for MySQL 8.3.303 (Dec 4, 2014)

New in dotConnect for MySQL 8.3.293 (Nov 20, 2014)

New in dotConnect for MySQL 8.3.283 (Nov 20, 2014)

New in dotConnect for MySQL 8.3.274 (Nov 20, 2014)

New in dotConnect for MySQL 8.3.264 (Oct 9, 2014)

New in dotConnect for MySQL 8.3.254 (Sep 26, 2014)

New in dotConnect for MySQL 8.3.244 (Sep 11, 2014)

New in dotConnect for MySQL 8.3.239 (Sep 5, 2014)

The bug with changing the database name case to lower when executing the MySqlSyncDescriptionBuilder.GetDescriptionForTable method is fixed
The bug with returning 0 instead of -1 for all statements except UPDATE, DELETE, INSERT statements is fixed
The bug with invalid script when table has only primary key columns for Sync Framework support is fixed
LinqConnect (formerly known as LINQ to MySQL):
The bug related to the NullReferenceException on SubmitChanges, when working with association between classes involved in complex TPT hierarchy, is fixed
Entity Developer:
The Remove Invalid Characters option (by default, True) is added to the Model Naming rules; if it is set to False, all invalid characters will be replaced with underscores
The Enable WinForms Data Binding property of the DbContext template is implemented (Entity Framework models)
The Property Change Partial Methods property of the DbContext template is implemented for generating partial methods On%PropertyName%Changing and On%PropertyName%Changed for each primitive property of entity classes (Entity Framework models)
The behaviour is changed: now partial configuration classes are generated when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses options (Entity Framework models)
The bug with the wrong code generation for associations when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseAttributes options is fixed (Entity Framework models)
The bug with generating DatabaseGeneratedAttribute for non-EntityKey properties when using attribute mapping (DbContext template) is fixed (Entity Framework models)
The bug with generating DatabaseGeneratedAttribute for all EntityKey properties when using fluent mapping (DbContext template) is fixed (Entity Framework models)
The bug related to the "An error occurred during an attempt to compile the template 'LinqConnect'." error in Windows Store applications is fixed (LinqConnect models)

New in dotConnect for MySQL 8.3.225 (Aug 14, 2014)

New in dotConnect for MySQL 8.3.215 (Jul 31, 2014)

New in dotConnect for MySQL 8.3.201 (Jul 10, 2014)

New in dotConnect for MySQL 8.3.191 (Jun 26, 2014)

New in dotConnect for MySQL 8.3.181 (Jun 12, 2014)

New in dotConnect for MySQL 8.3.171 (May 29, 2014)

New in dotConnect for MySQL 8.3.161 (May 16, 2014)

New in dotConnect for MySQL 8.3.146 (Apr 25, 2014)

New in dotConnect for MySQL 8.3.135 (Apr 14, 2014)

New in dotConnect for MySQL 8.3.125 (Mar 27, 2014)

New in dotConnect for MySQL 8.3.115 (Mar 7, 2014)

New in dotConnect for MySQL 8.2.103 (Feb 20, 2014)

New in dotConnect for MySQL 8.2.100 (Feb 14, 2014)

New in dotConnect for MySQL 8.2.90 (Jan 30, 2014)

New in dotConnect for MySQL 8.2.80 (Jan 16, 2014)

New in dotConnect for MySQL 8.2.65 (Dec 27, 2013)

New in dotConnect for MySQL 8.2.55 (Dec 12, 2013)

New in dotConnect for MySQL 8.1.45 (Dec 12, 2013)

New in dotConnect for MySQL 8.1.36 (Dec 12, 2013)

New in dotConnect for MySQL 8.1.26 (Oct 31, 2013)

New in dotConnect for MySQL 8.0.17 (Oct 31, 2013)

New in dotConnect for MySQL 7.8.333.0 (Sep 23, 2013)

New in dotConnect for MySQL 7.8.322.0 (Sep 10, 2013)

SSIS DataFlow Source and Destination components for MySQL are implemented
The bug with an error occurring during opening a connection, and then this connection getting into the pool is fixed
The bug with the Caption property of the DataGridView column with the Devart DataTable component is fixed
The bug with detecting self-relations in Microsoft DataSet Wizard is fixed
LinqConnect (formerly known as LINQ to MySQL):
The possibility to use the extension method AsQueryable() in LINQ queries is added
The support for correct retrieving of the TimeSpan and DateTimeOffset values while materializing is added
The bug with eager loading is fixed
The bug with the redundant opened sessions is fixed
The bug with missing CreateCommand method in the DataProvider class is fixed
The bug related to the ArgumentNullException on SubmitChanges method when trying to update a row with the same values is fixed
Entity Developer:
The "Close the window when the generation completes successfully" option in the Generation Process window is implemented in the standalone Entity Developer
The "Rewrite connection string during regeneration" option (default value is True) of model settings is added to provide the possibility to turn off modifying connection string in *.config after model is saved first time (Entity Framework models)
The design time support for model-defined functions is added (Entity Framework models)
The behaviour is changed: now connection string is configured with the name of the assembly, where the model is located, in case when the context class is located in another assembly (Entity Framework models)
The bug with the Retrieve Data functionality of the model with the DbContext template, when its Fluent Mapping property is set to True, is fixed (Entity Framework models)
The bug related to the detection of Table Per Type inheritances as Table Per Concrete Type inheritances when opening an existing model is fixed (Entity Framework models)
The bug with parsing *.edmx is fixed (Entity Framework models)
The bug with generating "An item with the same key has already been added" error when using DbContext Template is fixed (Entity Framework models)
The bug with DbContext template, when its MappingGenerationStrategy is set to UseConfigurationClasses, generating fluent mapping for an association with turned off generation of one navigation property is fixed (Entity Framework models)
The bug with availability of the New Blank Template option of the Templates context menu in Model Explorer in the Entity Developer version integrated into Visual Studio is fixed
The bug with generating invalid code when using MVC View Advanced template is fixed

New in dotConnect for MySQL 7.7.301 (Aug 8, 2013)

The IncludeUse property of MySqlDump is implemented to specify whether to include the 'Use Database' statement in backup file
The IncludeDatabaseUsersOnly property of MySqlDump is implemented to include only users that have privileges in specified database in backup file
The CommitBatchSize property of MySqlDump is implemented to specify the size limit of a single insert statement with multiple values in the script
The support of asynchronous backing up and restoring for MySqlDump is implemented
The bug with compatibility of Devart.Data.MySql.Web.dll for .NET Framework 2 and 4 in Visual Studio 2010, that is automatically added to the project when adding the MySqlDataSource component to the web form, is fixed
Entity Developer:
The "Model Name As Files Prefix" property is implemented for the templates which generate classes for model entities
The possibility of adding custom attributes to enum members is implemented
The behaviour is changed: the possibility to exclude the generation of keys (primary, foreign) in "Update Database From Model" and "Generate Database Script From Model " wizards is added
The behaviour is changed: the possibility to add one-to-one associations with nullable foreign key properties is added (LinqConnect models)
The behaviour is changed: a table storage engine is not set explicitly in the generated DDL
The behaviour is changed: now by default MVC Controller template generates files in the model folder, MVC View Advanced template creates files in the Views model subfolder
The bug with breaking the parameters order in Generator Parameters Editor is fixed (LinqConnect models)
The bug with an error during a compilation of the 'LinqConnect' template for VB.NET projects in Visual Studio 2008 is fixed (LinqConnect models)
The bug with breaking the IdGenerator configuration after closing the model is fixed (LinqConnect models)
The bug with generating code by Self-Tracking Entity template is fixed (Entity Framework models)
The bug with parsing *.edmx is fixed
Entity Framework support:
The bug with converting data types when using Batch Updates is fixed

New in dotConnect for MySQL 7.7.287 (Jul 20, 2013)

SQL Server 2012 Reporting Services is supported
The bug with column order in DataTable, which is populated by the Fill method of the MySqlDataAdapter object, is fixed
LinqConnect (formerly known as LINQ to MySQL):
The bug related to the NRE on the CreateDatabase() method, when the navigation properties generation for one of the sides in one-to-one association is turned off, is fixed
The bug with wrong script generation on the CreateDatabase() method for one-to-one associations is fixed
The bug with materialization when converting decimal values is fixed
The bug related to the "Sequence contains no elements" exception when working with unmapped properties and PropertyChanging/PropertyChanged events is fixed
The bug related to materializing structs in the "select new" clause is fixed
The bug related to the "Method not found" exception when opening connection in LINQPad via LinqConnectDriver is fixed
Entity Developer:
Support for spatial data types in Entity Framework 5 and 6 is added
The behaviour is changed: a default value for the "Detect Table Per Type inheritances" option in Model settings is set to False
The bug related to the wrong Source values for foreign key properties when adding associations with the selected "Add foreign key properties to the child class" check box is fixed
The bug with applying RangeAttribute of the DataAnnotation validation framework for nullable properties is fixed
The bug with parsing *.edmx is fixed (Entity Framework models)
Entity Framework support:
Support for spatial data types in Entity Framework 5 and 6 is added
NetTopologySuite GIS library support in Entity Framework 5 and 6 is added
MySQL spatial 'geometry' data type support in Entity Framework 5 and 6 is added
Devart.Data.MySql.Entity.dll assembly built with the 4.5 version of .NET Framework is added
Devart.Data.MySql.Entity.Migrations.dll assembly built with the 5.0 version of EntityFramework.dll is added
The MySqlSpatialFunctions class for working with MySQL spatial functions in LINQ to Entities is added
The Database value is added to the DeleteDatabaseBehaviour enumeration for creating/removing database, which is specified in the Database connection string parameter, when using CreateDatabase()/DropDatabase() functionality
The config.Workarounds.UseInvariantProviderManifestToken configuration option (default value is False) is added to provide the possibility of returning the invariant string literal as the provider manifest token
The config.SqlFormatting.Identation option is renamed to config.SqlFormatting.Indenting
The bug with using delimiter when generating Code-First Migrations script via the ScriptUpdate method of the MigratorScriptingDecorator class in Entity Framework 6 is fixed

New in dotConnect for MySQL 7.6.267 (Jun 26, 2013)

The bug with the MySqlDataSource component in design time is fixed
The bug with generating typed Devart DataSet using a connection from *.config in the Visual Basic project is fixed
LinqConnect (formerly known as LINQ to MySQL)
The performance when working with the TPT-inheritance and retrieving descendants via OfType is improved
The bug with the CreateDatabase() method when "Delete Rule" is set for the association (not empty and not "NO ACTION") is fixed
The bug related to the "The non-nullable navigation property '...' was set to null in the entity object '...'" error when working with nullable composite foreign keys is fixed
The bug related to working with the WCF Ria Domain Service template is fixed
The bug with the TPT-inheritance and associations to the descendants of the inheritance is fixed
The bug related to the "Violation of PRIMARY KEY constraint" error on SubmitChanges(), when DataContext has only one added entity for insertion with a custom key generator and DbGenerated=False for its primary key, is fixed
Entity Developer
The behaviour is changed: DatabaseGeneratedOption is always generated for EntityKey properties when using fluent mapping (Entity Framework models)
The bug with wrong code generation for nullable enum properties is fixed
The bug with generating "Access Denied" error when using MVC templates is fixed
The bug with a serialization of stored procedures mapping to CUD operations in an association is fixed (Entity Framework models)
The bug with ordering parameters of a method when Update From Database Wizard adds/removes parameters to the method signature is fixed (Entity Framework models)
The bug with parsing *.edmx which includes an association, which has different values in a navigation property name and a role at the same end, is fixed (Entity Framework models)
Entity Framework support
The config.DatabaseScript.ForeignKey.Enabled option (default value is True) is added to turn on/off generation of foreign key constraints
The config.DatabaseScript.ForeignKey.IndexCreation option (default value is False) is added to turn on/off generation of indexes, created for the columns being parts of the foreign key, when using CreateDatabase() functionality

New in dotConnect for MySQL 7.6.257 (Jun 14, 2013)

New in dotConnect for MySQL 7.6.252 (May 31, 2013)

New in dotConnect for MySQL 7.6.242 (May 31, 2013)

LinqConnect (formerly known as LINQ to MySQL):
The possibility to disable query cache via the DataContext's 'EntityCachingMode' property is added
The bug with inheriting an entity class from an unmapped type is fixed
The bug related to the 'Index was outside of the bounds of the array' error when using GroupBy in queries is fixed
The bug with the materializer cache and AssociateWith method is fixed
The bug with the CreatedDatabase() method for many-to-many associations is fixed
The bug with AddDays() method with negative parameters is fixed
The bug with inserting record with composite primary key is fixed
Entity Developer:
The Save and Refresh buttons for persisting and reloading changes to / from a database is added to the Retrieve Data grid
POCO Entity template is improved: new template setting, "Property Change Notifiers", is added (LinqConnect models)
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)
The bug with wrong detecting many-to-many associations is fixed (LinqConnect models)
The bug related to the "Unknown column 'DATETIME_PRECISION' in 'field list'" error when creating model for MySQL 6.0.10-alpha-community is fixed (LinqConnect models)
The bug with quoting function name in the Default Value attribute of the timestamp property in Update To Database/Generate Database Script wizards is fixed (Entity Framework models)
The bug with mapping nested complex data types in the MSL part of the model in the synchronization mode is fixed (Entity Framework models)
Entity Framework support:
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

New in dotConnect for MySQL 7.6.226 (May 1, 2013)

New in dotConnect for MySQL 7.5.202 (Mar 16, 2013)

New in dotConnect for MySQL 7.5.192 (Mar 2, 2013)

New in dotConnect for MySQL 7.4.179 (Mar 2, 2013)

New in dotConnect for MySQL 7.4.164 (Jan 22, 2013)

New in dotConnect for MySQL 7.3.146 (Dec 27, 2012)

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')
The bug, that occurred when editing an existing Dataset in DataSet Wizard and which was associated with incorrect processing of 'Select command text' for Data tables having DataSource set to TableAdapter, is fixed
LinqConnect (formerly known as LINQ to MySQL):
The bug related to the "Object does not match target type" exception when working with DbLinqDataSources and gridviews is fixed
The bug with the implicitly converting strings to integer type in queries when working with VB.NET projects is fixed
The bug related to the "Unsupported delete rule 'NO ACTION'" exception when creating DataContext is fixed
The bug with update commands for dependent entities that participate in Table Per Type inheritance is fixed
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)
The bug with generating a code for the initialization of the boolean property is fixed (LinqConnect models)

New in dotConnect for MySQL 7.2.132 (Nov 30, 2012)

New in dotConnect for MySQL 7.2.122 (Nov 19, 2012)

New in dotConnect for MySQL 7.2.114 (Nov 5, 2012)

New in dotConnect for MySQL 7.2.104 (Oct 20, 2012)

New in dotConnect for MySQL 7.2.96 (Oct 5, 2012)

New in dotConnect for MySQL 7.2.77 (Sep 6, 2012)

New in dotConnect for MySQL 7.1.58 (Aug 13, 2012)

New in dotConnect for MySQL 7.1.40 (Jul 19, 2012)

New in dotConnect for MySQL 7.0.25 (Jun 23, 2012)

New in dotConnect for MySQL 7.0.17 (Jun 12, 2012)

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 behaviour is changed: the 'sender' parameter in MonitorEventHandler is a connection and the MonitorEventArgs.ExtraInfo property is filled with the connection string
LinqConnect (formerly known as LINQ to MySQL):
The CreateDatabase bug with creating a table for an entity type with multiple complex type fields is fixed
The CreateDatabase bug with creating a table for an entity type with no primary key is fixed
The bug with 'IS NULL' checks for non-nullable columns is fixed
Entity Developer:
The bug with the failure to read the complex type's Access property value is fixed (Entity Framework models)
The bug with saving *.edml when importing data from *.edmx is fixed (Entity Framework models)
Entity Framework support:
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
The bug with quoting indexes in Code-First Migrations is fixed
The bug with HistoryTable in Code-First Migrations when using the DisableQuoting option is fixed
The bug with generating invalid SQL statement for the DropPrimaryKey operation in Code-First Migrations is fixed
The bug with adding a schema prefix to default constraint name (PK and FK) in Code-First Migrations is fixed

New in dotConnect for MySQL 7.0.6 (Jun 12, 2012)

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 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)
The behaviour is changed: the CSDL property is left unchanged when the corresponding SSDL property is regenerated (Entity Framework models)
The behaviour is changed: the association names are generated basing on the database FK names when using Database First approach (Entity Framework models)
The bug with reading one-to-many associations from the *.edmx file is fixed (Entity Framework models)
The bug with "DevartEntityDeploy" task when only .NET Framework 4 is installed is fixed (Entity Framework models)
The bug with closing connection in the generated method of the context is fixed (Entity Framework models)
The bug with generating code using DbContext template, when template's Fluent Mapping property is set to True and one of the navigation properties of an association is turned off, is fixed (Entity Framework models)
The bug with incorrect saving of method's extended properties is fixed (LinqConnect models)
Entity Framework support:
Entity Framework 5.0 Release Candidate is supported
The support of fractional seconds for TIME, DATETIME and TIMESTAMP in Entity Data Model Wizard/Generate Database Wizard and Code-First CreateDatabase functionality is added

New in dotConnect for MySQL 6.80.350 (May 4, 2012)

New in dotConnect for MySQL 6.80.341 (Apr 12, 2012)

New in dotConnect for MySQL 6.80.325 (Mar 19, 2012)

New in dotConnect for MySQL 6.70.311 (Feb 28, 2012)

New in dotConnect for MySQL 6.70.302 (Feb 11, 2012)

New in dotConnect for MySQL 6.70.293 (Jan 28, 2012)

New in dotConnect for MySQL 6.60.283 (Jan 13, 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

New in dotConnect for MySQL 6.60.268 (Dec 23, 2011)

New in dotConnect for MySQL 6.60.258 (Dec 10, 2011)

New in dotConnect for MySQL 6.50.250 (Nov 25, 2011)

New in dotConnect for MySQL 6.50.244 (Nov 12, 2011)

New in dotConnect for MySQL 6.50.237 (Oct 21, 2011)

New in dotConnect for MySQL 6.50.228 (Sep 30, 2011)

New in dotConnect for MySQL 6.50.214 (Sep 6, 2011)

New in dotConnect for MySQL 6.30.202 (Aug 11, 2011)

New in dotConnect for MySQL 6.30.185 (Jul 9, 2011)

New in dotConnect for MySQL 6.30.172 (Jun 16, 2011)

New in dotConnect for MySQL 6.30.165 (Jun 2, 2011)

New in dotConnect for MySQL 6.30.160 (May 18, 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