Devart LinqConnect History

3.2.82 26-Apr-12

Entity Developer

The multiline popup editor for the Documentation.Summary property is implemented

3.2.73 12-Apr-12

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

3.2.64 29-Mar-12

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 the "Update Model From Database" wizard showing isVersion columns as changed is fixed

3.2.57 15-Mar-12

Visual Studio 11 Beta is supported
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 retrieving database metadata on Windows Azure is fixed
The bug with generating mappings for many-to-many association of entity to itself is fixed

3.1.43 27-Feb-12

The bug with reading GUIDs from SQLite databases is fixed

Entity Developer

The validation of method parameters 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 diagram design is changed: an arrow (instead of a triangle) is used on the tip of an association now
The bug with the "Update Model From Database" wizard showing identity columns as changed is fixed (Microsoft SQL Server)
The bug with setting comments for columns and tables in database is fixed

3.1.34 09-Feb-12

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 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
The bug with parsing PgSqlConnection.ServerVersion for Beta editions of PostgreSQL server is fixed

3.1.25 27-Jan-12

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 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 (MySQL)
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 line breaks in default values of NUMBER columns is fixed (Oracle)

3.1.23 12-Jan-12

Entity Developer

The documentation generation for Enum members is implemented
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 behaviour is changed: the DATETIME2 data type is now used for columns, corresponding to System.DateTime properties, for Microsoft SQL Server 2008 and later
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
The bug with generating sequences and triggers for auto-incremented primary keys mapped to the properties of the System.Decimal type is fixed (Oracle)
The bug with constructing too long names when using Generate Database Script From Model is fixed (Oracle)

3.1.21 22-Dec-11

The bug with inserting entities having a many-to-many association and auto-generated keys is fixed (MySQL)

Entity Developer

The behaviour is changed: the 'Real' SQLite data type is now mapped to System.Double by default
The bug with Visual Basic templates is fixed
The bug with scanning the network, when setting the connection to the PostgreSQL server, is fixed

3.1.19 08-Dec-11

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 'Numeric Primary Key As Identity' Oracle option is added: if this option is checked, the "StoreGeneratedPattern" will be set to Identity by default for Number primary keys
The 'Integer Primary Key As Identity' SQLite option is added: if this option is checked, the "StoreGeneratedPattern" will be set to Identity by default for Integer primary keys
The bug with code generation for default values of DateTime fields is fixed
The bug with 'losing' additional diagrams when re-opening a model is fixed

3.0.16 24-Nov-11

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

3.0.14 11-Nov-11

The bug with updating explicitly attached entities is fixed
The bug with inserting null values into Oracle XMLtype columns is fixed
The bug with returning invalid connections to pool is fixed

Entity Developer

The possibility of specifying the name of the connection string to be saved in the application configuration file is implemented
Behaviour is changed: table is not marked as "Changed" in Update Wizard if DefaultValue is set for its expression column
The bug with NRE being thrown when an invalid connection is used is fixed
The bug with the local settings used for the default value of DateTime fields is fixed
The bug with creating methods with the same names for different stored procedures is fixed (Oracle)
The default value of the Unicode facet is changed to true for PostgreSQL CITEXT columns

3.0.10 19-Oct-11

The bug with getting wrong query from the compiled query cache is fixed
The bug with redundant parameter prefixes for auto-sync parameters 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 default mapping of SQLite databases with LinqConnect models is improved: integer foreign keys of one-to-one relationships are no more marked as auto-generated
The default attribute mapping source for LinqConnect models is made static

3.0.5 29-Sep-11

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
The bug with update operations on Oracle XMLType fields is fixed
The bug with conversion of System.Char to integer is fixed (Oracle)

Entity Developer

Disabling facets that are not applicable to the current field type is implemented
Default behaviour changed: now the Update To Database Wizard does not drop foreign keys of a table if the 'master' one is not represented in the model
The 'Binary As Guid' connection string parameter is supported (MySQL)
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') is fixed
The bug with default mapping for PostgreSQL UUID columns is fixed
The bug with setting Extended Properties for RelationProperty is fixed

