Softpedia >Windows >Internet >Servers >Database Utils >LinqConnect >  Changelog

LinqConnect Changelog

What's new in LinqConnect 5.1.10

Jan 19, 2024
  • .NET 8 compatibility
  • Visual Studio 2022 version 17.9 Preview is supported
  • The bug preventing validation of the Professional edition activation key, when applied through the License Key connection string parameter for Oracle, MySQL, PostgreSQL, and SQLite, is fixed
  • Entity Developer:
  • .NET 8 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in LinqConnect model
  • The new option "Show System Schemas" (by default, False) is added to Servers' Options -> SQL Server. If the "Show System Schemas" check box is selected, database objects from system schemas will be retrieved (SQL Server)
  • The new option "Retrieve Cross Schema Relations" (by default, True) is added to Servers' Options -> SQL Server. If the "Retrieve Cross Schema Relations" check box is selected, foreign keys from different schemas will be retrieved. This can take much time (SQL Server)
  • The hang of Visual Studio 2022 when saving the model is fixed

New in LinqConnect 5.0.177 (Nov 20, 2023)

  • Visual Studio 2022 version 17.8 Preview is supported.

New in LinqConnect 5.0.134 (Mar 3, 2023)

  • Visual Studio 2022 version 17.5 Preview is supported
  • .NET 7 compatibility

New in LinqConnect 5.0.0 (Jul 1, 2022)

  • .NET 6 compatibility.
  • Windows 11 is supported.
  • Visual Studio 2022 version 17.2 is supported.
  • Visual Studio 2022 version 17.3 Preview is supported.
  • Entity Developer:
  • 64-bit version of standalone Entity Developer application is added.
  • 64-bit version of console Entity Developer application is added.
  • The behavior is changed: Entity Developer default installation path has changed from C:Program Files (x86)DevartEntity Developer to C:Program FilesDevartEntity Developer.

New in LinqConnect 4.9.2403 (Jan 25, 2022)

  • Compatible with dotConnect providers

New in LinqConnect 4.9.2379 (Dec 21, 2021)

  • Compatible with dotConnect providers

New in LinqConnect 4.9.2351 (Nov 9, 2021)

  • Compatible with dotConnect providers

New in LinqConnect 4.9.2338 (Oct 21, 2021)

  • Visual Studio 2019 Preview support is discontinued
  • The bug with parsing TypeName values in XML mapping generated by Visual Basic template is fixed (MySQL, Oracle, PostgreSQL, SQLite)
  • The bug with applying .NET Standard licensing to .NET 6 projects is fixed
  • Entity Developer:
  • The bug with launching Entity Developer after applying Windows 10 Update KB5006670 and Windows 11 Update KB5006674 is fixed

New in LinqConnect 4.9.2322 (Sep 28, 2021)

  • The new property Validation Framework is implemented in the Data Transfer Object template for generating DataAnnotations attributes

New in LinqConnect 4.9.2281 (Jul 30, 2021)

  • The new methods IsNotDistinctFrom() and IsDistinctFrom() are added to the Devart.Data.Linq.SqlMethods class
  • The bug with using out parameters of a stored procedure, when Mapping Mode is set to File in Model Settings, is fixed (Oracle)

New in LinqConnect 4.9.2267 (Jul 8, 2021)

  • Visual Studio 2019 version 16.11 Preview 2.0 is supported
  • Entity Developer:
  • The bug with throwing "Index was outside the bounds of the array" by Create Model Wizard / Update From Database Wizard when retrieving metadata is fixed (SQL Server)

New in LinqConnect 4.9.2242 (Jun 3, 2021)

  • Schemas of type E (External Login from Azure Active Directory) are supported in Create Model Wizard / Update From Database / Update To Database (SQL Server)
  • Detection of GENERATED ALWAYS AS ROW START and GENERATED ALWAYS AS ROW END columns in SQL Server 2016 and higher by Create Model Wizard / Update From Database Wizard is implemented
  • The bug with an invalid attempt to add a reference to Devart.Data.dll by Create Model Wizard is fixed (SQL Server)
  • The bug with creating app.config in Visual Studio .NET Framework projects, when the "Rewrite connection string during regeneration" option is turned off in Model Settings, is fixed
  • The bug with ignoring template's Validation Error Messages values in the generated code, when class property's Validate Expression is initialized and Validate Format is set to a non-default value, is fixed

New in LinqConnect 4.9.2203 (Apr 9, 2021)

  • The bug with throwing "bufferAdapter is not a VsTextDocData" when saving a model in .NET Core, .NET Standard, .NET 5, .NET 6 projects of Visual Studio 2019 is fixed
  • The bug with adding tables to a model by Create Model Wizard, when the Database connection string parameter is not set, is fixed (MySQL)

New in LinqConnect 4.9.2197 (Apr 1, 2021)

  • Visual Studio 2019 version 16.10 Preview is supported
  • Entity Developer:
  • .NET 6.0 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings
  • 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 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 WCF Data Contract Attributes property of the Data Transfer Object template
  • the WCF DataMember Attribute on Navigation Properties property of the Data Transfer Object template
  • The bug with creating app.config in Visual Studio .NET Core projects is fixed

New in LinqConnect 4.9.2173 (Feb 18, 2021)

  • Compatible with dotConnect providers

New in LinqConnect 4.9.2149 (Jan 15, 2021)

  • 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
  • The bug with throwing "dbMonitor is not active" by the DataContext.DatabaseExists() functionality, when LinqMonitor is not used, is fixed
  • Entity Developer:
  • The new attribute DisplayName is implemented for model objects' extended properties which are available via template properties
  • The bug with setting additional keyboard mapping scheme via menu Options on Windows with German display language is fixed

New in LinqConnect 4.9.2129 (Dec 17, 2020)

  • Compatible with other dotConnect providers

New in LinqConnect 4.9.2119 (Dec 3, 2020)

  • Visual Studio 2019 version 16.9 Preview is supported
  • Entity Developer:
  • The bug with adding new arguments at the end of argument list instead of actual position in method signature by Update From Database Wizard is fixed
  • The bug with placing procedure with no parameters in the Procedures node instead of being enlisted in its package's node of Update From Database Wizard tree in the case of Oracle 18c and higher is fixed

New in LinqConnect 4.9.2096 (Oct 29, 2020)

  • PostgreSQL 13 is supported
  • The bug with Visual Studio 2019 integration, when both v16.7 RTM and v16.8 Preview are installed on the same computer, is fixed
  • The bug with using nullable numeric types within subqueries is fixed
  • Entity Developer:
  • Schemas of type A (Application role) are supported in Create Model Wizard / Update From Database / Update To Database (SQL Server)
  • The bug with reading templates from *.edps by console Entity Developer is fixed

New in LinqConnect 4.9.2076 (Oct 1, 2020)

  • Visual Studio 2019 version 16.8 Preview is supported
  • Entity Developer:
  • The bug with reading settings from *.edps by console Entity Developer is fixed

New in LinqConnect 4.9.2067 (Sep 17, 2020)

  • The bug with SQL generation of the explicit cast to FLOAT is fixed (SQL Server)
  • The bug with subtracting a TimeSpan value from the DATETIME column is fixed (SQL Server)
  • Entity Developer:
  • The error message in console Entity Developer is improved: now the text includes the list of all available templates if the specified name of template was incorrect
  • The bug with saving a new model, which has never been saved before, after some time of work in a standalone Entity Developer is fixed

New in LinqConnect 4.9.2033 (Jul 30, 2020)

  • The bug with the overload of IndexOf() method, that accepts CurrentCultureIgnoreCase as an argument, is fixed (SQL Server)

New in LinqConnect 4.9.2023 (Jul 16, 2020)

  • The overloads of Contains(), StartsWith(), EndsWith(), IndexOf(), Equals(), Compare() methods, that accept StringComparison as an argument, are supported (SQL Server)
  • The overload of Compare() method, that accepts StringComparison as an argument, is supported (PostgreSQL)
  • The "Could not find element type in model" bug when loading XML mapping in .NET Standard LinqConnect assemblies is fixed
  • The bug with using enums via .NET Standard compliant assemblies is fixed
  • Entity Developer:
  • The bug with detecting FK relationships to tables in other schemas by Create Model Wizard and Update From Database Wizard is fixed

New in LinqConnect 4.9.2003 (Jun 17, 2020)

  • Visual Studio 2019 version 16.7 Preview is supported
  • The overloads of Contains(), StartsWith(), EndsWith(), IndexOf(), Equals() methods, that accept StringComparison as an argument, are supported (PostgreSQL)
  • 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
  • The bug with mapping INT without explicitly specified display width is fixed (MySQL)
  • Entity Developer:
  • .NET 5 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in LinqConnect models
  • 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 list of keywords and reserved words of Oracle, MySQL, PostgreSQL being quoted by Entity Developer is updated
  • Retrieving SQL Server metadata of cross-schema foreign keys by Create Model Wizard and Update From Database Wizard is optimized (SQL Server)
  • The compatibility issue with JetBrains ReSharper is fixed
  • The behavior of Create Model Wizard and Update From Database Wizard is changed: timeout used for reading SQL Server metadata is greatly increased (SQL Server)
  • 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 bug with retrieving metadata of string columns' default values in MySQL 8 is fixed
  • The bug with droping and recreating indexes by Update From Database Wizard, when there are unique indexes with the same name in different tables, is fixed (SQL Server)
  • The bug with throwing "Index was outside the bounds of the array" by Create Model Wizard and Update From Database Wizard, when getting metadata from result set with datetime2 or/and time columns returned by Table Valued Function, is fixed (SQL Server)

New in LinqConnect 4.9.1949 (Apr 2, 2020)

  • The insert of the object, the type of which is an unmapped class inherited from a mapped class, is supported
  • The bug with throwing System.NullReferenceException, when constructing the error saying that unmapped class is not supported, is fixed
  • Entity Developer:
  • Model file tree in .NET Core / .NET Standard projects is improved: all generated code files and model files are nested under the same node in Solution Explorer

New in LinqConnect 4.9.1920 (Feb 20, 2020)

  • The bug with case insensitive comparison via string.Compare() is fixed (Oracle)
  • The bug with returning the generated value for the property with Auto-Sync=OnInsert, which corresponds to non-Identity column, is fixed (SQL Server)
  • Entity Developer:
  • Graph tables in SQL Server 2019 are supported (SQL Server)
  • The behavior is changed: columns with IsHidden=1 in SQL Server 2019 are ignored by Create Model Wizard (SQL Server)
  • The bug with loosing non-default precision of DATETIME2 and TIME data types by Update To Database / Generate Database Script wizards is fixed (SQL Server)
  • The bug with detecting MySQL computed columns is fixed (MySQL)

New in LinqConnect 4.9.1878 (Dec 23, 2019)

  • Visual Studio 2019 version 16.5 Preview is supported
  • The bug with using Toolbox component DbLinqDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
  • The bug with quoting SQL Server reserved keywords used as identifiers in Code-First mapping is fixed (SQL Server)
  • The bug with creating a Date parameter for the property mapped to DbType="DATE" and used in .WHERE() clause of LINQ query is fixed (SQL Server)
  • Entity Developer:
  • The 12cR2 option is added to the list of available Oracle versions in Model Synchronization Settings

New in LinqConnect 4.9.1856 (Nov 21, 2019)

  • Compatible with dotConnect providers

New in LinqConnect 4.9.1841 (Oct 31, 2019)

  • Visual Studio 2019 version 16.4 Preview is supported

New in LinqConnect 4.9.1836 (Oct 24, 2019)

  • The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported
  • The compatibility issue with JetBrains ReSharper is fixed

New in LinqConnect 4.9.1807 (Sep 13, 2019)

  • The integration with Visual Studio 2019 is improved: now the installation detects both 2019 Release and 2019 Preview versions
  • Entity Developer:
  • The behaviour is changed: a plural form of names ending with "s" now has a longer version (for example, status -> statuses)
  • The bug with detecting FK relation based on unique index without unique constraint is fixed

New in LinqConnect 4.9.1774 (Jul 25, 2019)

  • Compatible with dotConnect providers

New in LinqConnect 4.9.1739 (Jun 6, 2019)

  • Deprecated design-time Synchronous API calls are no longer used with Visual Studio 2019 and Visual Studio 2017
  • The bug with executing incorrect SQL request (cached during one of the previous calls), when a variable initialized with an empty collection participates in LINQ query, is fixed
  • The bug with throwing the exception "Cannot open database "newDB" requested by the login. The login failed." while performing the CreateDatabase(true, true) method is fixed (SQL Server)
  • The bug with throwing System.ArgumentNullException on DeleteOnSubmit(entity) called after Attach(entity) is fixed (SQL Server)
  • The bug with running stored procedure in PostgreSQL Server 11 or higher is fixed (PostgreSQL)

New in LinqConnect 4.9.1703 (Apr 12, 2019)

  • Visual Studio 2019 is supported.
  • The bug with the materialization of UInt32 values greater than Int32.MaxValue is fixed (SQL Server).

New in LinqConnect 4.8.1694 (Mar 28, 2019)

  • Visual Studio 2019 Release Candidate 4 is supported
  • The bug with using the System.Char argument as literal or variable in LINQ query is fixed (SQLite)

New in LinqConnect 4.8.1644 (Jan 10, 2019)

  • PostgreSQL 11 is supported
  • 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 (MySQL)
  • Entity Developer:
  • The bug with using ASP.NET Core Web Application (.NET Framework) and Azure Functions v1 (.NET Framework) projects in Visual Studio 2017 is fixed

New in LinqConnect 4.8.1615 (Nov 29, 2018)

  • 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

New in LinqConnect 4.8.1590 (Oct 25, 2018)

  • The bug with updating the existing entities that participate in FK associations is fixed in .NET Standard 2 compliant assemblies
  • TThe bug with filtering by the DateTimeOffset property is fixed (Oracle)
  • Entity Developer:
  • The bug with throwing "Custom tool error: bufferAdapter is not a VsTextDocData" in .NET Standard projects is fixed

New in LinqConnect 4.8.1566 (Sep 20, 2018)

  • The bug with applying LEFT JOIN LATERAL in the generated SQL is fixed (PostgreSQL)
  • Entity Developer:
  • Using an extended property of type OutputInfo is supported
  • li>Code generated for nullable properties is simplified: now T? is generated instead of System.Nullable<T>

New in LinqConnect 4.8.1553 (Aug 31, 2018)

  • Entity Developer:
  • The bug with creating and opening the model in .NET Core project after VS 2017 upgrade to v15.8 is fixed
  • The bug with setting password as clear text in connection string when "Persist Security Info=False;" is fixed (Oracle, MySQL, PostgreSQL, SQL Server)
  • The bug with applying a custom mapping for uniqueidentifier and decimal types specified via Servers Options is fixed (SQL Server)

New in LinqConnect 4.8.1527 (Jul 19, 2018)

  • The bug with throwing the "Socket.IOControl handles Windows-specific control codes and is not supported on this platform." error by .NET Standard compliant assemblies on Linux and MacOS is fixed (MySQL, PostgreSQL)