3.0.4 06-Sep-11

Fluent mapping is supported
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
The bug with long sequence of IN operator arguments is fixed (Oracle)
The bug with null comparison for DateTime properties is fixed (Oracle)
The bug with SQL generation for Skip/Take methods is fixed (SQL Server)
The bug with creating foreign keys in SQLite databases on DataContext.CreateDatabase is fixed

Entity Developer

Fluent Mapping template is added
Support for enumerated types ("enums") 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 setting foreign keys to tables located in non-default schema via the Create Database wizard is fixed (SQL Server)
The bug with changing property names ("Index was outside the bounds of the array") is fixed

2.50.30 11-Aug-11

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

2.50.29 28-Jul-11

The bug with columns named as Oracle keywords is fixed

Entity Developer

The bug with parameter names of SQL Server stored procedures is fixed

2.50.27 07-Jul-11

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 possibility to restrict adding the connection string information to the application configuration file is added
The bug with Primary Key naming in case of many-to-many associations in Model First is fixed
The bug with deleting associations on update from database is fixed (MySQL)
The bug with the 'condition' keyword in the script created by the Generate Database Wizard is fixed (MySQL)

2.50.25 15-Jun-11

The 'IsReference' mode of entity serialization is supported
The generation of auto-increment columns on the CreateDatabase call is implemented (MySQL and SQL Server)
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

2.50.24 01-Jun-11

Implemented fetch mode customization for eager loading of related entities
Improved performance of ordered queries with the Skip() and Take() methods: the 'rownum' pseudo-column is now used instead of the 'row_number' function (Oracle)
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
The bug with redundant subqueries in queries that use the Take method is fixed (Oracle)

Entity Developer

Behaviour is changed: string entity fields are now mapped to varchar2(4000) by default (Oracle)
The bug with configuring a sequence ID generator 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
The bug with recognizing associations between tables from different schemas is fixed (Oracle)
The bug with adding package functions to the model is fixed (Oracle)
The bug with column aliases in queries with several nested subqueries is fixed (Oracle)

2.50.23 17-May-11

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 launching Devart documentation via Start menu 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

POCO template with XML mapping generation is added
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
The "Preserve schema name in storage" option is added
The bug with generation of attach/detach methods for many-to-many associations is fixed
The bug with external mapping is fixed
The bug with default values set via a function for string fields is fixed
The bug with the "Access" combobox of the Association editor is fixed

2.20.21 19-Apr-11

Implemented workaround for comparing SQLite DateTime values as strings in LinqConnect update checks (such values are explicitly converted to the SQLite DateTime type now)
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
Fixed bug with GUID parameters in SQL server queries

2.20.19 06-Apr-11

Implemented the Attach(object entity, object original) method of the Devart.Data.Linq.ITable interface
Implemented proper support for both text and binary representations of System.Guid (SQLite)
Fixed bug with passing GUID parameters to compiled queries (Oracle)

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

2.20.17 23-Mar-11

Supported Visual Studio 2010 Service Pack 1
Fixed bug with inserting 'detail' entities together with 'master' ones for one-to-one associations
Fixed bug with 'double' parameters of PostgreSQL stored functions

Entity Developer

Added multiple database file support for SQLite (using Attach connection string parameter)
Changed behaviour: when adding two related entities with the corresponding properties having different types, an invalid association is created now
Changed default mapping for MySQL signed TinyInt columns: they are mapped to SByte now
Changed behaviour: when retrieving metadata, Oracle stored procedures and functions that don't return cursors are no longer executed
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

2.20.15 11-Mar-11

Implemented implicit sorting by the entity key in queries with defined LoadWith rules
Fixed bug with the "The message filter indicated that the application is busy" error during uninstall
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

2.20.14 24-Feb-11

Fixed bug with deserializing LinqConnect exceptions
Fixed bug with attaching entities as modified to DataContext
Fixed bug with creating auto-incremented columns with the DataContext.CreateDatabase method (MySQL)

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
Fixed bug with adding Oracle procedures declared inside packages to the model
Fixed bug with the Update From Database Wizard showing no changes when connecting under a MySQL user account with limited privileges