New in LinqConnect 4.8.1509 (Jun 22, 2018)

  • The bug with generating ParameterDirection.InputOutput for SQL Server OUTPUT parameters is fixed

New in LinqConnect 4.8.1489 (May 25, 2018)

  • A destructor for DataContext is added

New in LinqConnect 4.8.1471 (Apr 27, 2018)

  • Compatible with dotConnect providers

New in LinqConnect 4.8.1452 (Mar 30, 2018)

  • 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;"
  • The bug with mapping a function that returns REFCURSOR is fixed (PostgreSQL)
  • Entity Developer"
  • The new Retrieve Cross Database Relations option is implemented in Model Settings for detecting FK relations between tables in different databases (MySQL)
  • 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

New in LinqConnect 4.8.1423 (Feb 15, 2018)

  • The generation of CROSS JOIN LATERAL and LEFT JOIN LATERAL when connecting to PostgreSQL Server 9.3 or higher is supported (PostgreSQL)
  • The bug with throwing MethodAccessException by .NET Standard provider assemblies when referencing them to a project, targeting Full .NET Framework, is fixed
  • Entity Developer:
  • Identity columns in PostgreSQL 10 are supported

New in LinqConnect 4.8.1398 (Jan 11, 2018)

  • The bug with initializing DataContext with non-existing database name in its connection string is fixed (SQL Server)
  • The bug with ignoring the DateTime precision by CreateDatabase() is fixed (MySQL)
  • Entity Developer:
  • The ModelNameAsFilesPrefix property is implemented in the RepositoryAndUnitOfWork template
  • The behaviour is changed: a base class in TPT Inheritance is allowed to be abstract now

New in LinqConnect 4.8.1368 (Nov 24, 2017)

  • The performance of generating complex queries is improved
  • The bug with exceeding a length of duplicated column aliases in the generated SQL is fixed (MySQL, Oracle, PostgreSQL)
  • Entity Developer:
  • The usage of long identifiers (up to 140 symbols) for naming model objects is supported

New in LinqConnect 4.8.1350 (Oct 30, 2017)

  • .NET Standard 2.0 is supported
  • .NET Core 2.0 is supported
  • The macaddr8 data type introduced in PostgreSQL 10 is supported
  • The bug with .Union().Any() is fixed
  • Entity Developer:
  • The .NET Standard 2.0 projects in Visual Studio 2017 are supported
  • The .NET Core 2.0 projects in Visual Studio 2017 are supported
  • The macaddr8 data type introduced in PostgreSQL 10 is supported
  • The bug with escaping invalid XML characters in the comments generated by templates is fixed

New in LinqConnect 4.7.1317 (Sep 7, 2017)

  • The integration with Visual Studio 2017 is improved: the installation is now silent, without VSIX Installer prompt window
  • Entity Developer:
  • The Devart Visual Studio packages registration into Visual Studio 2017 is improved: the packages are now available for all Windows accounts
  • The bug with losing Toolbar and docking customizations of a standalone designer during reinstall is fixed

New in LinqConnect 4.7.1295 (Aug 4, 2017)

  • Compatible with dotConnect providers

New in LinqConnect 4.7.1283 (Jul 13, 2017)

  • The bug with SubmitChanges() when there are associations to classes belonging to a TPT hierarchy in a model is fixed (MySQL)
  • Entity Developer:
  • The bug with running 'install-package Devart.Data.SqlServer.Linq' on the last step of Create Model Wizard is fixed (SQL Server)

New in LinqConnect 4.7.1268 (Jun 26, 2017)

  • The bug with applying the License Key connection string parameter (concerns .NET Standard 1.3 compliant assemblies only) on Linux is fixed
  • The bug with using unsigned integer parameters is fixed (MySQL)
  • Entity Developer:
  • The bug with generating .NET Core code by LinqConnect template for the "Use the following connection string from App.config" option in Model Settings is fixed
  • The bug related to the conflict of Entity Developer with dbForge SQL Complete is fixed

New in LinqConnect 4.7.1249 (May 26, 2017)

  • .NET Core is supported
  • The NuGet packages with .NET Standard 1.3 (.NET Core) compliant assemblies are uploaded to www.nuget.org
  • The bug with running LINQ queries, which invoke .NET methods on client side during materialization of result set, is fixed
  • The bug with materializing scalar value collection when converting values on the client side is fixed
  • The bug with returning incorrect data by the 'BooleanProperty ?? false' LINQ query is fixed (MySQL)
  • Entity Developer:
  • Visual Studio 2017 is supported
  • The .NET Core projects in Visual Studio 2017 are supported
  • The Snake case in both Model and Database naming rules is supported via the new "Add underscore" option

New in LinqConnect 4.6.1199 (Mar 20, 2017)

  • Visual Studio 2017 is supported
  • The HSTORE data type is supported (PostgreSQL)
  • The CITEXT data type is supported (PostgreSQL)
  • The JSON data type is supported (MySQL)
  • The bug with loosing decimal precision by the CreateDatabase() functionality is fixed (MySQL)

New in LinqConnect 4.5.1156 (Jan 18, 2017)

  • Visual Studio 2017 Release Candidate is supported
  • The behavior is changed: DataContext.CreateDatabase() uses now the same datatype names like the ones used in model mapping (SQLite)
  • Entity Developer:
  • The bug with detecting auto generated columns by Create Model Wizard and Update Model From Database Wizard is fixed (PostgreSQL)

New in LinqConnect 4.5.1141 (Dec 27, 2016)

  • Compatible with dotConnect providers

New in LinqConnect 4.5.1131 (Dec 27, 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 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 (MySQL)
  • The bug with throwing System.InvalidCastException when inserting / updating the System.Object properties is fixed (MySQL, SQLite)
  • Entity Developer:
  • The possibility to choose whether to add new entities to a diagram or not in Update From Database Wizard is implemented

New in LinqConnect 4.5.1100 (Dec 27, 2016)

  • The bug with returning incorrect data by the 'BooleanProperty ?? false' LINQ query is fixed (MySQL)

New in LinqConnect 4.5.1090 (Dec 27, 2016)

  • The bug with reading columns of the base type in TPT inheritance via .OfType() of LINQ query
  • The bug with loading objects via association which targets to the base class of an inheritance with the materialized child class is fixed
  • The bug with throwing "Sequence contains more than one element" when reading objects of TPT hierarchy is fixed
  • Entity Developer:
  • The bug with retrieving metadata from PostgreSQL server with the intarray extension installed is fixed (PostgreSQL)

New in LinqConnect 4.5.1080 (Dec 27, 2016)

  • The bug with materialization in the multithreaded application is fixed

New in LinqConnect 4.5.1066 (Dec 27, 2016)

  • Compatible with dotConnect providers

New in LinqConnect 4.4.745 (May 8, 2015)

  • The JSONB data type is supported (PostgreSQL)
  • The bug related to not submitting new records, when EntityRef of the corresponding entity class is set to null, is fixed
  • The bug related to re-materialization of objects of the same type when performing methods that are mapped to different stored procedures is fixed
  • The bug with loading metadata and query performing when ITable is used instead of Table is fixed
  • The bug with the materialization of UInt32 values greater than Int32.MaxValue is fixed
  • The bug related to the "Operand data type bit is invalid for minus operator" error is fixed (SQL Server)

New in LinqConnect 4.4.735 (May 4, 2015)

  • The bug related to the odd ESCAPE character in a generated SQL query after LIKE condition is fixed
  • The bug related to re-materialization of objects of the same type when performing various SQL-queries via ExecuteQuery() method in multi-threading applications is fixed
  • The bug with rounding decimal return values when performing stored functions is fixed (SQL Server)
  • Entity Developer:
  • The support of ID generators for primary keys in the Fluent Mapping template is added

New in LinqConnect 4.4.717 (Mar 26, 2015)

  • The dependency on the System.Windows.Forms.dll assembly is removed
  • The bug related to the wrong SQL generation (setting value for primary key column in UPDATE statement) when using the Attach(TEntity, asModified) method is fixed
  • The bug related the CompiledQueryCache locking issue is fixed
  • The bug related to working with the columns of the BINARY_FLOAT/BINARY_DOUBLE data type is fixed (Oracle)
  • The bug related to long default names of identifiers (for example, indexes, primary keys, foreign keys) when using CreateDatabase() method is fixed (MySQL, PostgreSQL)

New in LinqConnect 4.4.690 (Feb 14, 2015)

  • The bug related to the "License not found" error (Oracle) in Metro style applications is fixed
  • The bug with referencing LinqConnect assemblies as Extension SDKs in Metro style applications (Windows 8.1) is fixed
  • The bug related to the "Cannot convert the value to GUID: System.Byte[]" error when working with eager loading and GUIDs is fixed

New in LinqConnect 4.4.682 (Feb 3, 2015)

  • Entity Developer:
  • The bug with "Trial period expired" is fixed

New in LinqConnect 4.4.671 (Jan 15, 2015)

  • Compatible with dotConnect providers

New in LinqConnect 4.4.651 (Dec 19, 2014)

  • Entity Developer:
  • The bug with opening nodes of views in Update Model Wizard is fixed (Oracle)

New in LinqConnect 4.4.641 (Dec 5, 2014)

  • The bug related to memory leak errors when working with the disabled compiled query cache is fixed

New in LinqConnect 4.4.631 (Nov 21, 2014)

  • Entity Developer:
  • The bug related to script generation by the "Generate Database Script" wizard with the "Include Drop" option is fixed
  • The bug related to resetting enum arguments of custom attributes in the standalone version is fixed
  • The bug with displaying the "Describe Stored Procedure" connection string parameter in the Connection Editor is fixed (Oracle)

New in LinqConnect 4.4.621 (Nov 8, 2014)

  • The bug related to the InvalidOperationException when working with IMultipleResults is fixed (Oracle)
  • Entity Developer:
  • The bug with reading all constructor parameters for attributes when opening model is fixed
  • The bug with reading Default Value of database fields with explicit cast is fixed (PostgreSQL)

New in LinqConnect 4.4.602 (Oct 9, 2014)

  • Entity Developer:
  • The default behaviour is changed: the INTEGER database type is mapped now to System.Int64 .NET type when using Database-First approach; the new mapping will be applied after pressing Reset in Server Options settings of Entity Developer (SQLite)

New in LinqConnect 4.4.592 (Sep 25, 2014)

  • Entity Developer:
  • The behaviour is changed: Generate Database Script From Model saves the output in ASCII format if there are no unicode symbols in the script; UTF-8 is used otherwise
  • The bug with model creation when using multiple naming rules (suffixes, prefixes) is fixed

New in LinqConnect 4.4.582 (Sep 11, 2014)

  • The bug related to the "The type initializer for 'Devart.Data.PostgreSql.PgSqlConnectionStringBuilder' threw an exception" error is fixed

New in LinqConnect 4.4.577 (Sep 5, 2014)

  • 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 bug related to the "An error occurred during an attempt to compile the template 'LinqConnect'." error in Windows Store applications is fixed

New in LinqConnect 4.4.563 (Aug 16, 2014)

  • The bug with generation AUTO_INCREMENT for columns with INT/BIGINT data types, which have the corresponding entity properties with System.Decimal type and IsDbGenerated=true, via the CreateDatabase() method is fixed (MySQL)
  • The bug with generation UNSIGNED for columns with unsigned integer data types via the CreateDatabase() method is fixed (MySQL)
  • Entity Developer:
  • The possibility to use relative paths to assemblies in code generation templates is implemented

New in LinqConnect 4.4.553 (Aug 1, 2014)

  • Entity Developer:
  • The bug with a format of generated DataAnnotations.RegularExpression for Numeric validate format is fixed
  • The bug related to incorrect detection of the default values with the cast operators is fixed (PostgreSQL)

New in LinqConnect 4.4.539 (Jul 10, 2014)

  • The bug with the missing "ASP.NET Dynamic Data LinqConnect Web Application" project template in Visual Studio 2013 is fixed

New in LinqConnect 4.4.529 (Jun 26, 2014)

  • The bug related to the memory leak issue when working with EntityCachingMode = StrongReference is fixed
  • The bug related to the NullReferenceException when performing queries and working with EntityCachingMode = StrongReference is fixed
  • The bug related to the "There is no tables to process" error when using the CreateDatabase() method with the DataContext object, that is based on the empty model, is fixed
  • The bug related to the error when creating XmlMappingSource via the FromReader() method is fixed
  • The bug related to the "Cannot use "DateTime" type value in the "TimeSpan" type argument" error when comparing time values is fixed (SQL Server)
  • The bug related to the NullReferenceException on DataContext creation, when the fluent mapping is used and ServerDataType is not specified for the entity properties, is fixed (SQL Server)

New in LinqConnect 4.4.519 (Jun 13, 2014)

  • The possibility to add LinqConnect assemblies as Extension SDKs for SQLite, Oracle, MySQL and PostgreSQL databases in Metro style and Windows Phone applications (Windows 8.1) is added
  • The bug with adding new LinqConnect model in Silverlight applications (Visual Basic) is fixed
  • The bug related to using properties of the enum data type (Byte, SByte), that are used in the complex entity key, is fixed
  • Entity Developer:
  • The bug with resetting value of the extended properties for associations after reopening the model is fixed

New in LinqConnect 4.4.509 (Jun 5, 2014)

  • The bug related to using properties of the enum data type, that are used in the complex entity key, is fixed
  • The bug related to the missing "Migrate to LinqConnect" item in the context menu of the LINQ to SQL models (*.dbml) in the Solution Explorer is fixed (SQL Server)

New in LinqConnect 4.4.499 (May 15, 2014)

  • The bug related to reading values of the string properties, that are database generated, when performing SubmitChanges() is fixed
  • Entity Developer:
  • The behaviour is changed: now by default VARCHAR(8000) / NVARCHAR(4000) columns, instead of VARCHAR(MAX) / NVARCHAR(MAX), correspond to the string properties in the model (SQL Server)
  • The bug related to the storage and mapping regeneration via the "Update Database from Model" wizard, or via the "Regenerate Storage and Mapping" option of the diagram shortcut menu, when changing one DBMS to another, is fixed
  • The bug related to performing queries via Query Editor/Retrieve Data when working with the 'Enterprise Library' validation framework is fixed

New in LinqConnect 4.4.484 (Apr 25, 2014)

  • The rowversion data type is supported (SQL Server)
  • The support for the comparison operators (==,! =,>,> =,

New in LinqConnect 4.4.473 (Apr 15, 2014)

  • Entity Developer:
  • SQL Server 2014 is supported
  • The bug related to the script generation by the "Generate Database Script"/"Update Database From Model" wizards for properties with 'Default Value = getdate()' is fixed (SQL Server)

New in LinqConnect 4.4.463 (Apr 15, 2014)

  • The JSON data type is supported (PostgreSQL)
  • The bug related to the incorrect detection of class type when working with the TPH inheritances and discriminators of the String/Decimal type is fixed
  • Entity Developer:
  • The bug with setting nullable type for EnumType property by the Data Transfer Object template is fixed

New in LinqConnect 4.4.453 (Mar 7, 2014)

  • The CommandTimeout property is added to the DataProvider class
  • The behaviour is changed: now explicit deletion of the foreign keys by their names is not performed via the DeleteDatabase() method (SQL Server, MySQL)
  • The bug related to the invalid generation of the foreign keys DDL for many-to-many associations when using CreateDatabase method is fixed
  • The bug with the query cache when performing several queries, having nullable parameters, sequentially is fixed
  • The bug related to the "Cannot use "timestamp(6)" type value in "DateTimeOffset" type argument" error is fixed (PostgreSQL)
  • Entity Developer:
  • The behaviour is changed: now paths to assemblies with attributes (Model Settings -> Model -> Attributes) are saved and used as relative paths
  • The bug with invalid code generation when different namespaces for context and entity classes are used in the VB.NET projects is fixed
  • The bug related to the "Timeout expired error" when working with replication stored procedures is fixed (SQL Server)
  • The bug related to the "Data is Null. This method or property cannot be called on Null values" when retrieving metadata is fixed (SQL Server)

New in LinqConnect 4.4.441 (Feb 18, 2014)

  • Entity Developer:
  • The behaviour is changed: now replication stored procedures are not shown on the "Select database objects" step of the Create/Update Model From Database wizard (SQL Server)

New in LinqConnect 4.4.438 (Feb 14, 2014)

  • The behaviour is changed: now the script is generated with "ON DELETE NO ACTION" when using the CreateDatabase() method and the "Delete Rule" for the association is set to "NO ACTION"
  • The behaviour is changed: now the CreateDatabase() method uses the same algorithm for naming foreign keys as in Entity Developer
  • The behaviour is changed: now the cascade deletion of tables in DeleteDatabase() method is performed via the "DROP TABLE CASCADE" statement (PostgreSQL)
  • The bug with the compiled query cache when working with the DbLinqDataSource component when navigating through the pages of the DataGrid control is fixed
  • The bug with the wrong SQL query generation for Contains(), StartsWith(), EndsWith() methods when the string pattern includes '[' or '^' symbols is fixed (MySQL, Oracle, PostgreSQL, SQLite)
  • The bug with the wrong SQL query generation for LINQ queries with OrderBy and First()/Single()/Take() methods when working with Oracle 9/10/11 is fixed (Oracle)
  • Entity Developer:
  • The bug related to the "Version string portion was too short or too long" error is fixed
  • The bug with dropping the UpdateCheck property value from Always to Never when re-opening the model is fixed
  • The bug related to the wrong script generation for "sp_addextendedproperty" is fixed: now the SQL is generated with the "schema" instead of "user" (SQL Server)

New in LinqConnect 4.4.428 (Jan 30, 2014)

  • The bug with handling complex types of the entity properties in the ServerDataTypeConvention class when working with fluent mapping is fixed
  • The bug related to the "Object reference not set to an instance of an object" exception on CreateDatabase() method when working with associations and fluent mapping is fixed
  • The bug with performing updates and deletes, when concurrency check is used for not-primary key columns, and the commands are combined to run in batches, is fixed
  • The bug related to re-materialization of objects of the same type when performing various SQL-queries via ExecuteQuery() method is fixed
  • The bug related to the "SQLite error\r\nnear \".\": syntax error" when foreign keys are created via CreateDatabase() method and if schema name is preserved in the storage part of the model is fixed (SQLite)
  • Entity Developer:
  • The bug with generating NEWID() by "Generate Database Script"/"Update Database From Model wizards" for non-nullable Guid Identity property when 'Server Version=Azure' is fixed (SQL Server)
  • The bug with retrieving metadata when connecting to PostgreSQL server 8.0 is fixed (PostgreSQL)
  • The bug with creating association basing on composite foreign key, when the column order in the corresponding primary key is different, is fixed (PostgreSQL)

New in LinqConnect 4.4.418 (Jan 16, 2014)

  • Entity Developer:
  • The bug with not including the namespace name in the XML mapping, when namespaces for entity classes and context class are different, is fixed
  • The bug related to the incorrect change detection when updating database from model (the precision and comments) is fixed (MySQL)

New in LinqConnect 4.4.403 (Dec 27, 2013)

  • The bug with wrong order for creation tables with the many-to-many associations via the CreateDatabase() method is fixed
  • The bug with the entity cache (EntityCacheMode.WeakReference) is fixed
  • The bug related to working with the stored functions, that return results as "SETOF primitive_type", is fixed (PostgreSQL)
  • Entity Developer:
  • The predefined templates (POCO Entity and LinqConnect) are improved: new template setting, "Generate Dummy Comments", is added
  • The bug related to detecting unique keys is fixed
  • The bug with wrong script generation for System.Boolean when the default value is set, is fixed (Oracle)

New in LinqConnect 4.4.393 (Dec 13, 2013)

  • The bug with foreign keys not created for many-to-many associations via the CreateDatabase() method is fixed
  • The bug related to the "The type initializer for 'DefaultXmlMappingProvider'" exception when working with the xml mapping and result sets is fixed
  • The bug with the comparison of the entity key property with a nullable variable, which is equal to null, is fixed
  • The bug with the data type conversions during materialization is fixed (SQL Server)
  • The bug with the comparison of constant with the column value, when the constant is on the left of the comparison operator, is fixed (SQL Server)
  • The bug related to the "Incorrect syntax near '

New in LinqConnect 4.4.383 (Nov 30, 2013)

  • The possibility to inherit from the data provider classes is added (Oracle, MySQL, PostgreSQL, SQLite, SQL Server)
  • Entity Developer:
  • The behaviour is changed: the values of "Target Server" and "Server Version" can be reset via the Model Settings > Synchronization > Mapping dialog despite the fact whether connection is specified in Database Explorer or not

New in LinqConnect 4.4.374 (Nov 30, 2013)

  • The bug related to the "System.ArgumentException: Property 'System.Collections.Generic.List`1..' is not defined for type 'System.Object'" error in Metro style applications is fixed
  • The bug related to the incorrect generation of the datatype names ( TINYTEXT/MEDIUMTEXT/LONGTEXT, TINYBLOB/MEDIUMBLOB/LONGBLOB) when using the CreateDatabase() method is fixed (MySQL)
  • The bug with comparison (AND/OR) of dates with another comparison results or boolean expressions is fixed (SQLite)

New in LinqConnect 4.4.364 (Nov 30, 2013)

  • Visual Studio 2013 is supported
  • The behaviour is changed: installation with the /VERYSILENT install parameter will uninstall the other version of the product without any dialog box if it is installed
  • The bug with SILENT/VERYSILENT uninstall with the NOFEEDBACK option is fixed
  • The bug with the date comparison is fixed (SQLite)
  • The bug related to the "Cannot open database..." error when calling CreateDatabase(false,true) after the DatabaseExists() method is fixed (SQL Server)
  • Entity Developer:
  • The bug with IntelliSense when working with T4 Editor in Visual Studio 2012 is fixed

New in LinqConnect 4.3.355 (Oct 17, 2013)

  • Oracle 12c is supported
  • VARCHAR2/NVARCHAR2/RAW types with length increased to 32KB are supported for Oracle 12c
  • Oracle 12c specific SQL generation for paging is supported
  • The Collate method of the SqlMethods class is implemented
  • The behaviour is changed: CreateDatabase functionality generates columns with the identity clause 'GENERATED AS IDENTITY' for primary key properties with 'IsDbGenerated=True' (only for Oracle 12c)
  • The bug with ignoring 'IsDbGenerated = True' when using Attach(TEntity entity, bool asModified) method is fixed
  • The bug with the compiled query cache when query contains parameters with the same values is fixed
  • The bug related to working with LinqConnect for Metro in WinJS applications is fixed
  • Entity Developer:
  • The predefined templates are improved: new template setting, "Use Compiled Query Cache", is added
  • The behaviour is changed: "Generate Database Script"/"Update Database From Model" wizards generate columns with the identity clause 'GENERATED AS IDENTITY' for properties with 'Auto Generated Value=True' (only for Oracle 12c)

New in LinqConnect 4.2.338 (Sep 23, 2013)

  • Visual Studio 2013 Release Candidate is supported
  • The implementation for the DatabaseExists method, which checks the existance of the tables in the database, is added (Oracle)
  • The possibility of creating Oracle schemas (users) for mapped model classes via the CreateDatabase(false,true)/CreateDatabase(true, true) method of the DataContext class is implemented (Oracle)
  • The possibility of deleting Oracle schemas (users) for mapped model classes via the DeleteDatabase(false,true)/DeleteDatabase(true, true) method of the DataContext class is implemented (Oracle)
  • The encryption support for local SQLite storage in LinqConnect for Metro is added (SQLite)
  • The bug with the discrepancy of the parameter's type and the column's type in operations of equality (==) and inequality (!=) for varchar/nvarchar data types is fixed (SQL Server)
  • Entity Developer:
  • The bug with releasing memory after closing the Retrieve Data window is fixed
  • The bug with the Overwrite.Merge template option is fixed
  • The bug related to the "Value cannot be null" error when selecting "Regenerate storage and mapping" from the shortcut menu in Model Explorer in Visual Studio is fixed
  • The bug with detecting default NULL values by the Update Model From Database wizard is fixed (SQLite)
  • The bug with creating complex primary keys when creating a model from a database is fixed (SQLite)

New in LinqConnect 4.2.327 (Sep 5, 2013)

  • 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 support for the operators of equality(==) and inequality(!=) for the "inet" data type in LINQ queries is added (PostgreSQL)
  • 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
  • The bug with performing the DatabaseExists() method when Persist Security Info is set to False is fixed (SQL Server)
  • The bug with the wrong DDL generation in the CreateDatabase() method with the DateTimeOffset properties is fixed (Oracle)
  • 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 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 LinqConnect 4.2.306 (Aug 8, 2013)

  • 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
  • The behaviour is changed: a table storage engine is not set explicitly in the generated DDL (MySQL)
  • 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 behaviour is changed: the PostgreSQL limitation in 63 character for identifier names is taken into account when the SQL script is generated by Update Database From Model / Generate Database Script wizards
  • The bug with breaking the parameters order in Generator Parameters Editor is fixed
  • The bug with an error during a compilation of the 'LinqConnect' template for VB.NET projects in Visual Studio 2008 is fixed
  • The bug with breaking the IdGenerator configuration after closing the model is fixed

New in LinqConnect 4.2.292 (Jul 20, 2013)

  • 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:
  • 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 wrong script generation for several tables with autoincrement fields in the "Generate Database Script From Model" and "Update Database From Model" wizards is fixed (Oracle)
  • The bug with the "Recreate Database Tables" option for tables which use sequences is fixed (Oracle)

New in LinqConnect 4.2.281 (Jul 3, 2013)

  • The bug related to working with decimal datatypes is fixed (SQLite)
  • Entity Developer:
  • The "Regenerate Storage and Mapping" option for regenerating model parts, specific to the database server, is added to the diagram shortcut menu
  • The bug with reading facets of a stored procedure parameter is fixed (Oracle)

New in LinqConnect 4.2.272 (Jun 20, 2013)

  • 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 bug with wrong code generation for nullable enum properties is fixed
  • The bug with generating "Access Denied" error when using MVC templates is fixed

New in LinqConnect 4.2.262 (Jun 6, 2013)

  • The bug with the nullable properties in composite foreign keys is fixed
  • The bug related to the MissingMethodException error is fixed (SQLite)
  • Entity Developer:
  • Support for SQL Server Compact Edition 3.5 and 4.0 is added
  • Devart.Data.Linq.Binary and System.Data.Linq.Binary types are added to the "Type Mapping Rule Editor"
  • The bug with referencing a custom assembly in T4 template is fixed

New in LinqConnect 4.2.257 (May 30, 2013)

  • The possibility to add LinqConnect assemblies as Extension SDKs for Oracle, MySQL and PostgreSQL databases in Metro style applications is added
  • The bug with referencing LinqConnect assemblies in Windows Phone 8 applications is fixed. Now LinqConnect assemblies for Windows Phone 8 are added as Extension SDKs
  • The bug with inserting dependent entity when the main entity has a key generator for the primary key property and DbGenerated is set to False is fixed
  • The bug with duplicate columns in an ORDER BY statement when using eager loading for several tables is fixed
  • The bug related to working with unmapped class members is fixed
  • Entity Developer:
  • The "WCF DataMember Attribute on Navigation Properties" property is added to the DbContext and POCO templates for pointing the end (-s) where the attribute should be generated
  • The bug with adding many-to-many associations when one of the sides of the association is involved in the inheritance is fixed
  • The bug with placing tables names in the root of the "Choose change action" page of Update From Database Wizard is fixed
  • The bug with generating NRE when setting the output of the template to the unloaded project is fixed

New in LinqConnect 4.2.247 (May 16, 2013)

  • The possibility to disable query cache via the DataContext's 'EntityCachingMode' property is added
  • Creation of auto-incrementing sequences and triggers for Oracle models is supported (Oracle)
  • Support for SERIAL and BIGSERIAL database types when using CreatedDatabase() method is added (PostgreSQL)
  • The bug related to the "Unable to open database file" with different variants of JournalMode in Metro style applications is fixed
  • 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
  • The bug related to the "ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion" error, when comparing CLOB/NCLOB columns or parameters, is fixed (Oracle)
  • 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
  • The behaviour is changed: a string default value for the property can be set without quotes in the Properties window
  • The bug with wrong detecting many-to-many associations is fixed
  • 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 (MySQL)

New in LinqConnect 4.2.231 (Apr 24, 2013)

  • Compatible with dotConnect providers

New in LinqConnect 4.2.229 (Apr 18, 2013)

  • The bug related to working with the database files which are located in the directory, where Metro style application is installed, is fixed
  • The bug with query cache issues when working with one DataContext instance and different data providers is fixed
  • The bug with method Any() when working with one DataContext instance and different data providers is fixed
  • The bug related to the issue with the OnListChanged() event when EntitySet collection is changed is fixed
  • Entity Developer:
  • The bug with wrong database script generation for tables with several many-to-many associations is fixed
  • The bug with loading mapping rules for some datatypes under .NET Framework 4.5 is fixed

New in LinqConnect 4.2.222 (Apr 5, 2013)

  • LINQPad integration is supported:
  • The behaviour is changed: now, when trying to synchronize composite primary key after insert, the "Auto-sync of multiple key parameters is not supported for SQL Server" and SqlNullValueException exceptions are not thrown (SQL Server)
  • The behaviour is changed: new database is created when using CreateDatabase method with createSchema = true (SQL Server)
  • The behaviour is changed: now batch updates are disabled by default (SQLite)
  • The bug related to the NullReferenceException on SubmitChanges() method when working with isVersion properties is fixed
  • The bug with using blank fixed-length strings is fixed (Oracle)
  • Entity Developer:
  • A new MVC Controller template, generating a ASP.NET MVC controller with data access code, is added
  • A new MVC View Advanced template, generating an ASP.NET MVC view based in Twitter Bootstrap, is added
  • A new Data Transfer Object template for DTO classes generation is implemented
  • A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart LinqConnect model is added
  • A new Data Annotation Metadata template, generating Data Annotation metadata classes and decorating classes and properties with data annotation attributes for validation, presentation and defining metadata, is added
  • Add Template dialog box is improved
  • The Namespace property of class, complex type, enum is implemented
  • The capability for setting special rules for generating default names of database objects when using the Model First approach is implemented (a new Advanced page is added to the Synchronization->Database Naming section of the Model Settings dialog box)
  • The capability to customize properties that are automatically added when creating a new entity, and options that are automatically set when creating a new property is added (a new Initialization page is added to the Model->General section of the Model Settings dialog box)
  • The Refresh option in the Attributes tab of the Model Settings window is implemented; it updates the list of available attributes types in the referenced assemblies
  • The capability to modify custom attributes for several selected entities or properties at the same time is implemented
  • The capability to cancel metadata reading in wizards and Database Explorer is added
  • The "Recreate Database Tables" check box, which allows to drop and recreate database tables, is added to the "Update To Database" wizard
  • New setting "Detect Table Per Type inheritances", which enables automatic detection of TPT inheritances, is added for Create Model Wizard and model
  • The "Include Drop" check box for including DROP commands for database objects to the generated script is added to Generate Database Script Wizard
  • A new shortcut menu command "Include Related", which allows making a copy of the related objects in the specified diagram, is added
  • A new shortcut menu command "Add To Model with Related", which allows adding tables, related to the selected one, to the model, is added to the shortcut menu of tables in Database Explorer
  • A new shortcut menu command "Add On Diagram With Related", which allows creating an object and all the objects related to it on a diagram, is added to the shortcut menu of classes, complex types, and enums in Model Explorer
  • The support for enums declared in external assemblies is implemented
  • New "Simple" diagram skin is added for displaying a diagram in metro style
  • The "Default Width" diagram property for specifying the default width for newly created diagram shapes (entities, complex types and enums) is added
  • Class Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
  • Type Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
  • The "Rewrite connection string during regeneration" check box of Model Settings is implemented to determine whether to overwrite the connection string in the project config file with the one, currently set in Entity Developer for the model, each time when regenerating code for the model
  • The user interface of Express Edition concerning availability of custom templates is improved
  • The behaviour is changed: "Save connection string in App.Config as" check box in Model Settings dialog box is renamed to "Use connection string from App.Config as"
  • The behaviour is changed: now, when creating a new TPH discriminator column in Inheritance Editor, it has the string type by default
  • The behaviour is changed: the error is generated if the Abstract inheritance modifier is set for the class which is involved in the Table Per Type inheritance
  • The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of class property without assigned value
  • The bug with the database script generation for the 'Delete Rule' association property is fixed

New in LinqConnect 4.1.207 (Mar 14, 2013)

  • Support for SQL Server Compact Edition 3.5 and 4.0 is implemented
  • The bug with DataLoadOptions.AssociateWith() when working with several DataContext objects is fixed
  • The bug related to the "Specified cast is not valid" exception when working with auto-increment primary keys mapped to decimal entity property is fixed
  • Entity Developer:
  • The bug with obtaining DebuggerService when working with T4 Editor is fixed

New in LinqConnect 4.1.197 (Feb 28, 2013)

  • The bug with working with stored procedures named like "[XXX.XXX]" is fixed (SQL Server)
  • Entity Developer:
  • The possibility of setting enum values via predefined dropdown list in the Retrieve Data window is implemented
  • The behaviour is changed: the Guid property is mapped to the UUID type in the database when using the Model First approach (PostgreSQL)
  • The bug related to the "Index was outside the bounds of the array" error when creating models for SQL Server 2000 is fixed
  • The bug related to the stored procedures with miltiple resultsets is fixed (MySQL, Oracle, PostgreSQL, SQL Server)

New in LinqConnect 4.1.184 (Feb 7, 2013)

  • The bug related to creation of a new instance of DataContext when using fluent mapping with the 'Database Independent = true' property is fixed
  • The bug related to the "Cannot add query to cache. An item with the same key already exists" exception in multi-threading applications is fixed
  • The bug related to "Unable to open database file" exception when opening several connections in the LinqConnect for Metro edition is fixed (SQLite)
  • The bug related to rounding the result of stored procedures with decimal output parameters is fixed (SQL Server)
  • Entity Developer:
  • The behaviour is changed: the serializing property and corresponding methods are not generated when using 'Fluent Mapping'/'POCO Entity' templates and Unidirectional mode
  • The bug with setting SERIAL/BIGSERIAL data types for auto generated properties, which are not primary keys, when performing "Generate Database Script from Model" and "Update Database From Model" wizards is fixed (PostgreSQL)
  • The bug related to wrong script generating in "Update Database From Model" wizard when setting a property as 'Nullable=false' and setting the default value is fixed (Oracle)

New in LinqConnect 4.1.169 (Jan 18, 2013)

  • The bug related to the "Cannot convert from 'string' to 'Devart.Data.Linq.Mapping.DeleteRule' " error when working with Fluent mapping is fixed
  • The bug with using DateTimeOffset in 'Where' statements is fixed (SQL Server)

New in LinqConnect 4.1.151 (Dec 20, 2012)

  • 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 "Strong name validation failed" exception in LinqConnect for Metro edition 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
  • The bug with creating DataContext with an already opened connection is fixed (SQL Server)
  • Entity Developer:
  • Model Refactoring feature is implemented; it speeds up creating complex types and Table Per Type inheritance from several model entities
  • The functionality of ignoring columns in the database in the "Update To/From Database" wizards if they were omitted once before is implemented
  • Warnings about objects that are not mapped are added
  • 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
  • The behaviour is changed: now the 'Read Only' property is not set to true for autoincrement fields by default when creating/updating models (MySQL, SQL Server)
  • The bug with generating a code for the initialization of the boolean property is fixed (MySQL)

New in LinqConnect 4.1.137 (Nov 29, 2012)

  • The fluent mapping is improved: support of the ID generators for primary keys is added
  • The bug with the integration into Visual Studio 2012 of LinqConnect for Silverlight edition is fixed
  • The bug with the INotifyPropertyChanging and INotifyPropertyChanged interfaces when working with LinqConnect/POCO Entity templates in Silverlight 5 applications is fixed
  • The bug with working with the database files, that are outside of isolated storage, with elevated trust for Silverlight 5 applications is fixed
  • The bug with the "Specified cast is not valid" exception when searching for an entity by its key is fixed
  • The bug with the failed updates to the database when using the Attach(TEntity,Boolean) method is fixed
  • Entity Developer:
  • The bug with renaming the navigation property when using the Update Model From Database wizard is fixed

New in LinqConnect 4.1.127 (Nov 15, 2012)

  • The bugs with using LinqConnect for Dynamic Data projects under .NET Framework 4.0 or higher are fixed
  • The bug with using blank fixed-length strings is fixed (Oracle)

New in LinqConnect 4.1.119 (Nov 2, 2012)

  • The bug with availability of the Yes/No/Cancel options when saving models created with previous versions of Entity Developer is fixed

New in LinqConnect 4.1.109 (Oct 18, 2012)

  • The bug with working with entities without INotifyPropertyChanging, INotifyPropertyChanged interfaces is fixed

New in LinqConnect 4.1.101 (Oct 4, 2012)

  • The bug related to the "An item with the same key has already been added" exception when working with DevExpress GridView is fixed
  • The bug with synchronization of the parent and child entities is fixed
  • The bug with update checks of CLOB columns is fixed (Oracle)
  • Entity Developer:
  • Predefined template for generating Repositories and Unit of Work classes is added
  • Integration with Visual Studio refactoring for renaming model objects is implemented
  • The "Use Database Comments" option of Model Settings is implemented to determine whether comments for database objects, if supported by DBMS, will be used for model objects Documentation initialization and taken into account when executing model or database update operations
  • The "Implement IClonable" option for the generated classes based on the model entities is added to all templates
  • The behaviour is changed: the "Save connection string in App.Config as" option is available in the standalone Entity Developer (the entry in App.Config must be added manually afterwards)

New in LinqConnect 4.1.82 (Sep 6, 2012)

  • Visual Studio 2012 is supported
  • The bug with getting entities from the cache by keys of type Int16 is fixed
  • The bug with getting entities directly from the cache for the command First (predicate) etc, is fixed
  • The bug with wrong parameters when loading dependent entities with two-level LoadOptions are set is fixed
  • The bug with invalid type of parameters used for update commands is fixed (SQLite)
  • Entity Developer:
  • The 'Entity Base' class property, which allows specifying the ancestor class/interface for a particular entity type, is implemented
  • The behaviour is changed: only particular (not all) property characteristics are regenerated when using Update Model From Database wizard after the metadata of the corresponding column have been changed
  • The behaviour is changed: when preserving schema name is disabled, schema name is no more saved for Oracle package functions/procedures

New in LinqConnect 4.0.63 (Aug 9, 2012)

  • The bug with creating DataContext with complex types having no default mapping is fixed
  • The bug with modifying the list of tracked entities when it is being enumerated is fixed
  • The bug with clearing the collection of depending entities is fixed
  • The bug with datetime literals as default COALESCE arguments is fixed (MySQL, Oracle, PostgreSQL)
  • The bug with comparing nvarchar datatype strings is fixed (Oracle)
  • The bug related to the Oracle constants with empty strings is fixed (Oracle)
  • The bug with materializing result sets of Oracle procedures with single output cursor is fixed (Oracle)
  • Entity Developer:
  • The possibility to unload assemblies from the main application domain by using separate application domain is implemented
  • The possibility to disable such Database First Settings as type mapping rules is implemented
  • The design time copy/cut/paste functionality for enum members is added
  • The bug with generating the "This model has been modified outside of the editor. Do you want to reload it?" error when Entity Developer is integrated into TFS is fixed
  • The bug with integration into TFS is fixed

New in LinqConnect 4.0.45 (Jul 18, 2012)

  • The bug with enumerating queries that have empty result sets is fixed
  • The bug with materializing query results into invalid object properties is fixed
  • The query cache bug with distinguishing compiled queries that have nullable parameters is fixed
  • The bug with deleting many-to-many links of entity having multiple many-to-many associations is fixed
  • The bug in LinqConnect samples is fixed
  • Entity Developer:
  • The behaviour is changed: the warning, related to the missing property setter, is disabled
  • The behaviour is changed: for the association, in which the many-side entity hasn't the primary key, the code and the mapping are not generated
  • The behaviour is changed: the properties, that correspond autoincrement fields, are generated with a ReadOnly keyword in VB.NET

New in LinqConnect 4.0.29 (Jun 21, 2012)

  • The bug with deleting the entity and its many-to-many bunches outside the batch is fixed
  • Entity Developer:
  • The "Pluralize collection navigation properties" option for the possibility to turn off the pluralization of the many-end names of associations is implemented
  • The "sealed override" inheritance modifier for methods based on stored procedures and functions is added
  • The bug with copy/pasting entities having a common relation is fixed
  • The bug with the displaying many-to-many associations in the Association Editor is fixed
  • The bug with specifying the custom tool for LinqConnect models being added to web sites is fixed
  • The bug with mapping generation for associations with the 'Delete On Null' rule enabled is fixed
  • The bug with mapping generation for entity types having multiple complex types is fixed

New in LinqConnect 4.0.21 (Jun 9, 2012)

  • Visual Studio 2012 Release Candidate is supported
  • 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 getting System.DateTimeOffset values via stored procedures is fixed (Microsoft SQL Server)
  • The bug with 'IS NULL' checks for non-nullable columns is fixed (MySQL, oracle)

New in LinqConnect 4.0.10 (May 23, 2012)

  • Support for Silverlight 4 and higher and Windows Phone 7 is added
  • 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 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 bug with incorrect saving of method's extended properties is fixed

New in LinqConnect 3.2.82 (May 10, 2012)

  • Entity Developer:
  • The multiline popup editor for the Documentation.Summary property is implemented

New in LinqConnect 3.2.73 (May 10, 2012)

  • 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

New in LinqConnect 3.2.64 (Apr 6, 2012)

  • 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

New in LinqConnect 3.2.57 (Mar 20, 2012)

  • 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

New in LinqConnect 3.1.34 (Feb 11, 2012)

  • Entity Developer:
  • The "Identifier Case Sensitive" check box, which enables case-sensitive processing of database object identifier names, is added to MySQL Server Options
  • The 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

New in LinqConnect 3.1.25 (Jan 28, 2012)

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

New in LinqConnect 3.1.23 (Jan 24, 2012)

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

New in LinqConnect 3.1.21 (Jan 24, 2012)

  • 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

New in LinqConnect 3.1.19 (Jan 24, 2012)

  • 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

New in LinqConnect 3.0.16 (Jan 24, 2012)

  • 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

New in LinqConnect 3.0.14 (Jan 24, 2012)

  • 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

New in LinqConnect 3.0.10 (Oct 24, 2011)

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

New in LinqConnect 3.0.5 (Oct 12, 2011)

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

New in LinqConnect 3.0.4 (Oct 12, 2011)

  • 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

New in LinqConnect 2.50.30 (Oct 12, 2011)

  • 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

New in LinqConnect 2.50.29 (Oct 12, 2011)

  • The bug with columns named as Oracle keywords is fixed

New in LinqConnect 2.50.27 (Oct 12, 2011)

  • The bug with the 'Cannot remove an entity that has not been attached' error when using compiled queries is fixed

New in LinqConnect 2.50.25 (Oct 12, 2011)

  • 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

New in LinqConnect 2.50.24 (Oct 12, 2011)

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

New in LinqConnect 2.50.23 (May 27, 2011)

  • 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

New in LinqConnect 2.20.12 (Feb 21, 2011)

  • 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

New in LinqConnect 2.20.11 (Feb 21, 2011)

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

New in LinqConnect 2.0.10 (Feb 21, 2011)

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

New in LinqConnect 2.0.9 (Feb 21, 2011)

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

New in LinqConnect 2.0.8 (Dec 10, 2010)

  • 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 TFS support

New in LinqConnect 1.0.43 (Dec 10, 2010)

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

New in LinqConnect 1.0.42 (Dec 10, 2010)

  • 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

New in LinqConnect 1.0.41 (Dec 10, 2010)

  • Added:
  • Client NLS settings support in the TO_NUMBER function (Oracle)
  • Fixed bug:
  • With editing Entity Key values
  • With IndexOutOfRangeException on the DeleteOnSubmit call
  • On inserting new rows into a table with many-to-many association
  • With fetching records one-by-one from the 'detail' table in master/details relation
  • With retrieving entities of an inherited type
  • With using the Contains method of empty arrays
  • With the RejectChanges method not working
  • With structs in queries
  • With Command Timeout
  • 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

New in LinqConnect 1.0.39 (Sep 2, 2010)

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