2.20.12 09-Feb-11

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 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()
Fixed bug with creating a new MySQL database with the DataContext.CreateDatabase method
Fixed bug with generating methods for Oracle stored procedures with PL/SQL Boolean parameters
Fixed bug with selecting top N rows from tables on SQL Server 2000

Entity Developer

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
Fixed bug with wrong Complex Type properties in Stored Procedures
Fixed bug with retrieving metadata in case that objects with the same name were available in different schemas (SQL Server)
Fixed bug with mapping NUMBER fields to System.Double (Oracle)
Fixed bug with the 'Show Print Markup' button and 'Page Setup' menu item being disabled

2.20.11 27-Jan-11

Fixed bug with repeated creation of DataContexts with external mapping
Fixed bug with many-to-many associations based on composite keys

Entity Developer

Added possibility to split model into several diagrams for better handling of large models
Supported automatic generation of sequences and triggers for Autoincrement properties in Oracle
Implemented possibility to disable automatic recognition of many-to-many associations
Fixed bug with handling errors when accessing server via an invalid connection
Fixed bug with opening the connection dialog of the Create Model Wizard with Turkish regional settings (PostgreSQL)
Fixed bug with loading metadata for SQL Server 2000
Fixed bug with SQL Server default value for Boolean columns (Model First)
Fixed bug with opening models that have invalid connection strings

2.0.10 12-Jan-11

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
Fixed bug with using the Convert.ToDateTime function with Greek culture info in LINQ queries (Oracle)
Fixed bug with inserting Int32 values (SQLite)
Fixed bug with columns marked as NUMERIC (SQLite)

Entity Developer

Fixed bug with many-to-many and Update From Database Wizard
Fixed bug with using functions which return void (PostgreSQL)

2.0.9 16-Dec-10

Supported Visual Studio 2010 Service Pack 1 Beta
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<TResult> 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 queries with the OrderBy(...).Any() statement (Oracle)
Fixed code generation bug with functions having output parameters (Oracle)
Fixed bug with LINQ queries with parameters in the Select clause (SQLite)
Fixed bug with inserting new rows into tables with auto-generated fields (MySQL)

Entity Developer

Fixed bug with the null-reference exception when adding LinqConnect model to web site folders other than App_Code

2.0.8 29-Nov-10

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 (MySQL, SQLite)
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 (MySQL)
Fixed bug with creating table constraints when using the DataContext.CreateDatabase() method (SQLite)
Fixed bug with executing compiled queries with boolean parameters (SQLite)

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 editor in Visual Studio
Fixed 'Model is not registered' bug
Fixed some bugs in Team Foundation Server support

1.0.43 04-Nov-10

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 (MySQL)
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 processing Char(1) fields (SQL Server)
Fixed bug with creating tables with LongBlob fields on CreateDatabase() (MySQL)

1.0.42 14-Oct-10

DataContext class is now CLS-Compilant
Changed behaviour: Substring() in LINQ queries is now translated to DBMS_LOB.SUBSTR for LOBs (Oracle)
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 bug with creating constraints on executing the DataContext.CreateDatabase method (Oracle)
Fixed bug with incorrect ROWNUM function usage in generated SQL (Oracle)
Fixed problem with recognizing MySql numeric type synonyms (MySQL)
Fixed bug in LinqConnect samples (License not valid: Code 11)

Entity Developer

Added default bindings to entity fields in Insert(Update/Delete) MethodMappings
Fixed bug with serializing entities loaded using DataLoadOptions

1.0.41 23-Sep-10

Added the client NLS settings support in the TO_NUMBER function (Oracle)
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 (MySQL)

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

1.0.39 28-Jul-10

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
Fixed bug with functions that return NVarchar values (Oracle)

1.0.38 07-Jul-10

Improved select performance
Improved insert performance
Added support for the DatabaseExists method (MySQL)
Fixed bug with Concat()
Fixed bug with the CacheStoreReader and Cast
Fixed bug with charset mismatch (Oracle)

1.0.36 28-May-10

First release of Devart LinqConnect