dotConnect for SQLite	[email protected]
History

6.3.104 08-Nov-24

• Supported Visual Studio 2022 version 17.12 Preview
• Fixed an issue with integration in Visual Studio 2015 and earlier versions
• Fixed the DataSet Wizard crash in Visual Studio 2022
• Fixed a design-time bug with the SQLiteCommand component in Visual Studio 2022
• Fixed a design-time bug with the SQLiteDataTable Tasks interface element in Visual Studio 2022

Entity Framework support

• Updated support for Entity Framework Core 8 to version 8.0.10
• Updated support for Entity Framework Core 6 to version 6.0.35
• Fixed an issue with connection enlistment in TransactionScope in EF Core 7 and later versions

Entity Developer

• Fixed an issue where the Update From Database Wizard reset navigation property names in EF Core models

6.3.21 06-Jun-24

Entity Framework support

• Updated support for Entity Framework Core 8 to version 8.0.6
• Updated support for Entity Framework Core 7 to version 7.0.20
• Updated support for Entity Framework Core 6 to version 6.0.31

6.3.20 29-May-24

• Supported Visual Studio 2022 version 17.11 Preview

Entity Framework support

• Updated support for Entity Framework Core 8 to version 8.0.5
• Updated support for Entity Framework Core 7 to version 7.0.19
• Updated support for Entity Framework Core 6 to version 6.0.30

Entity Developer

• Resolved an issue with saving 'Version=Original' in the Stored Procedure Mapping menu for LinqConnect model

6.3.10 17-Jan-24

• .NET 8 compatibility
• Visual Studio 2022 version 17.9 Preview is supported

Entity Framework support

• Entity Framework Core 8.0.0 is supported
• Entity Framework Core 7.0.14 is supported
• Entity Framework Core 6.0.25 is supported

LinqConnect (formerly known as LINQ to SQLite)

• .NET 8 compatibility

Entity Developer

• EF Core 8 is added to the list of available Entity Framework versions in Create Model Wizard and Model Settings in EF Core Model
• .NET 8 is added to the list of available Target Framework versions in Create Model Wizard and Model Settings in EF, EF Core, and LinqConnect models
• The new extended property Do Not Generate OnConfiguring Method is added for the model in EF Core Model
• The bug with unnecessary generation of the GetByKey() method in a repository for entities without primary key (QueryType=True) in EF Core is fixed
• The bug with wrongly turned on without the ability to turn off options "Detect Many-to-Many associations" and "Detect Table-Per-Type inheritances" in Model Settings of EF Core 1, 2, 3 models is fixed
• The bug with the availability of the "Table-Per-Type Hierarchy (TPT)" option in the "Model Refactoring" dialog of EF Core 1, 2, 3 models is fixed
• The bug with the availability of the "Table-Per-Concrete-Type Hierarchy (TPC)" option in the "Model Refactoring" dialog of EF Core 1, 2, 3, 5, 6 models is fixed
• The hang of Visual Studio 2022 when saving the model is fixed

6.2.0 16-Nov-23

• Visual Studio 2022 version 17.8 Preview is supported
• The SQLiteSnapshot class is implemented to record a snapshot of the current database state and restore a transaction to the existing snapshot
• The error during installation on the 32-bit version of Windows has been fixed

Entity Framework support

• The SQLiteSnapshot class is implemented to record a snapshot of the current database state and restore a transaction to the existing snapshot
• Entity Framework Core 7.0.10 is supported
• Entity Framework Core 6.0.21 is supported
• The bug with throwing Microsoft.EntityFrameworkCore.Infrastructure.ManyServiceProvidersCreatedWarning by the UseSQLite(DbConnection connection) extension method of DbContextOptionsBuilder in EF Core 6 and EF Core 7 is fixed
• The bug with using custom converters in mapping in EF Core 3 and higher is fixed

Entity Developer

• The bug with detecting the numeric default value of string columns as function-based column default value in EF Core Model is fixed

6.1.151 29-Jun-23

• Make schemas data type upper case

6.1.151 01-Jun-23

• Visual Studio 2022 version 17.7 Preview is supported
• The sqlite3.dll library that is included into the installation package is updated to the version 3.41.1

Entity Framework support

• Entity Framework Core 7.0.5 is supported
• Entity Framework Core 6.0.16 is supported
• The bug with ignoring schema set for indexes via CreateIndex() and DropIndex() operations of EF Core Code-First Migrations is fixed
• The bug with incorrect SQL translation of reused LINQ query, which includes array.Contains() and other expressions, in EF Core 5/6/7 is fixed
• The bug with generating parameter prefixed by a double colon in EF Core 7 is fixed

Entity Developer

• The behavior is changed: the primitive properties by default have Inheritance Modifier = None
• The bug with the detection of non-existent changes while updating a model from a database is fixed
• The bug with creating Devart Entity Model in Visual Studio 2022 is fixed
• The bug with missing model context namespace in EntityFrameworkUnitOfWork.cs produced by the Repository And Unit of Work template (C#) in EF Core is fixed
• The bug with generating incorrect scale in mapping for decimal columns by the EF Core template (Visual Basic) in EF Core 5 and higher is fixed
• The bug with code generation for TPT inheritance in the EF Core template is fixed

6.1.134 01-Mar-23

• Visual Studio 2022 version 17.5 Preview is supported
• .NET 7 compatibility
• In-built encryption support for SQLite databases implemented: AES-128, AES-192, AES-256, Blowfish, CAST-128, RC4, Triple DES
• Description of the password field in SQLite connection editor is updated

Entity Framework support

• Entity Framework Core 7.0.2 is supported
• Entity Framework Core 6.0.13 is supported
• Entity Framework Core 3.1.32 is supported

Entity Developer

• The new extended properties Do Not Generate Serializable Attribute and Do Not Serialize are added for complex types in EF Core Model
• The bug with applying the Generate Serializable Attributes and Serialization Library settings of the EF Core template to the generated complex types is fixed

6.0.0 30-Jun-22

• .NET 6 compatibility.
• macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support
• Windows 11 is supported.
• Visual Studio 2022 version 17.2 is supported.
• Visual Studio 2022 version 17.3 Preview is supported.

Entity framework:

• Entity Framework Core 6.0.5 is supported.
• Entity Framework Core 5.0.17 is supported.
• Entity Framework Core 3.1.25 is supported.

5.19.2066 25-Jan-22

Entity Developer

• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code

Entity Framework support

• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed

5.19.2042 21-Dec-21

Entity Developer

• The model validation is improved: the errors are generated for all entities with QueryType=True in EF Core Model when EF Core version=EF Core 1 in Model Settings
• The bug with wrong automatic assigning QueryType=True for views added to EF Core Model, when EF Core version=EF Core 1 in Model Settings, is fixed
• The bug with throwing System.NullReferenceException when saving the changed value of the "Save connection to" option in Model Settings of EF Core Model is fixed

Entity Framework support

• Entity Framework Core 6.0.1 is supported
• Entity Framework Core 5.0.13 is supported
• Entity Framework Core 3.1.22 is supported
• NetTopologySuite 2.4.0 is supported in EF Core 3, EF Core 5, and EF Core 6
• The bug with throwing the "Expression in SQL tree does not have type mapping assigned" error with NetTopologySuite in EF Core is fixed
• The bug with generating the "Value cannot be null" error when adding or dropping FK via Code-First Migrations in EF Core is fixed
• The bug with filtering on the DateTime column without using a parameter via LINQ query in EF Core 3 and EF Core 5 is fixed

5.18.2014 09-Nov-21

Entity Developer

• The bug with parsing discriminator value as string, even when its type is different, in TPH inheritance of EF Core Model is fixed

Entity Framework support

• Entity Framework Core 5.0.12 is supported
• Entity Framework Core 3.1.21 is supported

5.18.2001 21-Oct-21

• Visual Studio 2019 Preview support is discontinued
• The bug with throwing Devart.Common.LicenseException, when Devart.Data.SQLite.dll is embedded into a single file application, is fixed
• 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

LinqConnect (formerly known as LINQ to SQLite)

• The bug with parsing TypeName values in XML mapping generated by Visual Basic template is fixed

Entity Framework support

• Entity Framework Core 5.0.11 is supported
• Entity Framework Core 3.1.20 is supported
• The Code-First Migration operations RenameColumn (SQLite 3.25 and above) and DropColumn (SQLite 3.35 and above) are natively supported in EF4/EF5/EF6 and EF Core 1/EF Core 2/EF Core 3/EF Core 5
• The implementation of config.CodeFirstOptions.TruncateLongDefaultNames in EF6 .NET Standard compliant assemblies is improved: the generated names are constant, independent on a current domain and workstation
• The bug with using DateTime.Today, DateTime.Now, DateTime.UtcNow, DateTimeOffset.Now within LINQ query in EF Core 5 is fixed

5.18.1985 28-Sep-21

Entity Developer

• The new property Validation Framework is implemented in the Data Transfer Object template for generating DataAnnotations attributes
• The Uri data type is supported in EF Core Model
• The new option "Save connection to" is implemented in Model Settings of EF Core Model to provide the ability to store the connection string in "Model file", "Entity Developer storage", "Environment variable"
• The new option "Enum Output" is added to the EF Core template to specify output for the generated enums
• The new property Generate UnitOfWork Repository Properties (by default, True) is implemented in the Repository and Unit Of Work template of EF Core Model for accessing the collections of entities
• The representation of one-to-one association with non-nullable properties on both ends is changed from 1 -> 1 to 0..1 -> 1 on a diagram in EF Core Model
• The bug throwing "Unknown property 'DoNotSerialize'.", when complex types and VB.NET template are used in EF Core Model, is fixed
• The bug with code generation for the Constrained option of Association Editor in the case of 0..1 -> 1 association in EF Core Model is fixed

Entity Framework support

• Entity Framework Core 5.0.10 is supported
• Entity Framework Core 3.1.19 is supported
• The following Code-First Migration operations are supported in EF Core 3 and EF Core 5 via recreating a table and copying the existing data:
• AlterColumn
• RenameColumn (SQLite 3.24 and below)
• DropColumn (SQLite 3.34 and below)
• AddForeignKey
• DropForeignKey
• AddPrimaryKey
• DropPrimaryKey
• The SQL translation of the following class members used in LINQ query is supported in EF Core 3 and EF Core 5:
• static method IsNullOrWhiteSpace() of the String class
• static property Today and instance properties DayOfWeek, Ticks of the DateTime class
• static methods Max(), Min(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan() of the Math class
• Mapping of System.Decimal to SQLite DECIMAL with specified precision and scale in EF Core 5 is supported
• Mapping of internet/intranet data type System.Uri to SQLite TEXT is supported in EF Core 3 and EF Core 5
• Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to SQLite TEXT is supported in EF Core 5
• The SQL translation of these static methods of the MathF class used in LINQ query is supported in EF Core 5: Abs(), Round(), Truncate(), Floor(), Ceiling(), Max(), Min(), Pow(), Sqrt(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan()
• The definition of System.ICloneable is removed from .NET Framework assembly \Entity\EFCore3\Devart.Data.SQLite.Entity.EFCore.dll

5.17.1944 30-Jul-21

LinqConnect (formerly known as LINQ to SQLite)

• The new methods IsNotDistinctFrom() and IsDistinctFrom() are added to the Devart.Data.Linq.SqlMethods class

Entity Framework support

• Entity Framework Core 5.0.8 is supported
• Entity Framework Core 3.1.17 is supported
• The bug with using Int16 as a data type of the Primary Key property in EF Core Migrations is fixed

5.17.1930 08-Jul-21

• Visual Studio 2019 version 16.11 Preview 2.0 is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.36.0

Entity Developer

• The behavior of the Regenerate Storage and Mapping functionality in EF Core Model is changed: the NOT NULL attribute of the column is reset to undefined now; after that, the behavior depends on the Nullable attribute of the class property only
• The bug with applying the Default Precision and Default Scale values from Model Settings to the non-decimal data types by Update To Database Wizard in EF Core is fixed

Entity Framework support

• Entity Framework Core 5.0.7 is supported
• Entity Framework Core 3.1.16 is supported
• The bug with comparing enum values in EF Core 3 and EF Core 5 is fixed
• The bug with .Contains and .Length in EF Core 3 and EF Core 5, when using NetTopologySuite spatial functionality, is fixed

5.17.1905 03-Jun-21

Entity Developer

• The new extended property Use Generic DbContextOptions Constructor Argument is added to model properties of EF Core Model
• The new extended property Do Not Generate Constructor With DbContextOptions Argument is added to model properties of EF Core Model
• The bug with generating the Equals method for entities with Record Type=True by C# EF Core template is fixed
• The bug with cleaning values of Length and Precision/Scale column's attributes by Update From Database Wizard in EF Core Model 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
• 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

Entity Framework support

• Entity Framework Core 5.0.6 is supported
• Entity Framework Core 3.1.15 is supported
• The EF6 provider registration used with .NET Framework compliant assemblies is improved: the [DbConfigurationType(typeof(SQLiteEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation

5.17.1866 09-Apr-21

Entity Developer

• The new hotkey Alt+E is implemented in Property Editor for opening Column Editor in EF Core Model
• 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 missing .NET Framework, .NET Core 1, .NET Core 2 options for the Target Framework property in Model Settings of EF Core Model in a standalone Entity Developer is fixed
• The bug with preserving Target Framework=.NET Framework in Model Settings of EF Core Model in a standalone Entity Developer is fixed

5.17.1860 01-Apr-21

• Visual Studio 2019 version 16.10 Preview is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.35.3
• The bug with reading System.Byte[] instead of actual values of CHAR columns via SQLiteDataReader is fixed

Entity Developer

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

Entity Framework support

• Entity Framework Core 5.0.4 is supported
• Entity Framework Core 3.1.13 is supported

5.17.1836 18-Feb-21

• The sqlite3.dll library that is included into the installation package is updated to version 3.34.1
• The new command line option /disablegac that disables adding assemblies to GAC is added

Entity Developer

• The behavior is changed in Entity Developer embedded into Visual Studio: lower versions in the EF Core version property of Model Settings are not hidden any more
• The behavior is changed in EF Core Model: QueryType=True is set now for all classes without PK
• C# code generation is improved: the using directives are generated instead of full namespaces in the names of attributes for DataAnnotations, NHibernate Validator, and Enterprise Library validation frameworks
• Code generation is improved: OnModelCreating(modelBuilder) of the base class is invoked now if the Base Context Type property of EF Core Model is initialized

Entity Framework support

• Entity Framework Core 5.0.3 is supported
• Entity Framework Core 3.1.12 is supported
• The bug with translating Enum.HasFlag to SQL in EF Core 3 and EF Core 5 is fixed

5.17.1812 14-Jan-21

• The bug with blocking thread during retrieving a connection from the pool, when connections from the same pool are used in several threads, is fixed

Entity Developer

• The new attribute DisplayName is implemented for model objects' extended properties which are available via template properties
• The new options --ContextNamespace and --DefaultNamespace are added to the Create-Model command of Console Entity Developer
• The new extended model property Base Context Type is added for specifying a parent class for the generated context in EF Core Model
• The new extended properties Base Type for complex types and Base Complex Type for model are implemented in EF Core Model
• The %type name% keyword is supported in the Base Type extended property of entities and complex types, and in Base Complex Type, Base Entity Type, Base Context Type extended model properties for setting generic base type in EF Core Model
• Code generation is improved: RelationalIndexBuilderExtensions.HasDatabaseName is generated now instead of RelationalIndexBuilderExtensions.HasName in EF Core 5
• Display names of extended properties in EF Core Model are updated: Entity Base is renamed to Base Type in class properties, Entity Base is renamed to Base Entity Type in model properties, Context Base is renamed to Base Context Type in model properties
• The bug with setting additional keyboard mapping scheme via menu Options on Windows with German display language is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The new property Local is added to the Table and Table<T> classes to return a collection of the entities attached to the context
• The new method GetEntityState(object entity) is added to Table class and ITable interface to return one of the EntityState values
• The bug with throwing "Bad key member '...' in association '...' of type '...'." in runtime by .NET Standard compliant assemblies is fixed

Entity Framework support

• Entity Framework Core 5.0.2 is supported
• Entity Framework Core 3.1.11 is supported
• The new metadata to describe autoincremental columns via annotations in EF Core Code-First Migrations are implemented

5.17.1792 17-Dec-20

Entity Framework support

• Entity Framework Core 5.0.1 is supported
• The bug with creating savepoints in EF Core 5 is fixed

5.17.1782 03-Dec-20

• The sqlite3.dll library that is included into the installation package is updated to version 3.34.0
• Visual Studio 2019 version 16.9 Preview is supported
• The bug with using URI format with file path in the Data Source connection string parameter is fixed
• The bug with updating projects that reference EF6 provider assembly via Upgrade Wizard is fixed

Entity Developer

• The new features are supported in Entity Framework 5.0:
• TPT inheritance
• Many-to-many associations
• The new types of properties IPAddress and PhysicalAddress
• The Model Refactoring functionality is supported for classes in EF Core Model
• The behavior is changed in a standalone Entity Developer: by default the Target Framework model property in EF Core Model is set to .NET 5 instead of .NET Framework
• The bug with saving non-default value of Target Framework model property in EF6 model modified with a standalone Entity Developer is fixed
• 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

Entity Framework support

• Entity Framework Core 5.0 is supported
• Entity Framework Core 3.1.10 is supported
• The behavior is changed: EF Core 3 assemblies available via NuGet package are compiled for .NET Standard 2.0 instead of .NET Standard 2.1
• The behavior is changed: EF Core 2 assemblies are no longer available via NuGet package but created in the provider installation folder
• The bug with using another context's connection in DbContextOptionsBuilder.UseSQLite(connection) in EF Core is fixed

5.16.1759 29-Oct-20

• 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 missing Name and Owner properties of the SQLiteConnection class in .NET Standard compliant assemblies is fixed

Entity Developer

• The bug with reading templates from *.edps by console Entity Developer is fixed

Entity Framework support

• Entity Framework Core 3.1.9 is supported
• The bug with invalid attempt to load the SQLite extension library 'mod_spatialite', when .UseNetTopologySuite() is not used, in EF Core is fixed

5.16.1739 01-Oct-20

• Visual Studio 2019 version 16.8 Preview is supported

Entity Developer

• EF Core 3 spatial data types support is improved: in addition to Geometry and Geography, specific .NET NetTopologySuite types like GeographyPoint, GeographyLine are now available property types
• The default mapping for spatial data types in Server's Options is updated
• The bug with throwing "EntityProperty does not contain a definition for IsSpatialType", when custom template from previous versions is used, in EF Core Model is fixed
• The bug with applying On Delete Action=Cascade set in Association Editor to the Generate Database Script functionality in EF Core Model is fixed
• The bug with reading settings from *.edps by console Entity Developer is fixed

Entity Framework support

• The bug with throwing System.NullReferenceException by the Code-First CreateDatabase() / Code-First Migrations functionality in EF Core is fixed

5.16.1730 17-Sep-20

• The sqlite3.dll library that is included into the installation package is updated to version 3.33.0
• The SendCallStack property is added to the Devart.Common.DbMonitor class for possibility to turn off resource-demanding logging of CallStack
• The Filter property is added to the Devart.Common.DbMonitor class for possibility to choose events being logged
• The Devart.Common.DbMonitor class is improved: now values of the DateTime parameters sent to the dbMonitor tool are supplemented with milliseconds
• The bug with updating projects in folders below the main project by Upgrade Wizard is fixed
• The bug with using Microsoft DataSet Wizard is fixed

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
• The bug with generating mapping for the properties with Shadow=True in EF Core Model is fixed
• The bug with using spatial types inside complex types in EF Core Model is fixed

Entity Framework support

• Support for spatial data types in EF Core 3 is implemented
• Entity Framework Core 3.1.8 is supported
• The new NuGet package Devart.Data.SQLite.EFCore.NetTopolosySuite with a .NET Standard 2.1 assembly, that is compatible with .NET Core 3, is added
• The new \Entity\EFCore3\Devart.Data.SQLite.Entity.EFCore.NetTopolosySuite.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
• The SQLiteFunctions class, which allows using SQLite-specific functions in LINQ to Entities, is supported in EF Core
• The SQLiteTextFunctions class, which allows using SQLite full-text search functionality in LINQ to Entities, is supported in EF Core

5.15.1696 30-Jul-20

Entity Developer

• The bug with throwing System.NullReferenceException when opening *.edmx with invalid associations is fixed

5.15.1686 16-Jul-20

• The sqlite3.dll library that is included into the installation package is updated to version 3.32.3

LinqConnect (formerly known as LINQ to SQLite)

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

• The bug with incorrect SQL generation when using .Substring() in a .Select() statement in EF Core 2 is fixed

5.15.1666 17-Jun-20

• Visual Studio 2019 version 16.7 Preview is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.32.2

Entity Developer

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

LinqConnect (formerly known as LINQ to SQLite)

• The bug with materializing elements, the types of which are explicitly converted from non-nullable to nullable on the client side, is fixed
• The bug with incorrect detection of altered column comment in a many-to-many association join table by Update From Database Wizard is fixed

Entity Framework support

• Entity Framework 6.4.4 is supported
• The translation of the DateTime.AddMinutes() method in LINQ query into SQL statement in EF Core is supported
• The bug with adding / subtracting DateTime and TimeSpan, DateTimeOffset and TimeSpan values in LINQ query in EF Core 3 is fixed
• The bug with SQL generation in EF Core 3, when enum values are used in CASE and COALESCE statements, is fixed
• The EF6 provider registration used with .NET Standard compliant assemblies is improved: the [DbConfigurationType(typeof(SQLiteEntityProviderServicesConfiguration))] attribute set for DbContext descendant allows now calling the DbContext constructor, that accepts a connection string, with no need to register a custom IDbConnectionFactory implementation

5.15.1612 02-Apr-20

LinqConnect (formerly known as LINQ to SQLite)

• 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

• Command-line interface is implemented in a standalone Entity Developer
• The new property Context Name is added to Model Properties in EF Core Model
• The new property Target Framework is added to Model Properties in EF Core Model
• The provider registration is improved: requirement to put provider registration entry in the config file is not obligatory anymore
• Create Model Wizard is improved: now it allows installing multiple NuGet packages on the final step
• 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

Entity Framework support

• Entity Framework Core 3.1.3 is supported
• The .ToString() call for numbers, DateTime/DateTimeOffset properties and values in LINQ queries in EF Core is supported
• The call of Convert.ToString(value) in LINQ queries in EF Core is supported
• The bug with comparing milliseconds of DateTime properties is fixed

5.15.1583 20-Feb-20

• The sqlite3.dll library that is included into the installation package is updated to version 3.31.1
• The SQLiteDataTable and SQLiteDataSet classes are supported in .NET Standard 2.0
• The behavior is changed: pool is automatically cleared when AppDomain is being closed

Entity Developer

• The bug with returning multiple result sets in code generated by the EF Core template is fixed

Entity Framework support

• Entity Framework Core 3.1.1 is supported
• The bug with using nullable enum properties with default mapping to integers in LINQ query in EF Core 3.1 is fixed
• The bug with using value converters detected automatically by .HasConversion<string>() in EF Core 3 is fixed
• The bug with using NULL constant values in EF Core 3 is fixed
• The bug with using binary operators AND, OR in EF Core 3 is fixed
• The bug with setting a default value for DateTime and TimeSpan properties via EF Core Code-First Migrations is fixed

5.15.1541 23-Dec-19

• Visual Studio 2019 version 16.5 Preview is supported
• The bug with using Toolbox component SQLiteDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed
• The bug with enabling Devart DataSet Editor in Visual Studio 2017 and Visual Studio 2019 is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with using Toolbox component DbLinqDataSource in web projects of Visual Studio 2013, 2015, 2017, 2019 is fixed

Entity Developer

• The bug with creating one-to-one association basing on an optional FK in EF Core Model is fixed
• The bug with code generation for oneOrZero-to-one and one-to-many associations based on an optional FK in EF Core Model is fixed
• The bug with generating a mapping for a unique constraint specified in owned type property of EF Core Model is fixed

Entity Framework support

• Entity Framework 6.4 is supported
• Entity Framework Core 3.1 is supported
• The new \Entity\EFCore3\Devart.Data.SQLite.Entity.EFCore.dll assembly compiled with EF Core 3.1 and .NET Framework 4.6.1 is added
• The config.DatabaseScript.ForeignKey.IndexCreation configuration option is supported in EF Core 1/EF Core 2/EF Core 3
• The bug with creating a unique constraint in the database via EF Core Code-First Migrations is fixed
• The bug with applying .ValueGeneratedOnAdd() to the string, guid, byte[] properties with .Key() and without .HasDefaultValueSql() in EF Core is fixed
• The bug with using bitwise operators And, Or, Xor with Int64 arguments in LINQ query is fixed
• The bug with detecting implicit database column type, when model mapping and migration mapping are different, via EF Core Code-First Migrations is fixed
• The bug with generating SQL when using explicit cast in LINQ queries in EF Core 1/EF Core 2 is fixed
• The bug with throwing the "Null TypeMapping in Sql Tree" error by methods in LINQ query in EF Core 3 is fixed

5.14.1519 21-Nov-19

• The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Editor

Entity Developer

• The Self-Contained Entity Configuration property is added to VB.NET version of EF Core template
• The Entities Configuration Output property is added to VB.NET version of EF Core template
• The code generation for the class properties with Alternate Key=True by VB.NET version of EF Core template is supported in EF Core model
• The bug with code generation, when Raw SQL Query is initialized in class properties, in EF Core 3 model is fixed
• The bug with generating .HasNoKey(), when Self-Contained Entity Configuration is set to True in properties of EF Core template, in EF Core 3 model is fixed
• The bug with generating alternate keys, when Self-Contained Entity Configuration is set to True in C# version of EF Core template, in EF Core model is fixed

Entity Framework support

• The SQL generation in case of config.QueryOptions.UseCSharpNullComparisonBehavior=true in EF1/EF4/EF5/EF6 is improved
• The bug with using Scaffold-DbContext in EF Core 3 is fixed
• The bug with the redundant empty ORDER BY clause in a subquery, when paging is used, in EF Core 3 is fixed
• The bug with using .Contains within .Select of LINQ query in EF Core 2 is fixed
• The bug with generating invalid SQL when calling members of owned type in EF Core 2 is fixed

5.14.1504 31-Oct-19

• Visual Studio 2019 version 16.4 Preview is supported

Entity Developer

• The DbContext template is improved: precision and scale for database types are generated now in EF4/EF5/EF6 models when Fluent Mapping=True and Mapping Generation Strategy=UseAttributes
• The bug with throwing the EntityFrameworkCoreVersion error in Create Model Wizard in a standalone Entity Developer is fixed

Entity Framework support

• Entity Framework Core 2.2.6 is supported

5.14.1499 24-Oct-19

• The sqlite3.dll library that is included into the installation package is updated to version 3.30.1
• The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Manager

Entity Developer

• The DbContext template is improved for using Entity Framework 6.3:
• The "Configuration Type Name" property, which specifies the descendant of DbConfiguration class that should be used for code-based configuration, is added
• The "Use DbConfigurationType Attribute" property, which determines whether to register the configuration type specified in the ConfigurationTypeName property of the DbConfigurationType attribute, is added
• The DbProviderFactories.RegisterFactory method is generated when UseDbConfigurationTypeAttribute=true and ConfigurationTypeName='%Default%'
• With UseDbConfigurationTypeAttribute=false, the static constructor for registering factory and the new partial method OnStaticConfigured are generated
• The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported
• The compatibility issue with JetBrains ReSharper is fixed

Entity Framework support

• Entity Framework Core 3.0 is supported
• Entity Framework 6.3 is supported
• The lock for Microsoft.EntityFrameworkCore dependency is added to the NuGet package Devart.Data.SQLite.EFCore

5.13.1470 12-Sep-19

• The integration with Visual Studio 2019 is improved: now the installation detects both 2019 Release and 2019 Preview versions

Entity Developer

• Entity Framework 6.3 Preview 9 is supported for projects with target framework .NET Core 3 or .NET Standard 2.1
• The behaviour is changed: a plural form of names ending with "s" now has a longer version (for example, status -> statuses)
• The bug with applying the new Foreign Key's Delete Rule values SET DEFAULT and SET NULL by the Update Database From Model and Update Model From Database wizards is fixed (Entity Framework)
• The bug with copying a property with Primary Key=True / Entity Key=True to a complex type is fixed (Entity Framework)
• The bug with naming of a composing unique key by Create Model Wizard / Update From Database Wizard in EF Core is fixed (Entity Framework)
• The bug with invalid attempt to cast unsupported Visual Studio project to type 'VSLangProj.VSProject' is fixed

Entity Framework support

• Entity Framework 6.3 Preview 9 is supported
• A new NuGet package Devart.Data.SQLite.EF6 with a .NET Standard 2.1 assembly, compatible with .NET Core 3, is added
• The bug with using the same database connection in several EF Core contexts is fixed
• The bug with applying a value converter to .Where expression with .Contains on nullable enum in EF Core 2 is fixed

5.12.1437 25-July-19

• The sqlite3.dll library that is included into the installation package is updated to version 3.29.0

Entity Framework support

• The bug with applying a value converter to a nullable column in EF Core 2 is fixed

5.12.1422 04-July-19

• The bug with throwing "Operation is not supported" by web providers, when the cookie is used, is fixed

Entity Developer

• The ability to disable generation of the byte order mark (BOM) in the beginning of code files in a standalone Entity Developer is implemented
• The bug with design time copy/cut/paste functionality for entities is fixed
• The bug with invalid integer to enum conversion by a generated method, which is based on SQL query and returns a collection of entities, in EF Core 2 is fixed

Entity Framework support

• The bug with applying a filter to the nullable property with implicit EnumToStringConverter via LINQ queries in EF Core 2 is fixed
• The bug with missing brackets around SELECT inside the generated CASE statement in EF Core 2 is fixed
• The bug with nullable parameters in EF Core 2 is fixed
• The bug with reopening connections in EF Core 2 is fixed
• The bug with incorrect exception message on opening connection, when ConnectionString is not set, by .NET Standard compliant assemblies is fixed

5.12.1402 06-Jun-19

• The sqlite3.dll library that is included into the installation package is updated to version 3.28.0
• Deprecated design-time Synchronous API calls are no longer used with Visual Studio 2019 and Visual Studio 2017

LinqConnect (formerly known as LINQ to MySQL)

• 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

Entity Framework support

• Entity Framework Core 2.2.4 is supported
• The bug with closing database connection by context.Dispose() in the scope of a distributed transaction in EF Core 2 is fixed
• The bug with using a value converter, when the .NET data type remains the same, within the WHERE clause in EF Core 2 is fixed

5.12.1366 11-Apr-19

• Visual Studio 2019 is supported

Entity Developer

• The bug with processing DBNull returned by the function in EF Core is fixed

Entity Framework support

• The bug with using the "Generate Database from Model" wizard when working with Entity Framework 6 Tools is fixed

5.11.1357 28-Mar-19

• Visual Studio 2019 Release Candidate 4 is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.27.2
• The behavior is changed: reader.GetValue("text_column_with_nonstandard_typename") returns now the System.String object
• The bug with loss of changes, applied in different concurrent transactions, when journaling is not in the WAL mode, is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with using the System.Char argument as literal or variable in LINQ query is fixed

Entity Framework support

• Entity Framework Core 2.2.3 is supported
• The SQL translation of the following method overloads, that accept the StringComparison argument and return bool, in the System.String class is supported in EF Core 2: Contains, StartsWith, EndsWith, Equals
• The bug with generating the COALESCE expression in EF Core is fixed

5.11.1328 14-Feb-19

• The sqlite3.dll library that is included into the installation package is updated to version 3.27.1

LinqConnect (formerly known as LINQ to SQLite)

• The bug with executing incorrect SQL request (cached during one of the previous calls), when .Contains() is invoked in the multithreaded application, is fixed

Entity Developer

• The bug with generating fluent mapping for the one-to-one association by the DbContext template in EF4/EF5/EF6 is fixed

Entity Framework support

• The translation of single-char literal into SQL statement in EF Core is supported
• The bug with throwing Devart.Common.LicenseException when using config.Workarounds.ProviderManifestToken in EF Core is fixed
• The bug with using a value converter for the property used in .Contains() in EF Core 2 is fixed
• The bug with translating String.IndexOf() into SQL statement in EF Core is fixed
• The bug with updating a null value of the concurrency check column with some non-null value in EF Core is fixed

5.11.1307 10-Jan-19

• The sqlite3.dll library that is included into the installation package is updated to version 3.26.0
• The bug with connecting to database with .NET Standard 1.3 compatible assemblies on .NET Framework 4.6.0 run-time is fixed

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Developer

• The multiple select functionality in EF Core Model is improved: now it allows setting PrimaryKey, ValueGenerated, Concurrency for several properties simultaneously
• The bug with detecting order of columns in composite primary key with two or more columns by Update To Database and by Update From Database wizards in EF Core is fixed
• The bug with using ASP.NET Core Web Application (.NET Framework) and Azure Functions v1 (.NET Framework) projects in Visual Studio 2017 is fixed

Entity Framework support

• Entity Framework Core 2.2.1 is supported
• The new extension method Database.IsSQLite() in EF Core 2 is implemented
• The bug with applying config.Workarounds.IgnoreSchemaName=true to the .ToTable() functionality in EF Core 2 is fixed
• The bugs with using the GuidToStringConverter, EnumToStringConverter, ValueConverter classes in EF Core 2 are fixed
• The bug with constructing the LIKE clause in EF Core 2 is fixed
• The bug with generating a subselect within the SELECT list in EF Core 2 is fixed
• The bug with applying an aggregate function to the result of a subselect in EF Core 2 is fixed

5.11.1278 29-Nov-18

• The sqlite3.dll library that is included into the installation package is updated to version 3.25.3

LinqConnect (formerly known as LINQ to SQLite)

• The bug with throwing "Operation could destabilize the runtime." during materialization of result set, when query includes a cast to the base unmapped class, is fixed

Entity Developer

• The new Generate GeneratedCode Attributes option (by default, False) is added to the DbContext template in EF4/EF5/EF6 and the EF Core template
• The new Generate Dummy Comments option (by default, False) is added to the DbContext template in EF4/EF5/EF6
• The code formatting is fixed in the DbContext template in EF4/EF5/EF6 and the EF Core template
• The bug with generating fluent mapping for the TPC inheritance by VB.NET version of DbContext template in EF4/EF5/EF6 is fixed

Entity Framework support

• The bug with quoting the table alias, that includes an invalid character, in the SQL query generated by EF Core is fixed
• The bug with generating a subquery within the IN clause in EF Core 2 is fixed
• The bug with generating a subselect within the CASE clause in EF Core 2 is fixed
• The bug with comparing columns, that use a value converter, to parameters and constants in EF Core 2 is fixed

5.11.1253 25-Oct-18

• The sqlite3.dll library that is included into the installation package is updated to version 3.25.2

LinqConnect (formerly known as LINQ to SQLite)

• The bug with updating the existing entities that participate in FK associations is fixed in .NET Standard 2 compliant assemblies

Entity Developer

• The bug with throwing "Custom tool error: bufferAdapter is not a VsTextDocData" in .NET Standard projects is fixed

Entity Framework support

• Entity Framework Core 2.1.4 is supported
• The bit-wise functions OR, AND in EF Core are supported
• The bug with throwing "Collection was modified; enumeration operation may not execute" by EF Core provider in multithreaded applications is fixed
• The bug with using Scaffold-DbContext in EF Core 2 is fixed

5.11.1229 20-Sep-18

• The sqlite3.dll library that is included into the installation package is updated to version 3.25.1
• The bug with absent Devart.Data.SQLite.NHibernate.NHibernateSQLiteConnection and Devart.Data.SQLite.NHibernate.NHibernateSQLiteCommand classes in the .Net Core NuGet package is fixed

Entity Developer

• Using an extended property of type OutputInfo is supported
• Code generated for nullable properties is simplified: now T? is generated instead of System.Nullable<T>
• An additional constructor that accepts DbContextOptions as an argument is added to the DbContext class descendant in the VB.NET version of the DbContext template for EF Core
• The bug with "No database provider has been configured for this DbContext." in the DbContext template for EF Core is fixed
• The bug with code generation for nullable properties for EF1/EF4/EF5/EF6 is fixed

Entity Framework support

• Entity Framework Core 2.1.3 is supported
• The bug with throwing an error by context.Database.Migrate(), when the __EFMigrationsHistory table already exists but tables being mapped by model classes are not created yet, in EF Core 2 is fixed
• The bug with a memory leak in EF Core 2, when a connection is set for DbContext as an SQLiteConnection instance, and not via a connection string, is fixed

5.11.1216 30-Aug-18

Entity Developer

• The bug with creating and opening the model in .NET Core project after VS 2017 upgrade to v15.8 is fixed (Entity Framework, LinqConnect)

Entity Framework support

• Entity Framework Core 2.1.2 is supported
• The bug with using Scaffold-DbContext against multicolumn PK, FK, IX, UX in EF Core 2 is fixed

5.11.1202 09-Aug-18

Entity Framework support

• The behavior is changed: the default value of config.QueryOptions.UseCSharpNullComparisonBehavior is true now in EF Core
• The bug with incorrect generation of shortened PK/FK/IX/UX names in EF Core when using .NET Standard provider assemblies is fixed
• The bug with SQL generation for comparing column with parameter in EF Core 2 is fixed

5.11.1190 19-Jul-18

• The IDbColumnSchemaGenerator interface and the SQLiteDataReader.GetColumnSchema() method are implemented in .NET Standard provider assemblies
• The EncryptionLicenseKey property is added to SQLiteConnectionStringBuilder for specifying a license key for the SQLiteCrypt and SQLCipher encryptions
• The "Encryption License Key" parameter is added to a connection string of SQLiteConnection for specifying a license key for the SQLiteCrypt and SQLCipher encryptions

Entity Framework support

• The SQLiteFunctions.Printf method in EF4/EF5/EF6 is implemented
• The bug with paging in EF Core 2.1 is fixed
• The bug with using the aggregate functions in EF Core 2.1 is fixed
• The bug with processing arguments of functions mapped via .HasDbFunction in EF Core 2 is fixed
• The bug with applying a filter with implicit EnumToStringConverter via LINQ queries in EF Core 2 is fixed
• The bug with using the String.CompareTo method via LINQ queries in EF Core is fixed

5.11.1172 21-Jun-18

• The sqlite3.dll library that is included into the installation package is updated to version 3.24.0

Entity Developer

• Entity Framework Core 2.1 is supported
• Query type support is added: classes now have the Query Type property, and if it is set to true, this class is generated as a query type
• Lazy loading for Entity Framework Core 2.1 is supported:
• Model now has the Use Lazy-Loading Proxies property, which enables lazy loading on the model level
• Navigation properties now have the Lazy property, which enables lazy loading for a specific navigation property
• Properties now have the Constructor Parameter property, for configuring a parameterized constructor of the class
• The "Include Environment Variables" property, determining whether context configuration will be extended with environment variables when a connection string from the appsettings.json file is used, is added to the EF Core template
• The "Json File Base Path" property, specifying the base path for file-based providers when a connection string from the appsettings.json file is used, is added to the EF Core template

Entity Framework support

• Entity Framework Core 2.1.1 is supported
• The bug with applying the updated provider behavior after changing connection string options in EF Core 2 is fixed
• The bug with generating incorrect SQL when using IndexOf expression in EF Core is fixed

5.10.1152 24-May-18

LinqConnect (formerly known as LINQ to SQLite)

• A destructor for DataContext is added

Entity Framework support

• Entity Framework Core 1.1.5 is supported
• Entity Framework Core 2.0.3 is supported
• The config.Workarounds.ProviderManifestToken option is added for setting provider manifest token for all contexts within application domain
• The bug with missing Devart.Data.SQLite.Entity namespace in *.Designer.cs generated by EF Core 2 Code-First Migrations via Devart NuGet package is fixed
• The bug with generating Guid literals in SQL statements, when a connection string includes "BinaryGUID=False;", is fixed

5.10.1134 27-Apr-18

• The sqlite3.dll library that is included into the installation package is updated to version 3.23.1

Entity Developer

• The new Controller Area extended class property is added to EF Core Model (Entity Framework models)
• The check of conditions for setting optionsBuilder.Use... in the generated OnConfiguring method by the EF Core template is improved (Entity Framework models)

Entity Framework support

• The bug with retrieving the DateTimeOffset and TimeSpan data in EF Core is fixed

5.10.1115 29-Mar-18

• The behavior is changed: the License Key connection string parameter value is not sent to the dbMonitor instance when "Persist Security Info=false;"
• The bug with throwing the "IDE not supported" exception by DataSet Manager in Visual Studio 2017 of versions 15.6.* is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The XmlMappingSource.FromResource method is supported in .NET Standard provider assemblies
• The behavior is changed: all existing overloads of the method DataContext.Query() are replaced with DataContext.Query(String,params Object[])
• The behavior is changed: the License Key connection string parameter value is not sent to the LinqMonitor instance when "Persist Security Info=false;"

Entity Developer

• The new SQL Type, Size, Precision, Scale options are added to the Parameters tab in Method Editor of EF Core Model (Entity Framework models)
• The process of synchronizing methods and parameters with database stored procedures in EF Core Model is improved (Entity Framework models)
• The bug with adding entry to appsettings.json, when "Use the following connection string from App.Config" and "Rewrite connection string during regeneration" in Model Settings are turned on, is fixed (Entity Framework models)
• The bug with throwing the "Multiple constructors accepting all given argument types have been found in type '...'. There should only be one applicable constructor." error by the code generated with the MVC Controller template in ASP.NET Core Web Application is fixed (Entity Framework models)
• The bug with missing DataMember attribute on the Many end of an association, when using the EF Core template with "Generate Data Contracts=True", is fixed (Entity Framework models)
• The bug with the Retrieve Data functionality on the base class of TPH inheritance is fixed
• The bug with the Find Next functionality of T4 Editor embedded into Visual Studio is fixed
• The bug with throwing the "IDE not supported" exception by Entity Developer in Visual Studio 2017 of versions 15.6.* is fixed

Entity Framework support

• Entity Framework Core 2.0.2 is supported

5.10.1086 15-Feb-18

• The sqlite3.dll library that is included into the installation package is updated to version 3.22.0
• The bug with copying sensitive information in a connection string of a new connection object by SQLiteConnection.Clone() is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with throwing MethodAccessException by .NET Standard provider assemblies when referencing them to a project, targeting Full .NET Framework, is fixed

Entity Developer

• Support for ASP.NET Core MVC is added to the Data Annotations Metadata template (Entity Framework models)
• The bug with applying the DevartEFCoreGenerator custom tool in Visual Basic .NET Core projects is fixed (Entity Framework models)

5.10.1061 11-Jan-18

• The type of the Offset and Length properties of the ScriptProgressEventArgs class is changed from Int32 to Int64
• The type of the Offset and Length properties of the RestoreProgressEventArgs class is changed from Int32 to Int64

Entity Developer

• The ModelNameAsFilesPrefix property is implemented in the RepositoryAndUnitOfWork template
• Support for ASP.NET Core MVC is added to the MVC Controller template (Entity Framework models)
• The code generation for async method calls in the EF Core template is improved (Entity Framework models)
• The behaviour is changed: a base class in TPT Inheritance is allowed to be abstract now (LinqConnect models)

Entity Framework support

• Entity Framework Core 1.1.4 is supported
• Entity Framework Core 2.0.1 is supported
• The bug with ignoring the maxLength, precision, scale property settings by update-database in EF Core is fixed
• The bug with using enumerations in EF Core model is fixed
• The bug with LIKE (.StartsWith/.Contains./EndsWith) is fixed
• The bug with case-insensitive comparison is fixed

5.10.1031 23-Nov-17

• The CancelEditRowIfUpdateFailed property, determining whether to call CancelEdit for the row after update of the row is failed when data binding is used, is added to SQLiteDataTable

LinqConnect (formerly known as LINQ to SQLite)

• The performance of generating complex queries is improved

Entity Developer

• The new "Detect function-based column default value" option is implemented in Model Settings of EF Core model
• The code generation for async method calls is added to the EF Core template
• The usage of long identifiers (up to 140 symbols) for naming model objects is supported

Entity Framework support

• Entity Framework 6.2 is supported
• The SQL generation for subselects, when using Distinct(), in EF1/EF4/EF5/EF6 is optimized
• The Code-First Migrations functionality in EF Core is improved:
• the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2) are supported
• The bug with using UseSQLite(DbConnection) extension method of DbContextOptionsBuilder in EF Core is fixed
• The bug with invoking Database.EnsureDeleted(), when pooling for the corresponding connection is turned on, in EF Core is fixed
• The bug with using collections in a .Contains() method in EF Core 2 is fixed
• The bug with JOIN conditions in SQL generated from LINQ query in EF1/EF4/EF5/EF6 is fixed
• The bug with using multiple .Include() in EF Core 2 is fixed
• The bug with processing conditions in LINQ queries with joins in EF Core is fixed

5.10.1013 30-Oct-17

• .NET Standard 2.0 is supported
• .NET Standard 2.0 compatible assemblies are added to the Devart.Data and Devart.Data.SQLite NuGet packages
• The SQLiteDataAdapter and SQLiteCommandBuilder are implemented
• The SQLiteConnection.GetSchema() and SQLiteDataReader.GetSchemaTable() methods for metadata retrieving are implemented
• The SQLiteDump class is implemented
• Component classes in .NET Standard 2.0 compatible assemblies are inherited from the Component class, and some of them implement the ICloneable and ISupportInitialize interfaces
• Some of the classes, representing data types, now implement the INullable and ISerializable interfaces
• .NET Core 2.0 is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.21.0

LinqConnect (formerly known as LINQ to SQLite)

• .NET Standard 2.0 is supported
• .NET Core 2.0 is supported
• The bug with .Union().Any() is fixed

Entity Developer

• .NET Standard 2.0 projects in Visual Studio 2017 are supported
• .NET Core 2.0 projects in Visual Studio 2017 are supported
• Entity Framework Core 2.0 is supported
• The Retrieve Data functionality via Model Explorer for EF Core 2 is implemented
• The bug with escaping invalid XML characters in the comments generated by templates is fixed

Entity Framework support

• Entity Framework Core 1.1.3 is supported
• Entity Framework Core 2.0 is supported

5.9.980 06-Sep-17

• The integration with Visual Studio 2017 is improved: the installation is now silent, without VSIX Installer prompt window
• The sqlite3.dll library that is included into the installation package is updated to version 3.20.1

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

Entity Framework support

• The bug with using a variable with null value in LINQ query in EF Core is fixed

5.9.958 03-Aug-17

Entity Developer

• The new Raw SQL Query class property and SQL method property with the corresponding editors are implemented in Entity Framework Core
• The bug with generating code for the PropertyChanging event is fixed
• The bug with applying Custom Tool by Devart Entity Model (*.edml) in VS 2017 .NET Core projects is fixed
• The bug with quoting default table and column names in EF Core is fixed
• The bug with registering DevartEntityDeploy on the workstation with just Build Tools for Visual Studio 2017 installed is fixed

Entity Framework support

• The possibility to set DEFAULT for a table column via the DefaultValue annotation in EF6 Code-First Migrations fluent mapping is implemented
• The bug with using Contains() in multiple LINQ queries in EF Core is fixed
• The bug with comparison and binary operations in EF Core is fixed

5.9.946 13-Jul-17

Entity Developer

• The behaviour is changed: IsRequired(false / true) for navigation properties is always generated in EF Core fluent mapping now
• The bug with throwing "Can't load provider assembly." by EF6 model in a standalone Entity Developer is fixed
• The bug with serializing user defined extended properties for associations is fixed
• The bug with a Devart provider not found in Entity Developer as a standalone application when the provider is installed without placing Devart assemblies to the GAC is fixed

5.9.931 22-Jun-17

• The sqlite3.dll library that is included into the installation package is updated to version 3.19.3
• The compatibility with Visual Studio 2017 Updates is improved
• The bug with using the 'Do not install assemblies in the GAC' install wizard functionality for Visual Studio 2017 is fixed
• 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 reading an array of bytes as a string is fixed

Entity Developer

• The bug related to the conflict of Entity Developer with dbForge SQL Complete is fixed
• The bug with generating .NET Core code by EF Core and LinqConnect templates for the "Use the following connection string from App.config" option in Model Settings is fixed

Entity Framework support

• The bug with SQL generation of literals for System.Guid values is fixed

5.9.912 25-May-17

• .NET Core is supported
• The NuGet packages with .NET Standard 1.3 (.NET Core) compliant assemblies are uploaded to www.nuget.org
• The sqlite3.dll library that is included into the installation package is updated to version 3.19.0
• The bug with previewing a DataSet is fixed
• The bug with reading Unicode characters with the "UTF16=True;" connection string parameter is fixed

Entity Developer

• 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

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Framework support

• Entity Framework Core 1.1.2 is supported
• The support of EF Core models with string columns, which are defined without length limit and participate in PKs, FKs, indices, is improved
• The compatibility with ASP.NET Core Identity is improved
• The bug with ordering within subqueries in EF1, EF4, EF5, EF6 is fixed
• The bug with using config.CodeFirstOptions.TruncateLongDefaultNames in EF Core is fixed
• The bug with using the ForSQLiteHasColumnName and ForSQLiteHasColumnType modelBuilder methods with the value-type properties in EF Core is fixed
• The bug with paging in EF Core is fixed

5.8.862 16-Mar-17

• Visual Studio 2017 is supported

Entity Developer

• The bug with generating the virtual keyword when Inheritance Modifier=None is fixed (Entity Framework models)

Entity Framework support

• Entity Framework Core 1.1.1 is supported

5.7.852 02-Mar-17

• Visual Studio 2017 Release Candidate 4 is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.17.0
• The JSON extension is added to a predefined sqlite3.dll

Entity Developer

• The bug with throwing the "Stack empty" error after stopping validation before code generation in a standalone version is fixed (Entity Framework models)
• The bug with a workability of the "Validate on Build" option in Model Settings is fixed (Entity Framework models)
• The bug with compilation of the EF Core template after copying it to model folder is fixed (EF Core models)

Entity Framework support

• The translation of collection's Contains method in LINQ query to SQL statement in EF Core is supported

5.7.837 09-Feb-17

• Visual Studio 2017 Release Candidate 3 is supported

LinqConnect (formerly known as LINQ to SQLite)

• The bug with using DataLoadOptions.LoadWith is fixed

5.7.832 02-Feb-17

Entity Framework support

• The bug with creating a predefined Migrations History table in EF Core, when config.Workarounds.DisableQuoting = true, is fixed

5.7.819 16-Jan-17

• Visual Studio 2017 Release Candidate is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.16.2

LinqConnect (formerly known as LINQ to SQLite)

• The behavior is changed: DataContext.CreateDatabase() uses now the same datatype names like the ones used in model mapping

Entity Framework support

• The bug with comparing non-nullable properties in LINQ query when config.QueryOptions.UseCSharpNullComparisonBehavior=true is fixed
• The bug with using AddForeignKeyOperation and DropForeignKeyOperation in EF Core Code-First Migrations is fixed

5.7.804 22-Dec-16

Entity Framework support

• The bug with grouping by constant expression in EF1/EF4/EF5/EF6 when using DevExpress.XtraGrid.GridControl is fixed
• The bug with creating indices by EF Core Code-First migrations is fixed

5.7.794 08-Dec-16

• 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 sqlite3.dll library that is included into the installation package is updated to version 3.15.2
• The bug with generating an error when using SQLiteMonitor on Linux is fixed
• The bug with not using parameters value in ParentRelation data in SQLiteDataTable.SelectCommand is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The exception message for invoking CreateDatabase() for the model which includes an association with missing end is improved
• The bug with throwing System.InvalidCastException when inserting / updating the System.Object properties is fixed

Entity Developer

• The possibility to choose whether to add new entities to a diagram or not in Update From Database Wizard is implemented
• The behaviour is changed: now the DbContext template generates an additional partial class for the context class when "File Per Class" and "Generate Partial Class" are set to True (Entity Framework models)

Entity Framework support

• Entity Framework Core 1.1.0 is supported
• The Scaffold-DbContext NuGet command of Package Manager Console for generating a model basing on the existing database schema is supported in EF Core
• The new config.DatabaseScript.Column.StringColumnCustomCollationName option is implemented for setting user-defined function for comparing string columns
• The bug with comparison in LINQ query when config.QueryOptions.UseCSharpNullComparisonBehavior=true is fixed
• The bugs with logical expressions in EF Core are fixed

5.6.763 20-Oct-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.15.0

5.6.753 06-Oct-16

LinqConnect (formerly known as LINQ to SQLite)

• 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 generation of static methods by the EntityObject template is supported via the new property Direct Call of EntityMethod (Entity Framework models)

Entity Framework support

• The bug with comparing bool class property with some value in EF Core is fixed

5.6.743 22-Sep-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.14.2

Entity Developer

• The bug with moving mapping from abstract base class to child classes of TPH inheritance in the fluent mapping generated by the DbContext template is fixed (Entity Framework models)

LinqConnect (formerly known as LINQ to SQLite)

• The bug with materialization in the multithreaded application is fixed

Entity Framework support

• Entity Framework Core 1.0.1 is supported
• The new optional parameter Action<SQLiteDbContextOptionsBuilder> is added to UseSQLite() extension method of DbContextOptionsBuilder in EF Core
• The bug with processing IN expressions in EF Core is fixed
• The bug with retrieving objects of TPH hierarchy in EF Core is fixed

5.6.729 01-Sep-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.14.1
• The bug with data preview in the SQLiteDataTable designer when the command text was changed is fixed

Entity Framework support

• The DatabaseFacade.GetSQLiteConnection() extension method, which returns SQLiteConnection, is implemented in EF Core
• The bug with using the DatabaseFacade.UseTransaction() method in EF Core is fixed
• The bug with nullable parameters in EF Core is fixed
• The bug with throwing System.NullReferenceException when using TPH inheritance in EF Core is fixed
• The bug with not throwing concurrency check exception on invoking DbContext.SaveChangesAsync() is fixed

5.6.714 11-Aug-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.14.0

Entity Developer

• The bug with setting value of the Value Generated property attribute in the EF Core model is fixed

Entity Framework support

• The bug with executing the UseSQLite(DbConnection connection) extension method of DbContextOptionsBuilder in EF Core is fixed
• The bug with using the DbContext(DbConnection connection) overload in EF Core is fixed
• The bug with using EF Core logging is fixed
• The bug with using enum values in EF Core is fixed
• The bug with throwing DbUpdateConcurrencyException in EF Core is fixed
• The bug with using comparisons in LINQ queries in EF Core is fixed

5.6.699 21-Jul-16

Entity Framework support

• SQLiteCSharpMigrationCodeGenerator and SQLiteVisualBasicMigrationCodeGenerator for code-based migrations are implemented for EF4, EF5, EF6
• The config.QueryOptions.CaseInsensitiveComparison option is implemented to manage the compare behaviour when using Linq to Entities comparison expression such as "a == b" (by default, false)
• The config.QueryOptions.CaseInsensitiveLike option is implemented to manage LIKE behaviour when using Linq to Entities extention methods .Contains() .EndsWith() .StartsWith() (by default, false)
• The bug with using the .ToLower() and .ToUpper() canonical functions with non-latin symbols is fixed
• The bug with convertation of enum values in parameters when using EF Core is fixed

5.6.687 07-Jul-16

Entity Developer

• Entity Framework Core 1.0 RTM is supported
• The possibility to set values of stored procedure parameters for getting metadata to generate automatically the corresponding complex type is implemented
• The behaviour is changed: the ObservableCollection navigation properties are initialized now in a default class constructor (Entity Framework models)

Entity Framework support

• Entity Framework Core 1.0 RTM is supported

5.6.677 23-Jun-16

• The bug with not adding records to the RSPreviewPolicy.config and RSReportDesigner.config files for correct work in Reporting Services(SSRS) projects is fixed

Entity Framework support

• The SQLiteConventionSetBuilder class is implemented in the Entity Framework Core support

5.6.667 09-Jun-16

• Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services, Reporting Services, and Integration Services (mapping wizards) in Visual Studio 2015 are supported

LinqConnect (formerly known as LINQ to SQLite)

• The bug with setting string parameter data types in SQL statements generated basing on the Contains LINQ operator is fixed

5.5.658 26-May-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.13.0

Entity Developer

• Entity Framework Core support is added
• The DbProviderFactory provider registration in application's *.config is supported by the Entity Developer version integrated into Visual Studio

Entity Framework support

• Entity Framework Core RC2 is supported

5.5.649 12-May-16

• Compatible with other dotConnect providers

5.5.644 05-May-16

Entity Framework support

• Upgrade Wizard is improved for upgrading projects with the Entity Framework functionality

5.5.639 21-Apr-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.12.2
• The Run Once Command connection string parameter, which specifies a command to execute when the connection is opened the first time and not executed when the connection is taken from the pool, is added
• Truncate member that represents the TRUNCATE TABLE statement is added to the SqlStatementType enum

Entity Framework support

• Entity Framework Core RC1 is supported
• Entity Framework-related assemblies are renamed

5.3.616 17-Mar-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.11.1

Entity Developer

• The bug with matching SSDL columns automatically generated for association is fixed (Entity Framework models)

5.3.602 25-Feb-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.11.0

5.3.592 11-Feb-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.10.2

Entity Developer

• The bug with determination of NULL values as strings while reading metadata for columns with "DEFAULT NULL" via the Database-First approach is fixed (LinqConnect models)
• The code generation by the DbContext template (fluent mapping) for navigation properties is fixed (Entity Framework models)

5.3.583 21-Jan-16

• The sqlite3.dll library that is included into the installation package is updated to version 3.10.1
• The SQLiteConnecton.IsFunctionRegistered() method is added to check if some user-defined function has already been registered for a current session
• The new metadata collection is added: SQLiteConnection.GetSchema("UserDefinedFunctions") returns information about all user-defined functions registered for a current session

Entity Developer

• The bug related to the incorrect change detection when updating database from model (the comments) is fixed (LinqConnect models)

5.3.563 24-Dec-15

• Compatible with other dotConnect providers

5.3.558 17-Dec-15

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to the "Unable to cast object of type 'Devart.Data.Linq.Engine.SqlColumnRef'" error when using a TPT inheritance is fixed

5.3.543 26-Nov-15

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to the "Index was out of range. Must be non-negative and less than the size of the collection." error when enumerating an IQueryable collection is fixed
• The bug with materializing objects having EntitySet<T> fields via non-anonymous class that is not included in the model is fixed

5.3.535 12-Nov-15

• The sqlite3.dll library that is included into the installation package is updated to version 3.9.2
• The bug with throwing the "Unknown connection string parameter" exception is fixed

5.3.521 22-Oct-15

• The sqlite3.dll library that is included into the installation package is updated to version 3.9.1

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to the "Collection is read-only" error when loading mapping of a stored procedure/function that returns a class, mapped as Table, but not related to the DataContext class, is fixed
• The bug related to using IQueryable<T>.Count() is fixed

Entity Developer

• The bug with applying naming rules for model properties is fixed
• The bug related to the "Sequence contains no matching element" error in Update Wizards when working with TPH inheritances and many-to-many associations is fixed (LinqConnect models)
• The bug related to the StackOverflowException when deleting method from model in Model Explorer is fixed (LinqConnect models)

Entity Framework support

• The config.DatabaseScript.Column.StringColumnCollation configuration option is added to provide the possibility of managing case sensitivity of the newly created string columns

5.3.506 01-Oct-15

Entity Framework support

• The bug with comparing DateTime properties is fixed

5.3.497 17-Sep-15

LinqConnect (formerly known as LINQ to SQLite)

• The Parent property is added to the IInheritanceConfiguration interface
• The bug related to working with TPH inheritances and fluent mapping approach is fixed

Entity Developer

• The bug with wrong diagram layout is fixed
• The bug with checking the evaluation period in the trial version is fixed

5.3.492 10-Sep-15

• The bug with throwing the "IDE not supported" exception by DataSet Manager in Visual Studio 2015 is fixed

5.3.478 20-Aug-15

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.11.1
• The new Cell Size Check, Cache Spill, Journal Size Limit, Threads, WAL Auto Checkpoint connection string parameters are supported
• The SQLiteConnection.SQLCipherExport() method is added to migrate from an existing non-encrypted database to a new encrypted one
• The support for the binary representation of the GUID data types is added to the SQLiteDump class
• The bug with processing the BLOB data types in the SQLiteDump class is fixed
• The bug with simultaneous use of the "ReadOnly=True;" and "UTF16=True;" connection string options is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The possibility to use .IsRowVersion() method for properties with non-binary data types when using the fluent mapping approach is added
• The bug with the materialization of anonymous types is fixed

Entity Developer

• The Use ObservableCollection property of the DbContext template is implemented (Entity Framework models)
• The behaviour is changed: now the 1:1 and 1:0..1 associations are displayed differently on the diagram (LinqConnect models)
• The bug with adding LinqConnect template for C# after adding the WCF RIA Domain Service template (Visual Basic) in Visual Basic projects is fixed (LinqConnect models)
• The bug with non-generated .IsRowVersion() method for entity properties with IsVersion = True when using the fluent mapping approach is fixed (LinqConnect models)

Entity Framework support

• The bug with throwing System.NullReferenceException when applying logical OR operator to the results of several IEnumerable<T>.Contains(T t) is fixed

5.3.464 30-Jul-15

• Visual Studio 2015 is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.8.11

LinqConnect (formerly known as LINQ to SQLite)

• The bug with CreateAssociationConvention when working with the fluent mapping approach is fixed
• The bug with ManyToManyNamesConvention when working with the fluent mapping approach is fixed

Entity Developer

• The bug with generating namespace for the IsExternal enum is fixed

5.2.457 16-Jul-15

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to the "Object reference not set to an instance of an object" error on SubmitChanges() is fixed

Entity Developer

• The possibility of setting default values for enum properties is implemented (LinqConnect models)
• The bug with freezing Visual Studio when using the Find dialog in large models is fixed

Entity Framework support

• The performance of generating SQL for Enumerable.Contains in LINQ queries is improved by supporting a new expression type, DbInExpression, in Entity Framework 6

5.2.447 02-Jul-15

LinqConnect (formerly known as LINQ to SQLite)

• The bug with materialization of classes with the same names, which are located in the different namespaces or which are the nested classes of the different classes, is fixed
• The bug related to wrong SQL generation when using Count(condition)/ LongCount()/ LongCount(condition) methods in the LINQ query is fixed

5.2.437 18-Jun-15

• The bug with leaving the wal and shm files on closing connection in the WAL journal mode is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The OpenConnection() method is added to the DataContext class
• The bug with not calling the InitializeConnection() method for a newly created connections while performing query or stored procedure is fixed

Entity Framework support

• The bug with loosing elements within the IN clause of the generated SQL for the LINQ Contains clause is fixed

5.2.422 28-May-15

• Visual Studio 2015 Release Candidate is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.8.10.2

Entity Developer

• The bug with detecting the default values of attributes added via the Attributes menu is fixed
• The bug with generating code by MVC Controller template is fixed (Entity Framework models)

5.2.407 07-May-15

LinqConnect (formerly known as LINQ to SQLite)

• 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<TEntity> is used instead of Table<TEntity> is fixed
• The bug with the materialization of UInt32 values greater than Int32.MaxValue is fixed

5.2.397 23-Apr-15

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.9

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Developer

• The support of ID generators for primary keys in the Fluent Mapping template is added (LinqConnect models)

Entity Framework support

• The bug with generating columns in subqueries of a complex LINQ to Entities query containing limit expressions is fixed

5.2.389 09-Apr-15

• The Time member of the SQLiteType enumeration is implemented; the GetValue and GetProviderSpecificValue methods of SQLiteDataReader return TimeSpan for SQLiteType.Time
• The bug with retrieving NUMERIC, FLOAT, REAL values is fixed

Entity Developer

• The bug with ignoring the "Delete Cascaded" property of the association when performing the Update Database From Model and Update Model From Database wizards is fixed (Entity Framework models)

5.2.379 26-Mar-15

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.8.3
• Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
• The performance of the GetSchemaTable method of SQLiteDataReader class is improved
• The behaviour is changed: the GetSchemaTable method of SQLiteDataReader returns information on whether a column is unique only when the command was performed with CommandBehavior.KeyInfo

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Developer

• The behaviour is changed: now the default values are not set for string properties, that correspond to fields with the default values like expressions (Entity Framework models)
• The bug with missing settings for the LazyLoadingEnabled property in the generated code when working with the Self-Tracking Entity template is fixed (Entity Framework models)
• The bug related to working with the Table Per Type (TPT) and abstract entity classes when synchronization is enabled is fixed (Entity Framework models)

Entity Framework support

• The bug with missing sorting in the generated SQL query when working with .OrderBy().Skip().Take() is fixed

5.2.359 26-Feb-15

• The bug with using System.Runtime.CompilerServices.ExtensionAttribute in Devart.Data.Synchronization.dll for the projects with 3.5 and higher versions of .NET Framework is fixed

5.2.352 12-Feb-15

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.8.2
• The \Samples\crm_demo.sql script is updated to avoid generating the "foreign key constraint failed" error
• The bug with incorrect ProviderType, returned by SQLiteDataReader.GetShemaTable() for data of the System.Decimal type, is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to the "Cannot convert the value to GUID: System.Byte[]" error when working with eager loading and GUIDs is fixed

Entity Developer

• The bug with the wrong code generation for Table Per Concrete Type (TPC) hierarchy when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses (or UseOnModelCreatingMethod) options is fixed (Entity Framework models)

5.2.344 02-Feb-15

Entity Developer

• The bug with "Trial period expired" is fixed

5.2.342 29-Jan-15

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.8.1
• The bug in Sync Framework support with synchronization scopes, having a filter based on a template, is fixed
• The bug with using the '-' symbol in the name of a table tracked by Sync Framework is fixed

Entity Developer

• The bug with generating code by the MVC Controller template for multiple self-associations is fixed (Entity Framework models)

5.2.333 15-Jan-15

• The bug with throwing System.InvalidOperationException by connection pooling in multithreaded applications under high loads is fixed

Entity Developer

• The bug with generating connection string supplied to constructor in case of placing the model in a subfolder of the project is fixed (Entity Framework models)

5.2.313 18-Dec-14

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.7.4

5.2.303 04-Dec-14

LinqConnect (formerly known as LINQ to SQLite)

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

Entity Developer

• The bug with the incorrect code generation, when the "Enable WinForms Data Binding" property of the DbContext template (Visual Basic) is set to True, is fixed (Entity Framework models)
• The bug with missing attributes for the enum members when generating code with the DbContext template is fixed (Entity Framework models)

Entity Framework support

• The bug related to working with the customized Migration History table and Entity Framework 6 is fixed

5.2.293 20-Nov-14

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.7.2
• ADO.NET implementation of ASP.NET Identity 2.0 support is improved
• The new IQueryableUserStore interface is implemented in the UserStore class
• The new IQueryableRoleStore interface is implemented in the RoleStore class
• The enableExpiredSessionAutoDeletion and expiredSessionAutoDeletionInterval options for deleting expired sessions are added to the session-state store provider definition in the web.config file
• The behaviour is changed: the SQLiteMonitor now hides information about the password and "SQLiteCrypt License Key" connection string parameters
• The bug with the Turkish locale is fixed
• The bug with the conflict between versions of Devart.Data.SQLite.Web.dll assembly for ASP.NET 2 and ASP.NET 4 is fixed

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 incorrect execution of the "Create Storage and Mapping" command for an association is fixed (Entity Framework models)

5.2.283 06-Nov-14

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.7.1
• The new \Web\ASP.NET 45\Devart.Data.SQLite.Web.dll assembly (its revision number is 5) is added to the provider installation folder to support SimpleMembership in MVC5

Entity Developer

• The bug with reading all constructor parameters for attributes when opening model is fixed
• The bug related to disappearance of the foreign key property when performing "Create Storage and Mapping" from the context menu of the association is fixed (Entity Framework models)
• The bug related to the "'End Class' must be preceded by a matching 'Class'" error when adding stored procedure to the model and using DbContext template in Visual Basic projects is fixed (Entity Framework models)

5.2.274 23-Oct-14

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.7
• The bug with throwing InvalidOperationException if row is added and, then, deleted before next synchronization in Sync Framework support is fixed

5.2.264 09-Oct-14

• The Enterprise Library 6 support is added; all previous versions of Enterprise Library are no longer maintained

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

Entity Framework support

• The int16 / int32 / int64 synonyms of the SMALLINT / INT / INTEGER database types are supported in Entity Data Model Wizard
• The bug with mapping the INT database type by EDM Wizard is fixed

5.2.254 25-Sep-14

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 behaviour is changed: now the default value for the 'File Per Class' option of the DbContext template is True (Entity Framework models)
• The bug with model creation when using multiple naming rules (suffixes, prefixes) is fixed
• The bug with generating .HasPrecision for decimal types when using non-attribute fluent mapping (DbContext template) is fixed (Entity Framework models)

5.2.244 11-Sep-14

• The bug with generating invalid SQL in some scenarios of using Sync Framework feature is fixed

Entity Framework support

• The bug related to the "Index was out of range. Must be non-negative and less than the size of the collection" error when working with SQLiteFunctions.Like(value, pattern) method is fixed

5.2.239 04-Sep-14

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.6
• The bug with invalid script when table has only primary key columns for Sync Framework support is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to the NullReferenceException on SubmitChanges, when working with association between classes involved in complex TPT hierarchy, is fixed

Entity Developer

• The Remove Invalid Characters option (by default, True) is added to the Model Naming rules; if it is set to False, all invalid characters will be replaced with underscores
• The Enable WinForms Data Binding property of the DbContext template is implemented (Entity Framework models)
• The Property Change Partial Methods property of the DbContext template is implemented for generating partial methods On%PropertyName%Changing and On%PropertyName%Changed for each primitive property of entity classes (Entity Framework models)
• The behaviour is changed: now partial configuration classes are generated when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses options (Entity Framework models)
• The bug with the wrong code generation for associations when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseAttributes options is fixed (Entity Framework models)
• The bug with generating DatabaseGeneratedAttribute for non-EntityKey properties when using attribute mapping (DbContext template) is fixed (Entity Framework models)
• The bug with generating DatabaseGeneratedAttribute for all EntityKey properties when using fluent mapping (DbContext template) is fixed (Entity Framework models)
• The bug related to the "An error occurred during an attempt to compile the template 'LinqConnect'." error in Windows Store applications is fixed (LinqConnect models)

5.2.225 14-Aug-14

Entity Developer

• The possibility to use relative paths to assemblies in code generation templates is implemented
• The Implement Equals property is added to the DbContext, ObjectContext, and POCO Entity templates (Entity Framework models)
• The bug related to detecting nullable foreign key as non-nullable is fixed (Entity Framework models)

5.2.215 31-Jul-14

• The RefreshMode and RefreshingFields properties for generating row refresh statements are added to the SQLiteCommandBuilder and SQLiteDataTable classes

Entity Developer

• The bug with a format of generated DataAnnotations.RegularExpression for Numeric validate format is fixed
• The bug with displaying Entity Set in the Class Editor dialog is fixed (Entity Framework models)
• The bug with applying changes after editing the list of the extended properties via the Model Settings dialog is fixed (Entity Framework models)
• The bug with adding references to both EntityFramework.dll and System.Data.Entity.dll assemblies simultaneously by Create Model Wizard, when Entity Framework version is set to Entity Framework 6 in the wizard, is fixed (Entity Framework models)

Entity Framework support

• The bug with generating DDL for creating TPH tables, when the value of discriminator is not set, in the Code-First/Code-First Migrations functionality is fixed
• The bug with applying custom HistoryContext settings is fixed

5.2.201 10-Jul-14

LinqConnect (formerly known as LINQ to SQLite)

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

Entity Developer

• The View Generation option of the model with Entity Framework version = Entity Framework 6 is supported for the DbContext (only with XML mapping), EntityObject, POCO, and Self-Tracking Entities templates (Entity Framework models)
• The bug with "DevartEntityDeploy" task, when .NET Framework 2.0 and .NET Framework 3.5 are not installed on the target workstation, is fixed (Entity Framework models)

5.2.191 26-Jun-14

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.5

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Developer

• The bug with storing custom settings in stored procedure mapping is fixed (Entity Framework models)
• The bug with ordering properties in the .HasKey configuration mapping in case of composite primary key is fixed (Entity Framework models)

5.2.181 12-Jun-14

• ADO.NET implementation of ASP.NET Identity 2.0 support is improved
• The new IUserStore<T>, IUserClaimStore<T>, IUserLoginStore<T>, IUserPasswordStore<T>, IUserRoleStore<T>, IUserEmailStore<T>, IUserPhoneNumberStore<T> interfaces are implemented in the SQLiteUserStore and SQLiteUserStore<TIdentityUser, TIdentityRole> classes
• The new IRoleStore<T> interface is supported in the SQLiteRoleStore and SQLiteRoleStore<TIdentityUser, TIdentityRole> classes

LinqConnect (formerly known as LINQ to SQLite)

• 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 (LinqConnect models)

Entity Framework support

• The bug with throwing System.NullReferenceException when disposing an ObjectResult is fixed
• The bug with performing "Generate Database from Model" wizard when working with Entity Framework 6.1.0 Tools for Visual Studio 2012/Visual Studio 2013 is fixed

5.2.171 29-May-14

• The SQLCipher extension is supported
• The bug with deserialization of a license resource in ASP.NET applications, running with medium or high trust level is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to using properties of the enum data type, that are used in the complex entity key, is fixed

Entity Developer

• The bug related to the opening of the *.edmx files is fixed (Entity Framework models)

Entity Framework support

• The bug related to the inserts (for Identity columns) and updates (for Computed columns) when working with unquoted columns and when config.Workarounds.DisableQuoting is set to True is fixed
• The bug with throwing the "Unexpected query batch command" exception when using the Batch Updates functionality is fixed
• The bug with generating extra condition for limiting subselect by one record in generated subqueries with grouping is fixed

5.2.161 15-May-14

• SQLiteUtils class is added
• The SQLiteScript.Cancel() method is added to stop query execution

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to reading values of the string properties, that are database generated, when performing SubmitChanges() is fixed

Entity Developer

• The bug related to performing queries via Query Editor/Retrieve Data when working with the 'Enterprise Library' validation framework is fixed
• 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 (LinqConnect models)

Entity Framework support

• The behaviour is changed: now a semicolon (;) after the very last statement is generated in the Code-First CreateDatabaseScript() functionality

5.2.146 24-Apr-14

• The ADO.NET implementation of ASP.NET Identity 2.0 support is added
• The new \Web\ASP.NET Identity 2\Devart.Data.SQLite.Web.Identity.dll assembly (its revision number is 2) is added to the provider installation folder
• The new \Web\ASP.NET Identity 2\Install_identity_tables.sql and \Web\ASP.NET Identity 2\Uninstall_identity_tables.sql files are added to the provider installation folder
• The new \Web\ASP.NET Identity 2\Upgrade_identity_tables_from_v1_to_v2.sql file is added to the provider installation folder
• The new IUserEmailStore, IUserPhoneNumberStore, IUserTwoFactorStore, IUserLockoutStore interfaces are implemented in the UserStore class
• The bug with 'Load Test Editor' is fixed
• The bug with the SQLiteDateTime.ToString() method is fixed
• The bug with reading datetime with timezone is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to wrong order of the insert/delete operations on SubmitChanges when the autogenerated primary keys are used is fixed

Entity Developer

• The behaviour is changed: now a property in the generated code is initialized basing on the default value in CSDL only (instead of default values in any of SSDL and CSDL; Entity Framework models)
• The bug related to the incorrect value setting for the "Has Stream" property when working with the WCF Data Services projects is fixed (Entity Framework models)

Entity Framework support

• The database server version is added to the generated Code-First Migrations script
• The datetimeoffset pseudo type of SSDL, which corresponds to System.DateTimeOffset, is implemented
• The bug related to the "Constructor on type 'System.Data.Entity.Migrations.History.HistoryContext' not found." error in Code-First Migrations after upgrading Entity Framework from 5 to 6 is fixed
• The bug with the explicitly named primary keys in Code-First Migrations, when the primary key is defined via the PrimaryKey() method of the CreateTable() operation, is fixed
• The bug with generating SQL for EntitySQL ANYELEMENT is fixed

5.2.135 10-Apr-14

• The ADO.NET implementation of ASP.NET Identity support is improved
• The ICloneable interface is implemented in the IdentityUser and IdentityRole classes
• The User_Id column in the AspNetUserClaims table is renamed to UserId
• The sqlite3.dll library that is included into the installation package is updated to version 3.8.4.3

Entity Framework support

• The UpdateDatabaseOperation operation in Code-First Migrations for Entity Framework 6.x is supported
• Multiple EntityContainers in the Code-First CreateDatabase()/CreateDatabaseScript()/DeleteDatabase() functionality are supported
• The Database.Delete(DbConnection) functionality is supported: all objects in the database are removed if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects
• The Database.Exists(DbConnection) functionality is supported: the method returns true if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects and at least one table exists in the current database
• Determining correct datatypes of data retrieved by EntitySQL queries with UNION ALL and similar constructions is improved
• The compatibility with Hibernating Rhinos EntityFramework Profiler is improved

5.2.125 27-Mar-14

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.4.1

LinqConnect (formerly known as LINQ to SQLite)

• 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 override modifier for DbSet class properties generated by DbContext templates is added (Entity Framework models)
• The bug with setting nullable type for EnumType property by the Data Transfer Object template is fixed

Entity Framework support

• Entity Framework 6.1.0 RTM is supported
• Entity Framework 6.1.0 Tools for Visual Studio 2012 & 2013 are supported
• The releasing of memory, which was allocated for commands and readers of ObjectContext / DbContext, is improved

5.2.115 06-Mar-14

• The ADO.NET implementation of ASP.NET Identity support is added

LinqConnect (formerly known as LINQ to SQLite)

• The CommandTimeout property is added to the DataProvider class
• 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

Entity Developer

• The information message about availability of NuGet Package Manager on the workstation is added in the Entity Developer version integrated into Visual Studio (Entity Framework models)
• 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 (LinqConnect models)
• The bug with generating the entities namespace in fluent mapping configuration classes is fixed (Entity Framework models)
• The bug with generating DatabaseGeneratedOption.Computed for non-EntityKey properties in fluent mapping is fixed (Entity Framework models)

Entity Framework support

• The bug with generating INSERT statement for the class with a single Identity property is fixed

5.1.103 18-Feb-14

• The bug with parsing the SQLiteScript.ScriptText property on .NET Framework 4.5 is fixed

Entity Developer

• More information messages, when validating EF6 models basing on the EntityFramework.dll functionality, are added (Entity Framework models)
• The bug with using Create Model Wizard for EF6 models is fixed (Entity Framework models)

5.1.100 13-Feb-14

LinqConnect (formerly known as LINQ to SQLite)

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

Entity Developer

• The "WCF DataMember Attribute on Navigation Properties" property is added to the Data Transfer Object template for pointing the end (-s) where the attribute should be generated (Entity Framework models)
• The behaviour is changed: the validation of EF6 models depends on the EntityFramework.dll functionality only (.NET Framework 4.5 is not required any more) (Entity Framework models)
• 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 (LinqConnect models)
• The bug with parsing inheritances in *.edmx is fixed (Entity Framework models)

Entity Framework support

• The bug with "Update Model From Database wizard" in Entity Framework 6 Tools for Visual Studio 2012 and Visual Studio 2013 is fixed

5.1.90 30-Jan-14

• The behaviour is changed: IndexOutOfRangeException is generated now instead of InvalidOperationException when SQLiteDataReader.GetOrdinal(String name) finds nothing in the result set

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Framework support

• The bug with generating IndexOutOfRangeException by the ObjectContext.ExecuteStoreQuery method when the result set of the SQL query does not include any mapped column of the entity being materialized is fixed
• The bug with creating indices for foreign key columns, when two tables are referenced by two or more FKs, in Code-First functionality is fixed

5.1.80 16-Jan-14

• The sqlite3.dll library that is included into the installation package is updated to version 3.8.2

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 (LinqConnect models)
• The bug with creating models for Entity Framework 6 on the workstation without .NET Framework 4.5 installed is fixed (Entity Framework models)
• The bug with association mapping in the DbContext template is fixed (Entity Framework models)
• The bug with composite keys mapping in the DbContext template is fixed (Entity Framework models)

Entity Framework support

• The bug with changing the MigrationHistory table when migrating from EF4/EF5 to EF6, when config.Workarounds.DisableQuoting = True, is fixed

5.1.65 26-Dec-13

• The bug with retrieving views in Business Intelligence Solutions projects is fixed

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Developer

• The predefined templates (POCO Entity and LinqConnect) are improved: new template setting, "Generate Dummy Comments", is added (LinqConnect models)
• The bug related to detecting unique keys is fixed (LinqConnect models)
• The bug related to the "Custom tool error: Unknown namespace or alias (NamespaceName.NamespaceName)" error when setting return type of the method to complex type is fixed (Entity Framework models)

Entity Framework support

• The behaviour is changed: Code-First Migrations generates DEFAULT values for new NOT NULL columns of Boolean, Guid, DateTime types when adding them in the existing table

5.1.55 12-Dec-13

• The "Native Library Pre-Loading" feature is implemented
• The bug related to the "Connection must be opened" error is fixed

LinqConnect (formerly known as LINQ to SQLite)

• 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

5.1.45 28-Nov-13

• The behaviour is changed: now a transaction rollbacks on Connection.Close() if Transaction.Commit() was not called before closing the connection
• The bug with disabling some properties in Devart components in Visual Studio Express is fixed
• The bug with calling the RowUpdating event of SQLiteDataTable and SQLiteDataAdapter classes when no data is changed is fixed
• The bug with installing provider assemblies for the x64 version of SQL Server Integration Services is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The possibility to inherit from the data provider classes is added

Entity Developer

• The new "Provider Manifest Token" model property is implemented to identify the target server (Entity Framework models)
• 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

Entity Framework support

• The AddForeignKey constraint operation for one-column FK is supported in Code-First Migrations for the case when a new column for FK is created
• The compatibility of Entity Framework provider for EF v1, v4, v5 with medium trust level environment is improved
• The behaviour is changed: a more detailed error message is shown ("OUTER APPLY is not supported by SQLite") in case when the generated SQL contains OUTER APPLY
• The bug related to the NRE on the CreateDatabaseScript() method, when the Code-First model is not configured completely, is fixed

5.1.36 14-Nov-13

• The bug with a serialization of SQLiteException is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with comparison (AND/OR) of dates with another comparison results or boolean expressions is fixed

5.1.26 31-Oct-13

• Visual Studio 2013 is supported
• The behaviour is changed: installation with the /VERYSILENT install parameter will uninstall the other version of the provider without any dialog box if it is installed
• The bug with using ExtendedMembership provider in a multithreaded application is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with the date comparison is fixed

Entity Developer

• Entity Framework 6 is supported
• The bug with IntelliSense when working with T4 Editor in Visual Studio 2012 is fixed

Entity Framework support

• The 6.0.0 and 6.0.1 versions of Entity Framework are supported
• The behaviour is changed: Entity Data Model Wizard shows a more detailed error message in case of connecting to unsupported database or using incorrect provider manifest tokens

5.0.17 17-Oct-13

• Microsoft Sync Framework support is implemented
• The BackupDatabase method that backs up (copies) of SQLite databases is added to the SQLiteConnection class

LinqConnect (formerly known as LINQ to SQLite)

• The Collate method of the SqlMethods class is implemented
• 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

Entity Developer

• The predefined templates are improved: new template setting, "Use Compiled Query Cache", is added (LinqConnect models)
• The bug with "DevartEntityDeploy" task, which generates mapping files, in Visual Studio 2013 Release Candidate is fixed

Entity Framework support

• The behaviour is changed: Code-First Migrations generates DEFAULT 0 for new NOT NULL columns of numeric types when adding them in the existing table
• The behaviour is changed: Code-First Migrations generates DEFAULT '' for new NOT NULL columns of string types when adding them in the existing table

4.6.333 23-Sep-13

• Visual Studio 2013 Release Candidate is supported
• The BackupDatabase method of the SQLiteConnection class is implemented
• The bug with not checking SQLiteCrypt password when a connection is taken from the pool is fixed

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
• The bug with creating complex primary keys when creating a model from a database is fixed

4.6.322 05-Sep-13

• The SQLiteCryptLicenseKey connection string parameter is added to support SQLiteCrypt API
• The bug with SQLiteCrypt API support is fixed
• The bug with an error occurring during opening a connection, and then this connection getting into the pool is fixed
• The bug with the Caption property of the DataGridView column with the Devart DataTable component is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The possibility to use the extension method AsQueryable() in LINQ queries is added
• The support for correct retrieving of the TimeSpan and DateTimeOffset values while materializing is added
• The bug with eager loading is fixed
• The bug with the redundant opened sessions is fixed
• The bug with missing CreateCommand method in the DataProvider class is fixed
• The bug related to the ArgumentNullException on SubmitChanges method when trying to update a row with the same values is fixed

Entity Developer

• The "Close the window when the generation completes successfully" option in the Generation Process window is implemented in the standalone Entity Developer
• The "Rewrite connection string during regeneration" option (default value is True) of model settings is added to provide the possibility to turn off modifying connection string in *.config after model is saved first time (Entity Framework models)
• The design time support for model-defined functions is added (Entity Framework models)
• The behaviour is changed: now connection string is configured with the name of the assembly, where the model is located, in case when the context class is located in another assembly (Entity Framework models)
• The bug with the Retrieve Data functionality of the model with the DbContext template, when its Fluent Mapping property is set to True, is fixed (Entity Framework models)
• The bug related to the detection of Table Per Type inheritances as Table Per Concrete Type inheritances when opening an existing model is fixed (Entity Framework models)
• The bug with parsing *.edmx is fixed (Entity Framework models)
• The bug with generating "An item with the same key has already been added" error when using DbContext Template is fixed (Entity Framework models)
• The bug with DbContext template, when its MappingGenerationStrategy is set to UseConfigurationClasses, generating fluent mapping for an association with turned off generation of one navigation property is fixed (Entity Framework models)
• The bug with availability of the New Blank Template option of the Templates context menu in Model Explorer in the Entity Developer version integrated into Visual Studio is fixed
• The bug with generating invalid code when using MVC View Advanced template is fixed

Entity Framework support

• Entity Framework 6 Release Candidate 1 is supported

4.6.301 08-Aug-13

• The sqlite3.dll library that is included into the installation package is updated to version 3.7.17
• The support of asynchronous backing up and restoring for SQLiteDump is implemented
• The bug with compatibility of Devart.Data.SQLite.Web.dll for .NET Framework 2 and 4 in Visual Studio 2010, that is automatically added to the project when adding the SQLiteDataSource component to the web form, is fixed

Entity Developer

• The "Model Name As Files Prefix" property is implemented for the templates which generate classes for model entities
• The possibility of adding custom attributes to enum members is implemented
• The behaviour is changed: the possibility to exclude the generation of keys (primary, foreign) in "Update Database From Model" and "Generate Database Script From Model " wizards is added
• The behaviour is changed: the possibility to add one-to-one associations with nullable foreign key properties is added (LinqConnect models)
• The behaviour is changed: now by default MVC Controller template generates files in the model folder, MVC View Advanced template creates files in the Views model subfolder
• The bug with breaking the parameters order in Generator Parameters Editor is fixed (LinqConnect models)
• The bug with an error during a compilation of the 'LinqConnect' template for VB.NET projects in Visual Studio 2008 is fixed (LinqConnect models)
• The bug with breaking the IdGenerator configuration after closing the model is fixed (LinqConnect models)
• The bug with generating code by Self-Tracking Entity template is fixed (Entity Framework models)
• The bug with parsing *.edmx is fixed

4.6.287 18-Jul-13

• SQL Server 2012 Reporting Services is supported

LinqConnect (formerly known as LINQ to SQLite)

• 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 parsing *.edmx is fixed (Entity Framework models)

Entity Framework support

• The config.Workarounds.UseInvariantProviderManifestToken configuration option (default value is False) is added to provide the possibility of returning the invariant string literal as the provider manifest token
• The config.SqlFormatting.Identation option is renamed to config.SqlFormatting.Indenting
• The bug with using delimiter when generating Code-First Migrations script via the ScriptUpdate method of the MigratorScriptingDecorator class in Entity Framework 6 is fixed

4.6.276 03-Jul-13

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to working with decimal datatypes is fixed

Entity Developer

• The "Regenerate Storage and Mapping" option for regenerating model parts, specific to the database server, is added to the diagram shortcut menu
• Storage Entity Editor is improved: the capability to edit extended columns settings, such as facets, is added (Entity Framework models)
• The bug with adding a new property to the base abstract class in Table Per Hierarchy inheritance is fixed (Entity Framework models)

Entity Framework support

• The bug with a workability of configuration options set in the application config file when using Code-First Migrations via Package Manager Console of Visual Studio is fixed

4.6.267 20-Jun-13

• The bug with the SQLiteDataSource component in design time is fixed
• The bug related to working with one database file (inserting, updating) simultaneously from several processes is fixed
• The bug with generating typed Devart DataSet using a connection from *.config in the Visual Basic project is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The performance when working with the TPT-inheritance and retrieving descendants via OfType<> is improved
• The bug with the CreateDatabase() method when "Delete Rule" is set for the association (not empty and not "NO ACTION") is fixed
• The bug related to the "The non-nullable navigation property '...' was set to null in the entity object '...'" error when working with nullable composite foreign keys is fixed
• The bug related to working with the WCF Ria Domain Service template is fixed
• The bug with the TPT-inheritance and associations to the descendants of the inheritance is fixed
• The bug related to the "Violation of PRIMARY KEY constraint" error on SubmitChanges(), when DataContext has only one added entity for insertion with a custom key generator and DbGenerated=False for its primary key, is fixed

Entity Developer

• The behaviour is changed: DatabaseGeneratedOption is always generated for EntityKey properties when using fluent mapping (Entity Framework models)
• The bug with wrong code generation for nullable enum properties is fixed
• The bug with generating "Access Denied" error when using MVC templates is fixed
• The bug with a serialization of stored procedures mapping to CUD operations in an association is fixed (Entity Framework models)
• The bug with ordering parameters of a method when Update From Database Wizard adds/removes parameters to the method signature is fixed (Entity Framework models)
• The bug with parsing *.edmx which includes an association, which has different values in a navigation property name and a role at the same end, is fixed (Entity Framework models)

Entity Framework support

• The config.DatabaseScript.ForeignKey.Enabled option (default value is True) is added to turn on/off generation of foreign key constraints

4.6.257 06-Jun-13

• The bug with throwing an exception during installation when the DbProviderFactories section is missing in the machine.config file is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with the nullable properties in composite foreign keys is fixed
• The bug related to the MissingMethodException error is fixed

Entity Developer

• Devart.Data.Linq.Binary type is added to the "Type Mapping Rule Editor" (LinqConnect models)
• The behaviour is changed: auto-implemented properties are generated when DbContext template is used with ImplementINotifyPropertyChanged=False and ImplementINotifyPropertyChanging=False (Entity Framework models)
• The bug with referencing a custom assembly in T4 template is fixed
• The bug with a synchronization when adding new properties to the base abstract class in Table Per Hierarchy inheritance is fixed (Entity Framework models)
• The bug with parsing *.edmx which includes the class with a self-association is fixed (Entity Framework models)
• The bug with retrieving an association mapping when opening *.edmx is fixed (Entity Framework models)

Entity Framework support

• Entity Framework 6 Beta 1 is supported
• The bug using Batch Updates in a multithreaded application is fixed
• The bug with creating CHARACTER / VARCHAR datatypes without specified max length using CreateDatabase()/Code-First approach is fixed

4.6.252 30-May-13

• The bug with WebSecurity.Login() used with wrong credentials is fixed

LinqConnect (formerly known as LINQ to SQLite)

• 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 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
• The bug with adding many-to-many associations when one of the sides of the association is involved in the inheritance is fixed (LinqConnect)

4.6.242 16-May-13

• The LoadExtension connection string parameter is implemented to load sqlite extension(s) right after opening a connection
• The LoadExtension method of the SQLiteConnection object is implemented to load sqlite extension
• The bug with the exception thrown by the DataTable.Load method is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The possibility to disable query cache via the DataContext's 'EntityCachingMode' property is added
• The bug with inheriting an entity class from an unmapped type is fixed
• The bug related to the 'Index was outside of the bounds of the array' error when using GroupBy in queries is fixed
• The bug with the materializer cache and AssociateWith method is fixed
• The bug with the CreatedDatabase() method for many-to-many associations is fixed
• The bug with AddDays() method with negative parameters is fixed
• The bug with inserting record with composite primary key is fixed

Entity Developer

• The Save and Refresh buttons for persisting and reloading changes to / from a database is added to the Retrieve Data grid
• POCO Entity template is improved: new template setting, "Property Change Notifiers", is added (LinqConnect models)
• The behaviour is changed: a string default value for the property can be set without quotes in the Properties window
• The behaviour is changed: the validation error is not generated when an abstract class is used in Table Per Type inheritance (Entity Framework models)
• The bug with wrong detecting many-to-many associations is fixed (LinqConnect models)
• The bug with mapping nested complex data types in the MSL part of the model in the synchronization mode is fixed (Entity Framework models)

4.6.226 23-Apr-13

• Compatible with other dotConnect providers

4.6.224 18-Apr-13

• The support of the URI format for the connection string is implemented
• The behaviour is changed: provider's build action is installed on the target workstation, on which .NET Framework is available, without Visual Studio integration
• The bug with performance of the SQLiteDataReader.GetGuid() method is fixed

LinqConnect (formerly known as LINQ to SQLite)

• 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 loading mapping rules for some datatypes under .NET Framework 4.5 is fixed
• The bug with wrong database script generation for tables with several many-to-many associations is fixed (LinqConnect models)

4.6.217 04-Apr-13

• The bug with defining delete statement in SqlStatementExecute event handler is fixed

LinqConnect (formerly known as LINQ to SQLite)

• LINQPad integration is supported
• The behaviour is changed: now batch updates are disabled by default
• The bug related to the NullReferenceException on SubmitChanges() method when working with isVersion properties is fixed

Entity Developer

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

4.5.202 14-Mar-13

• The behaviour is changed: when an SQLiteDateTime object with the IsDate property set to true is passed as a SQLiteParameter value, the actual value passed to the database has the Date format
• The behaviour is changed: fractional seconds precision is increased to 6 when working with the datetime type

LinqConnect (formerly known as LINQ to SQLite)

• 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 (LinqConnect models)

Entity Framework support

• Entity Framework 6 Alpha 3 is supported

4.5.192 28-Feb-13

• ExtendedMembership (SimpleMembership) provider support is added
• The bug with filling DataTable from table containing columns with default NULL is fixed

Entity Developer

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

4.4.179 07-Feb-13

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Developer

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

4.4.164 17-Jan-13

• The sqlite3.dll library that is included into the installation package is updated to version 3.7.15
• The bug with the "Unknown IDE" exception in Visual Studio Express 2012 for Windows Desktop is fixed

Entity Developer

• The bug with duplicate entries in the Base Class Condition and Derived Class Condition dropdowns of Inheritance Editor is fixed (Entity Framework models)

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to the "Cannot convert from 'string' to 'Devart.Data.Linq.Mapping.DeleteRule' " error when working with Fluent mapping is fixed

Entity Framework support

• Entity Framework 6 Alpha 2 is supported
• Devart.Data.SQLite.Entity.dll assembly compiled with EntityFramework.dll 6.0 and NET Framework 4.0 is added

4.3.146 20-Dec-12

• The bug with the OverflowException under Windows 8 is fixed
• The bug, that occurred when editing an existing Dataset in DataSet Wizard and which was associated with incorrect processing of 'Select command text' for Data tables having DataSource set to TableAdapter, is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug related to the "Object does not match target type" exception when working with DbLinqDataSources and gridviews is fixed
• The bug with the implicitly converting strings to integer type in queries when working with VB.NET projects is fixed
• The bug related to the "Unsupported delete rule 'NO ACTION'" exception when creating DataContext is fixed
• The bug with update commands for dependent entities that participate in Table Per Type inheritance is fixed

Entity Developer

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

4.2.132 29-Nov-12

• Visual Studio 2005 support is discontinued
• The sqlite3.dll library that is included into the installation package is updated to version 3.7.14

LinqConnect (formerly known as LINQ to SQLite)

• The fluent mapping is improved: support of the ID generators for primary keys is added
• 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 possibility to set different namespaces for the context and its entities when using the DbContext template is implemented (Entity Framework models)
• The bug with generating the using directives for redundant namespaces is fixed (Entity Framework models)
• The bug with renaming the navigation property when using the Update Model From Database wizard is fixed (LinqConnect models)

4.2.122 15-Nov-12

LinqConnect (formerly known as LINQ to SQLite)

• The bugs with using LinqConnect for Dynamic Data projects under .NET Framework 4.0 or higher are fixed

4.2.114 01-Nov-12

• The Read-Only connection string parameter is implemented for establishing a connection in the read-only mode

Entity Developer

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

Entity Framework support

• The bug with removing column in the MigrationHistory table when upgrading from EF v4.3 to EF v5.0 is fixed
• The bug with inserting DateTime values in the CreatedOn column of the MigrationHistory table for EF 4.3 is fixed
• The bug with the SQL generation of constant DateTime values is fixed

4.2.104 18-Oct-12

• The bug with the SQLiteScript.CommandTimeout property not changing its value when setting the DefaultCommandTimeout parameter of the connection string is fixed
• The bug with the new line character in the connection string is fixed

LinqConnect (formerly known as LINQ to SQLite)

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

Entity Framework support

• The bug with DropDatabase() and CreateDatabase(), when DeleteDatabaseBehaviour.ModelObjectsOnly is used, in EF v4.3 and higher is fixed

4.2.96 04-Oct-12

• The bug with deploying Analysis Services Project when using the x64 version of SQL Server Analysis Service is fixed

LinqConnect (formerly known as LINQ to SQLite)

• 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

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 for LinqConnect models in the standalone version Entity Developer (the entry in App.Config must be added manually afterwards)
• The bug with incorrect properties of the composite key is fixed

Entity Framework support

• The bug with setting configuration options via the application config file is fixed
• The bug with setting the configuration options for Entity Framework v1 is fixed

4.2.77 06-Sep-12

• Visual Studio 2012 is supported
• The bug with returning 0 instead of -1 for all statements except UPDATE, DELETE, INSERT statements is fixed

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Developer

• Support for ADO.NET Entity Framework 5 is added
• The 'Entity Base' class property, which allows specifying the ancestor class/interface for a particular entity type, is implemented (LinqConnect models)
• The behaviour is changed: only particular (not all) property characteristics are regenerated when using Update Model From Database wizard after the metadata of the corresponding column have been changed (LinqConnect models)
• The bug with reading the Time data type when deserializing the storage part of the model is fixed (Entity Framework models)

Entity Framework support

• ADO.NET Entity Framework 5 is supported
• The behaviour is changed: Devart.Data.SQLite.Entity.Migrations.dll is built with the 4.4 version of EntityFramework.dll now
• The bug with using command delimiters when generating the Code-First Migrations script in Package Manager Console of Visual Studio is fixed

4.1.58 09-Aug-12

LinqConnect (formerly known as LINQ to SQLite)

• 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

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

Entity Framework support

• The config.QueryOptions.UseCSharpNullComparisonBehavior configuration option for checking for NULL when comparing a nullable property (column) or an expression with a variable (parameter) in LINQ to Entities is implemented (by default, false)

4.1.40 17-Jul-12

• The sqlite3.dll library, supplied with the provider, includes full-text search support (the FTS3 and FTS4 modules)
• The sqlite3.dll library that is included into the installation package is updated to version 3.7.13

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Developer

• The behaviour is changed: the warning, related to the missing property setter, is disabled (LinqConnect models)
• The behaviour is changed: for the association, in which the many-side entity hasn't the primary key, the code and the mapping are not generated (LinqConnect models)
• The behaviour is changed: the properties, that correspond autoincrement fields, are generated with a ReadOnly keyword in VB.NET (LinqConnect models)

Entity Framework support

• The support of Entity Data Model Wizard (Database-First) in Visual Studio 2008 SP1/2010/2010 SP1/11 Beta/2012 RC is implemented
• The support of Generate Database Wizard (Model-First) in Visual Studio 2010/2010 SP1/11 Beta/2012 RC is implemented
• The support of Visual Studio LightSwitch 2011 (v1) and LightSwitch in Visual Studio 11 Beta/2012 RC (v2) is implemented
• The support of the SQLite full-text search functionality is implemented
• The SQLiteTextFunctions class for working with full-text search functions in LINQ to Entities is added
• The SQLiteCreateTableConfiguration class for customizing the CreateTable operation (creating full-text search table) in Code-First Migrations is added
• Creating indexes for FK columns in Code-First CreateDatabase functionality is implemented
• The config.DatabaseScript.ForeignKey.IndexCreation configuration option is added (default value is True)
• The possibility of setting configuration options via the application config file is implemented
• The Devart.Data.SQLite.Entity.xsd file is added to the installation in order to simplify setting and validating the application config file settings when using the XML Editor
• Code-First Migrations now supports specifying which schema (database) a table belongs to
• The config.Workarounds.IgnoreDboSchemaName configuration option is added. The option is automatically set to True, if Code-First (Migrations) EF v4.x/5.x is used
• CASE generation is improved
• The behaviour is changed: in case of using Code-First (Migrations) EF v4.x/5.x the schema name 'dbo' will be ignored by default

4.0.25 21-Jun-12

• The bug with locking the database file after a database exception occurs is fixed

LinqConnect (formerly known as LINQ to SQLite)

• 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 (LinqConnect models)
• The bug with copy/pasting entities having a common relation is fixed
• The bug with generating redundant column in SSDL when setting one-to-one association in the designer is fixed (Entity Framework models)
• The bug with generating the MSL mapping for one-to-one association is fixed (Entity Framework models)
• The bug with the displaying many-to-many associations in the Association Editor is fixed (LinqConnect models)
• The bug with specifying the custom tool for LinqConnect models being added to web sites is fixed (LinqConnect models)
• The bug with mapping generation for associations with the 'Delete On Null' rule enabled is fixed (LinqConnect models)
• The bug with mapping generation for entity types having multiple complex types is fixed (LinqConnect models)

Entity Framework support

• The bug with filtering on the DateTime column in LINQ to Entities queries is fixed

4.0.17 07-Jun-12

• Visual Studio 2012 Release Candidate is supported
• The Initialization Command connection string parameter is implemented
• The behaviour is changed: the 'sender' parameter in MonitorEventHandler is a connection and the MonitorEventArgs.ExtraInfo property is filled with the connection string

LinqConnect (formerly known as LINQ to SQLite)

• 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

Entity Developer

• The bug with the failure to read the complex type's Access property value is fixed (Entity Framework models)
• The bug with saving *.edml when importing data from *.edmx is fixed (Entity Framework models)

Entity Framework support

• The config.CodeFirstOptions.RemoveSchemaFromDefaultConstraintName option for removing schema name from the default constraint name is implemented in Code-First Migrations (by default, true)
• The config.CodeFirstOptions.AddTableNameInDefaultIndexName option for adding a table name to the default index name is implemented in Code-First Migrations (by default, true)
• The bug with quoting indexes in Code-First Migrations is fixed
• The bug with HistoryTable in Code-First Migrations when using the DisableQuoting option is fixed
• The bug with adding a schema prefix to default constraint name (PK and FK) in Code-First Migrations is fixed

4.0.6 22-May-12

• The RegisterProgressHandler and UnRegisterProgressHandler methods are added to the SQLiteConnection class
• The behaviour is changed: the access modifier of the connectionString field of web provider classes is changed from private to protected

LinqConnect (formerly known as LINQ to SQLite)

• 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 support for Ticks-based DateTime columns is added (Entity Framework models)
• The behaviour is changed: context menu commands for working with diagram are grouped to the Diagram submenu of the context menu
• The behaviour is changed: the possibility to change diagram shape color via the corresponding Shape -> Color context menu command is added
• The behaviour is changed: when pasting a copied entity to a new diagram, a new entity is not created, the existing entity is added to this diagram
• The behaviour is changed: when cutting an entity from the diagram, the entity is not cut from the model, only from the diagram
• The behaviour is changed: "Update Model From Database" wizard places newly added properties to the base abstract class now instead of putting them into child classes where the mapping is (Entity Framework models)
• The behaviour is changed: the CSDL property is left unchanged when the corresponding SSDL property is regenerated (Entity Framework models)
• The behaviour is changed: the association names are generated basing on the database FK names when using Database First approach (Entity Framework models)
• The bug with reading one-to-many associations from the *.edmx file is fixed (Entity Framework models)
• The bug with "DevartEntityDeploy" task when only .NET Framework 4 is installed is fixed (Entity Framework models)
• The bug with closing connection in the generated method of the context is fixed (Entity Framework models)
• The bug with generating code using DbContext template, when template's Fluent Mapping property is set to True and one of the navigation properties of an association is turned off, is fixed (Entity Framework models)
• The bug with incorrect saving of method's extended properties is fixed (LinqConnect models)

Entity Framework support

• Entity Framework 5.0 Release Candidate is supported
• The support for Ticks-based DateTime columns is added
• The bug with fractional seconds rounding in INSERT command is fixed

3.80.350 26-Apr-12

Entity Developer

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

3.80.341 12-Apr-12

• The sqlite3.dll library that is included into the installation package is updated to version 3.7.11

LinqConnect (formerly known as LINQ to SQLite)

• The bug with the performance issues when generating complex queries is fixed

Entity Developer

• The behaviour is changed: the Migrate option is added to the context menu of property in Model Explorer
• The behaviour is changed: entities and enums on the designer surface are more resizable now
• The bug with creating LinqConnect models is fixed
• The bug with detecting many-to-many associations is fixed (Entity Framework models)

3.80.332 29-Mar-12

• The handling of empty options in the connection string is improved
• The bug with parsing SQLiteScript.ScriptText under Mono is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with the generation of SQL queries including grouping by the whole entity is fixed

Entity Developer

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

Entity Framework support

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

3.80.325 15-Mar-12

• Visual Studio 11 Beta is supported
• The sqlite3.dll library that is included into the installation package is updated to version 3.7.10

LinqConnect (formerly known as LINQ to SQLite)

• 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 setting StoreGeneratedPattern to Identity for foreign key property of the child class when creating an association is fixed (Entity Framework models)
• The bug with generating mappings for many-to-many association of entity to itself is fixed

Entity Framework support

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

3.70.311 27-Feb-12

LinqConnect (formerly known as LINQ to SQLite)

• The bug with reading GUIDs from SQLite databases is fixed

Entity Developer

• The context menu options for unchecking changed/added/dropped tables are implemented for the root nodes in the "Update To/From Database" wizards
• The possibility to rename the storage part of the model in Model Explorer is implemented (Entity Framework models)
• The diagram design is changed: an arrow (instead of a triangle) is used on the tip of an association now
• The bug with setting comments for columns and tables in database is fixed

Entity Framework support

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

3.70.302 09-Feb-12

Entity Developer

• 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

3.70.293 27-Jan-12

• The Guid value is added to the SQLiteType enum

LinqConnect (formerly known as LINQ to SQLite)

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

Entity Framework support

• Entity Framework 4.3 Beta 1 (Code First Migrations) is supported
• The bug with generating Primary Key in DDL for the Entity Key columns when using Generate Database Script From Model is fixed
• The bug with Guid parameters representation depending on the BinaryGUID connection string parameter's value is fixed

3.60.283 12-Jan-12

• The possibility of working with Temporary Database files by setting empty DataSource in the ConnectionString is implemented
• The SQLiteConnection.ClearAllPools(bool force) method is added
• The bug with reading a single character (via the SQLiteDataReader.GetChar method) is fixed

Entity Developer

• The documentation generation for Enum members is implemented
• The "Detect function-based column default value" option for automatic setting StoreGeneratedPattern to Identity for corresponding columns is implemented for Entity Framework models (by default, false)
• The algorithm for forming the Navigation Properties names, when there are several FOREIGN KEY constraints between the same tables, is changed
• The behaviour is changed: the Navigation Property will not be displayed on the diagram and in Model Explorer if "Generate" is set to false for the appropriate association end
• The behaviour is changed: the Validate Max Length attribute is synchronized with the Max Length attribute of Property by default now
• The behaviour is changed: the Validate Required attribute is synchronized with the Nullable attribute of Property by default now
• The behaviour is changed: when selecting a property in the Model Explorer, the corresponding entity on the diagram does not expand if it is collapsed
• The bug with adding diagrams when the Notation parameter of the diagram "Property Details Level" is set to "Name And Type" is fixed
• The bug with changing the Type property simultaneously for several inheritances is fixed
• The bug with invalid Properties grid data refreshing for the selected attribute in the Attributes dialog box is fixed
• The bug with formatting indents when generating code is fixed
• The bug with saving inheritance layout on the diagram is fixed
• The bug with incorrect model diagram saving after deleting a complex type from a diagram is fixed
• The bug when the names of constraints in the Store part of the model are not taken into account by Generate Database Script From Model wizard is fixed (Entity Framework models)
• The bug with Retrieve Data when using DbContext template is fixed (Entity Framework models)
• The bug with Table Per Hierarchy (TPH) when using abstract intermediate class between the base and derived classes is fixed (Entity Framework models)

Entity Framework support

• The generation of SQL-literals for byte array is supported
• The generation of SQL-literals for DateTime with fractional part of seconds is improved
• The generation of System.Byte columns in Entity Framework Code-First CreateDatabase is supported
• The bug with using slashes in string parameters of the .Contains method is fixed

3.60.268 22-Dec-11

• The bug with DbException.ErrorCode that was not set in SQLiteException is fixed
• The bug with setting the PrimaryKey attribute of DataTable.Constraints when editing an existing DataSet using DataSet Wizard is fixed

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

Entity Framework support

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

3.60.258 08-Dec-11

LinqConnect (formerly known as LINQ to SQLite)

• 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 '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 HasStream attribute of entity types, used retrieve binary data as a stream via Open Data Protocol, is supported (Entity Framework models)
• The bug with code generation for foreign key fields in Entity Framework models with fluent mapping is fixed
• The bug with code generation for default values of DateTime fields is fixed (LinqConnect models)
• The bug with 'losing' additional diagrams when re-opening a model is fixed

Entity Framework support

• The behavior of the Database.Delete code-first method is changed: the constraints are now disabled when database objects are deleted
• The config.QueryOptions.NoEscapeLike option is implemented to manage LIKE behaviour when using Linq to Entities extention methods .Contains() .EndsWith() .StartsWith()
• The bug with generating AUTOINCREMENT in DDL for key columns when using Identity in Code First is fixed
• The bug with generating ON DELETE CASCADE in SQL when using Code First is fixed

3.50.250 24-Nov-11

Entity Developer

• The bug related to Visual Studio crashes at query execution is fixed
• The bug with removing associations when updating the model is fixed

Entity Framework support

• The size of generated SQL is reduced by excluding redundant aliases

3.50.244 11-Nov-11

• The bug with returning invalid connections to pool is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with updating explicitly attached entities is fixed
• The bug with redundant parameter prefixes for auto-sync parameters is fixed

Entity Developer

• The default attribute mapping source for LinqConnect models is made static
• Behaviour is changed: table is not marked as "Changed" in Update Wizard if DefaultValue is set for its expression column
• The bug with detecting whether Devart Entity Model is changed or not is fixed
• The bug with NRE being thrown when an invalid connection is used is fixed
• The bug with creating an association between classes participating in a TPC inheritance hierarchy is fixed (Entity Framework models)
• The bug with the local settings used for the default value of DateTime fields is fixed (LinqConnect models)
• The bugs with storage synchronization for TPC inheritance classes is fixed

Entity Framework support

• The bug with determining correct data types in columns of descendants in TPT and TPC hierarchies is fixed
• The bug with the TimeSpan parameters is fixed
• The bug with the Group By expression is fixed

3.50.237 19-Oct-11

• The dotConnect for SQLite installation is improved: now both x86 and x64 sqlite3.dll libraries are copied to the target machine (regardless of its capacity)

LinqConnect (formerly known as LINQ to SQLite)

• The bug with getting wrong query from the compiled query cache is fixed
• The bug with ordering results of a query with eager loading options enabled is fixed
• The bug with inserting entity objects having multiple relations to other entity type with auto-generated primary key is fixed
• The bug with updating navigation properties based on a composite foreign key which intersects with the primary key is fixed

Entity Developer

• The default mapping of SQLite databases with LinqConnect models is improved: integer foreign keys of one-to-one relationships are no more marked as auto-generated
• The possibility of specifying the name of the connection string to be saved in the application configuration file is implemented
• The bug with saving the IsFlags property of enum types in Entity Framework models is fixed

Entity Framework support

• The bug with config.Workarounds.DisableQuoting behaviour with checking DatabaseExists is fixed

3.50.228 29-Sep-11

• The bug with licensing WinForms projects in Delphi Prism is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with ordering queries with eager loading options is fixed
• The bug with caching queries performed via the ExecuteQuery method is fixed
• The bug with .Equals(null) conditions in LINQ queries is fixed

Entity Developer

• Disabling facets that are not applicable to the current field type is implemented (LinqConnect models)
• Default behaviour changed: now the Update To Database Wizard does not drop foreign keys of a table if the 'master' one is not represented in the LinqConnect model
• The bug with saving a new solution provided that the Visual Studio option for 'Projects and Solutions -> Save new projects when created' is unchecked is fixed
• The bug with pluralization algorithm is fixed when Naming rules are defined
• The 'The given key was not present in the dictionary' error in the Entity Developer version integrated into Visual Studio 2010 is fixed
• The bug with incorrect determining of association multiplicity (redundant 'many-to-many') in LinqConnect models is fixed
• The bug with setting Extended Properties for RelationProperty is fixed

Entity Framework support

• The bug when SQLiteEntityProviderWorkaroundConfig.IgnoreSchemaName does not affect stored procedures is fixed

3.50.214 06-Sep-11

LinqConnect (formerly known as LINQ to SQLite)

• Fluent Mapping support is added
• The bug with inserting a TPT 'child' entity in case its primary key column names differ from the 'parent' entity ones is fixed
• The bug with deleting dependent entities when other changes were made is fixed
• The bug with entity materialization for queries with multiple eager loading options is fixed
• The bug with saving (inserting or updating) System.Data.Linq.Binary objects is fixed
• The bug with creating foreign keys in SQLite databases on DataContext.CreateDatabase is fixed

Entity Developer

• Fluent Mapping template for LinqConnect models is added
• Support for enumerated types ("enums") in LinqConnect and Entity Framework June 2011 CTP models is implemented
• New skins to improve the apllication appearance are implemented
• Selection driven highlighting is implemented
• Capability for changing the shape color for entities, complex types and enums is implemented
• Capability for selecting the diagram skin type is implemented
• Changed behaviour: when the FirstLetterUpperCase / FirstLetterLowerCase option is enabled in Naming rules, each letter after underscore will be capital/lower
• The bug with saving custom attribute properties with default values in .edml files is fixed
• The bug with changing property names ("Index was outside the bounds of the array") is fixed
• The bug with an incorrect generation of the private variables names in Entity Framework models is fixed

3.30.202 11-Aug-11

• The support of events which occur when connections are taken and returned to pool for processing SQLiteMonitor.TraceEvent is added
• The bug with SQLiteDump.Backup() for the text columns which contain the quote sign is fixed

LinqConnect (formerly known as LINQ to SQLite)

• The bug with deleting dependent entities when the 'main' one is modified is fixed
• The bug with update commands for Table Per Type inheritance is fixed

Entity Developer

• The pluralization algorithm is improved when Naming rules are defined

Entity Framework support

• The bug with comparing DATETIME columns and parameters is fixed

3.30.196 28-Jul-11

• The Busy Timeout connection string parameter for control of access to database from multiple processes is implemented
• The bug with sqlite3.dll when working with .NET Framework of version 4.0 only is fixed

Entity Developer

• The Entity Key handling for Views in Update From Database Wizard in Entity Framework models is improved
• The bug with wrong error placing in Model Explorer in Entity Framework models is fixed
• The bug with regeneration of the ed:Guid attribute of navigation properties after Update From Database wizard completes is fixed (Entity Framework models)

Entity Framework support

• The processing of LINQ expressions which work with literals is improved

3.30.185 07-Jul-11

• The bug with securityTrimmingEnabled option of Site Map provider is fixed

LinqConnect (formerly known as LINQ to SQLite)

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

Entity Developer

• The possibility to export the diagram into an image file was added
• The possibility to restrict adding the connection string information to the application configuration file is added
• The changes in the Entity name are now preserved by Update From Database Wizard (Entity Framework models)
• The bug with default value quotation in Entity Framework models is fixed
• The bug with Save All for the Read Only model files in Entity Framework models is fixed
• The bug with Primary Key naming in case of many-to-many associations in Model First is fixed (LinqConnect models)

Entity Framework support

• Entity Framework 4.2 June 2011 CTP is supported

3.30.172 15-Jun-11

LinqConnect (formerly known as LINQ to SQLite)

• The 'IsReference' mode of entity serialization is supported
• The bug with querying entity tables having no primary key is fixed
• The bug with ArgumentException on accessing DataContext.Table when the TEntity class has user-defined properties is fixed

Entity Developer

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

Entity Framework support

• The update functionality for default values is improved
• The bug with Default Value and the Identity columns is fixed

3.30.165 01-Jun-11

• The sqlite3.dll library that is included into the installation package is updated to version 3.7.6
• The bug with license check in ILMerged assembly is fixed

LinqConnect (formerly known as LINQ to SQLite)

• Implemented fetch mode customization for eager loading of related entities
• The bug with NullReferenceException when selecting non-entity types is fixed
• The bug with type mismatch when using null parameters in LINQ queries is fixed
• The bug with refreshing entities with a changed entity reference is fixed
• The bug with updating entities that have associations based on unique (not primary) keys is fixed
• The bug with parameters of compiled queries not being refreshed is fixed

Entity Developer

• The bug with configuring a sequence ID generator in LinqConnect models is fixed
• The bug with LinqConnect external mapping file in case entity classes belong to non-default namespace is fixed
• The bug with persisting associations between LinqConnect entity classes inherited from the same base class is fixed
• The bug with Unicode symbols in template is fixed

3.30.160 17-May-11

• DbTransactionBase class is added
• TransactionStateChanging and TransactionStateChanged events are added to the DbConnectionBase class
• Policy file for the Devart.Data.SQLite.Entity assembly is added
• The License Information Wizard is improved: it now generates licenses for projects that have Entity Framework models or refer to Devart.Data.SQLite.Web, but have no direct references to Devart.Data.SQLite.dll
• The "Use schema name" checkbox is added to DataSet Wizard
• The bug with dropping database objects when calling the SQLiteDump.Restore method is fixed
• The bug with Membership provider compatibility between .NET Framework 2.0 and 4.0 is fixed
• The bug with launching Devart documentation via Start menu is fixed

LinqConnect (formerly known as LINQ to SQLite)

• Implemented eager loading in case the related entities collection is referenced in the select clause of the query
• The bug with incorrect operation order during SubmitChanges() calls is fixed
• The bug with ArgumentExceptions thrown in background threads is fixed
• The bug with using public properties when refreshing or materializing an entity is fixed
• The bug with grouping a collection by a whole entity is fixed

Entity Developer

• New Templates are added:
  • LinqConnect: POCO template with XML mapping generation
  • Entity Framework: POCO template, Self-Tracking template, DbContext template with fluent mapping generation
• Templates usability is improved
• Template Editor is significantly improved
• Ability to declare additional properties for model objects is added
• Ability to specify .NET attributes for model objects is added
• Implemented runtime support for literals specified in the 'Default Value' entity field property for LinqConnect models
• The "Preserve schema name in storage" option is added
• The bug with code generation for the 'Delete Rule' association property in LinqConnect models is fixed
• The bug with generation of attach/detach methods for many-to-many associations in LinqConnect models is fixed
• The bug with external mapping for LinqConnect models is fixed
• The bug with default values set via a function for string fields in LinqConnect models is fixed
• The bug with the "Access" combobox of the Association editor in LinqConnect models is fixed
• The bug with procedures that differ only by name in Database Explorer is fixed (Entity Framework models)

Entity Framework support

• Batch Updates support is added
• Adjustable SQL Formatting for DML commands is added
• Ability to configure the NULL values inserting behaviour is added
• IgnoreSchemaName workaround (mainly for Code First) is added
• DisableQuoting workaround is added
• SQLiteFunctions.Like support (including LINQ to Entities) is added
• Configurable database deletion and creation support is added
• The bug with Entity Framework configurability is fixed
• The bug with Optimistic Concurrency is fixed

3.10.141 19-Apr-11

LinqConnect (formerly known as LINQ to SQLite)

• Implemented workaround for comparing SQLite DateTime values as strings in LinqConnect update checks (such values are explicitly converted to the SQLite DateTime type now)
• Fixed bug with invalid aliases in queries that include the UNION clause
• Fixed bug with simultaneous insert of both sides of a one-to-one association when the 'master' side has auto-generated ID

Entity Framework support

• Entity Framework 4.1 RTW supported

3.10.135 06-Apr-11

• Added support for Write-Ahead Logging (WAL) journal mode
• Added static methods SQLiteConnection.EnableSharedCache() and SQLiteConnection.DisableSharedCache()
• Fixed bug with upgrading *.cs files in App_Code folder when using Upgrade Wizard
• Fixed bug with SQLiteDump.Backup() for columns which contain empty value
• Fixed bug with retrieving DateTime values in Ticks format

LinqConnect (formerly known as LINQ to SQLite)

• Implemented the Attach(object entity, object original) method of the Devart.Data.Linq.ITable interface
• Implemented proper support for both text and binary representations of System.Guid

Entity Developer

• Fixed bug with multiplicity changing in the association editor (Entity Framework models)

Entity Framework support

• Fixed some bugs in Guid support

3.10.126 23-Mar-11

• Supported Visual Studio 2010 Service Pack 1
• Implemented backing up views, triggers, and indexes by SQLiteDump
• Fixed bug with performance of SQLiteDump.Restore()
• Fixed bug with SQLiteCommand object when its parameters collection contains several parameters
• Fixed bug with upgrading *.ascx files when using Upgrade Wizard

LinqConnect (formerly known as LINQ to SQLite)

• Fixed bug with inserting 'detail' entities together with 'master' ones for one-to-one associations

Entity Developer

• Added multiple database file support (using Attach connection string parameter)
• Changed behaviour: when adding two related entities with the corresponding properties having different types, an invalid association is created now
• Fixed bug with generating incorrect code for models having one-to-one associations with a nullable property at the 'detail' side
• Fixed bug with generating script with duplicate columns for entities having two fields of the same complex type

Entity Framework support

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

3.10.121 11-Mar-11

• Fixed bug with the "The message filter indicated that the application is busy" error during uninstall
• Fixed bug with DataLink.Find() method

LinqConnect (formerly known as LINQ to SQLite)

• Implemented implicit sorting by the entity key in queries with defined LoadWith rules
• Fixed bug with calling the base Devart.Data.Linq.DataContext constructor with the mapping argument

Entity Developer

• Fixed bug with discarding changes in Navigation Properties names

Entity Framework support

• Improved Insert/Update/Delete performance by using unnamed parameters

3.10.111 24-Feb-11

• Supported SQL Server Reporting Services x64
• Fixed bug with resetting CopyLocal property of Devart references to False after using Upgrade Wizard
• Fixed bug with unicode characters when using Upgrade Wizard
• Fixed bug with compatibility with Microsoft Team Foundation Server 2010 Power Tools (broken designers for WPF, Silverlight, etc)
• Fixed Visual Studio integration conflict with Windows Phone Developer Tools

LinqConnect (formerly known as LINQ to SQLite)

• Fixed bug with deserializing LinqConnect exceptions
• Fixed bug with attaching entities as modified to DataContext

Entity Developer

• Fixed code generation for many-to-many associations when the Unidirectional serialization mode is enabled (LinqConnect models)
• Fixed some bugs in Table Per Concrete Type (TPC) design time support in Entity Framework models
• Fixed bug with wrong Metadata Artifact Processing setting for Web Site projects in Entity Framework models

3.10.103 09-Feb-11

LinqConnect (formerly known as LINQ to SQLite)

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

Entity Developer

• Added ConstraintSet property for Constraints in the Store part of the Entity Framework model
• Added mapping for Function Import result types (Entity Framework v4 only)
• Changed behaviour: classes created with the Update From Database Wizard are now added to the current diagram
• Changed behaviour: the 'Update Check' is now set to 'Always' and disabled for properties that form the entity key (LinqConnect models)
• Fixed bug with the 'Show Print Markup' button and 'Page Setup' menu item being disabled

3.10.96 27-Jan-11

• The 3.7.4 version of sqlite3.dll included to the installation package
• Implemented Default Command Timeout connection string parameter and SQLiteConnectionStringBuilder.DefaultCommandTimeout property
• Added BeginTransaction value to the MonitorEventType enum
• Implemented the DbMonitor.EventQueueLimit property which allows to set the maximal allowed number of messages waiting for being processed by the dbMonitor application
• Fixed bug with incorrect EventType passed to TraceEvent of DbMonitor

LinqConnect (formerly known as LINQ to SQLite)

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

Entity Developer

• Added possibility to split model into several diagrams for better handling of large models
• Implemented possibility to disable automatic recognition of many-to-many associations
• Fixed bug with handling errors when accessing server via an invalid connection
• Fixed bug with generating code for methods returning scalar result in Entity Framework models
• Fixed bug with adding associated tables from the Store part of the model to designer in Entity Framework models
• Fixed bug with opening models that have invalid connection strings

Entity Framework support

• Fixed bug with TruncateTime canonical function

3.00.86 12-Jan-11

• Added "Transaction Scope Local" connection string option that enables the support for non-distributed transactions in the TransactionScope implementation
• Changed behaviour: setting the DbDataTable.Connection property sets the InsertCommand.Connection, UpdateCommand.Connection, and DeleteCommand.Connection properties
• Fixed bug with incorrect case of data sources shown in the DataLink.DataSource property when using the Interform technology
• Fixed bugs with SQLiteDataType.DateTime and SQLiteDataType.Double parameters

LinqConnect (formerly known as LINQ to SQLite)

• 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 inserting Int32 values
• Fixed bug with columns marked as NUMERIC

Entity Developer

• Fixed bug with many-to-many and Update From Database Wizard

3.00.69 16-Dec-10

• Supported Visual Studio 2010 Service Pack 1 Beta
• Added overloads for methods of DbDataReaderBase class with column name parameter
• Changed behaviour: when clearing the pool, the number of connections specified in 'Min Pool Size' is never removed
• Fixed bug with retrieving boolean values from database

LinqConnect (formerly known as LINQ to SQLite)

• Implemented support for custom type arguments in LinqConnect compiled queries
• Fixed bug with redundant subqueries and Order By clauses in commands generated for entities with configured load options
• Fixed bug with Visual Basic code generation for sequence-generated entity properties
• Fixed bug with the DataContext.Query<TResult> method in the case when TResult is not an entity class
• Fixed bug with the 'The process was terminated due to an unhandled exception' error on severely loaded applications
• Fixed bug with LINQ queries with parameters in the Select clause

Entity Developer

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

Entity Framework support

• Improved SQL generation for IN (Entity SQL) and Contains (LINQ to Entities) clauses

3.00.58 29-Nov-10

• Added the 'Validate Connection' connection string parameter to validate connection on its retrieving from pool
• Fixed bug with validating connections in pool
• Fixed bug with WebSite projects in Delphi Prism

LinqConnect (formerly known as LINQ to SQLite)

• Ability to execute DML statements in batches on SubmitChanges added
• Table Per Type inheritance supported
• Supported ASP.NET Dynamic Data with ASP.NET Dynamic Data project templates
• PLINQ support added (connection manager redesigned for thread safety)
• Supported Visual Studio Debugger Visualizer with SQL syntax highlighting for the DataQuery objects
• Implemented overloads of DataContext.CreateDatabase and DeleteDatabase methods with boolean parameters specifying whether to create/delete database or not
• Changed behaviour: retrieving master entity from details one now generates left outer join instead of inner join
• Fixed bug with creating table constraints when using the DataContext.CreateDatabase() method
• Fixed bug with executing compiled queries with boolean parameters

Entity Developer

• Added Update Model From Database functionality
• Update To Database with Storage Synchronization functionality added
• Added possibility for changing the UpdateCheck property for several fields at once
• Added multiselect support for properties
• Improved large models handling
• Fixed bug with IndexOutOfRangeException on code generation
• Fixed bug with keyword quotation in the Source property
• Fixed bug with Unknown parameter direction
• Fixed "Cannot find column Position" bug
• Fixed bug with Visual Basic code generation for stored functions
• Fixed bug with not loading Master property in Detail entity of master/details associations
• Fixed bug with mapping One-to-One associations to One-to-Many
• Fixed bug with Default Value in Entity Framework models
• Fixed bug with default editor in Visual Studio
• Fixed bug with associations that crash Visual Studio
• Fixed bug with Guid and inheritance
• Fixed 'Model is not registered' bug
• Fixed bug with Retrieve Data
• Fixed some bugs in Team Foundation Server support

2.90.190 04-Nov-10

• Implemented integration with Visual Web Developer 2008 and 2010 Express editions
• Implemented the BackupQuery method of SQLiteDump for dumping result sets

LinqConnect (formerly known as LINQ to SQLite)

• Improved transaction behaviour in case when exception is thrown
• 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

2.90.180 14-Oct-10

• Fixed bug with generating license resource for ILMerged assembly

LinqConnect (formerly known as LINQ to SQLite)

• DataContext class is now CLS-Compilant
• Fixed bug with DataLoadOptions not working when object tracking is disabled
• Fixed bug with second-level details loading
• Fixed bug with creating compiled query using more than three parameters
• Fixed bug with select queries from tables with no primary key
• Fixed bug with constraint violation on inserting details before master data
• Fixed bug with ArgumentException when using System.Nullable.GetValueOrDefault in Visual Basic LINQ queries
• Fixed bug with incorrect marking of changed fields when using several DataContexts

Entity Developer

• Added default bindings to entity fields in Insert(Update/Delete) MethodMappings
• Fixed bug with opening .edmx model in Entity Developer
• Fixed bug with serializing entities loaded using DataLoadOptions

2.90.170 23-Sep-10

• Implemented host option for current process in dbMonitor
• Added possibility for tracing the distributed transactions in DBMonitor
• Fixed the 'Retrieving the COM class factory for component ... failed' error during installation on x64 machines
• Fixed bug with Minimal+LINQ installation
• Fixed bug with empty parameters of SQLiteCommand
• Fixed bug with enlisting ASP.NET provider's activity to distributed transaction
• Fixed bug with assertion failure on show call tree in dbMonitor

LinqConnect (formerly known as LINQ to SQLite)

• Fixed bug with editing Entity Key values
• Fixed bug with IndexOutOfRangeException on the DeleteOnSubmit call
• Fixed bug on inserting new rows into a table with many-to-many association
• Fixed bug with fetching records one-by-one from the 'detail' table in master/details relation
• Fixed bug with retrieving entities of an inherited type
• Fixed bugs with using the Contains method of empty arrays
• Fixed bug with the RejectChanges method not working
• Fixed bug with structs in queries
• Fixed bug with Command Timeout
• Fixed bug with creating table constraints when using the DataContext.CreateDatabase() method

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

2.90.152 28-Jul-10

• Implemented capability of extending base functionality of ASP.NET providers
• Added support for Enterprise Library 5
• Changed the primary key of the aspnet_sessions table for ASP.NET Web providers (the ApplicationName column added)
• Fixed bug with DataTable in design time when using DevExpress XtraReport
• Fixed bug with creating connection in Server Explorer (connections are removed after uninstall now)

LinqConnect (formerly known as LINQ to SQLite)

• Added implementation of the ITable interface for the Table class
• Changed DataContext.Log output format for Microsoft compatibility reasons
• Fixed bug with creating XmlMappingSource object when the File Per Class model property is set to true
• Fixed bug with IndexOutOfRangeException on the Refresh call
• Fixed bug with CompiledQueryCache
• Fixed bug with InvalidCastException on selecting a new anonymous type
• Fixed bug with FilePerClass and XMLMappingSource

Entity Developer

• Added possibility of renaming associations in the model
• Fixed bug with change tracking for inherited tables

Entity Framework support

• Fixed bug with association mapping in case of inheritance

2.90.146 07-Jul-10

• Fixed bug with membership provider (connection is not opened on Initialize() now)
• Fixed bug with model registration in web applications

LinqConnect (formerly known as LINQ to SQLite)

• Improved select performance
• Improved insert performance
• Fixed bug with Concat()
• Fixed bug with the CacheStoreReader and Cast

Entity Developer

• Fixed bug with column Summary serialization
• Fixed bug with Visual Basic code generation template

Entity Framework support

• Fixed bug with the DevartEntityDeploy build action

2.90.140 20-May-10

• Supported password salt in ASP.NET membership provider
• Improved Upgrade wizard
• Fixed bug with Upgrade Wizard on web sites
• Fixed bug with disposing data table with InterForm ParentRelation
• Fixed bug with lost InterForm connection
• Fixed bug with filling DevExpress ASPxGridView in Auto DataPagingMode of SQLiteDataSource
• Fixed bug with extra empty string in CommandText
• Fixed bug with named parameter used twice in the same command
• Fixed bug with hashed passwords in Membership provider

LinqConnect (formerly known as LINQ to SQLite)

• LINQ to SQLite support is renamed to LinqConnect
• Added support for Complex type
• Added support for different configurable algorithms for primary key generation
• Automatic configurable compiled query caching supported
• Performance improved
• Fixed bug with DbLinqDataSource and RadGrid paging
• Fixed bug with 'Nop' node translation
• Fixed bug with empty type in specific Group By clause
• Fixed bug with ArgumentNullException on DataContext.Query().Contains()
• Fixed bug with Cast() method

Entity Developer

• Fixed bug with Properties window
• Fixed bug with Discriminator property drag&drop
• Fixed bug on Customization window load
• Fixed bug with property editor grid updating
• Fixed bug with Document.Reload
• Fixed bug with LINQ models on Windows XP 64-bit

Entity Framework support

• Fixed bug with string concatenation

2.80.124 15-Apr-10

• Supported Visual Studio 2010

Entity Developer

• Support for ADO.NET Entity Framework 4 added

Entity Framework support

• Supported ADO.NET Entity Framework 4

2.80.120 31-Mar-10

• Supported Visual Studio 2010 Release Candidate
• Install Wizard improved (ability to automatically uninstall previous version added)
• ADO.NET Data Services v1.5 CTP2 supported
• Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors
• The 3.6.22 version of sqlite3.dll included to the installation package
• Fixed bug with licensing in Visual Studio 2010 Release Candidate projects
• Fixed bug with exception in License Information window
• Fixed bug with multiple rows constraint generation

LINQ to SQLite

• Added support for Boolean type
• Added support for specific dynamic expressions
• Fixed bug with Refresh() method
• Fixed bug with LoadWith() method
• Fixed the 'Unable to cast object' problem
• Fixed bug with Where() and nullable parameter
• Fixed bug with multiple LoadWith() calls
• Fixed bug with calling a method in the Select clause
• Fixed "Cannot Refresh Entity" error
• Fixed bug with nullable boolean and null comparison
• Fixed "Cannot access a disposed object" error
• Fixed bug with "select new"
• Fixed bug with insert of autoincremented values
• Fixed bug with Union
• Fixed bug with NotImplementedException and IGrouping.Count
• Fixed the problem with group by and ordering
• Fixed bug with exception on the master-detail insert
• Fixed bug with Int32 instead of Int64

Entity Developer

• Support for ADO.NET Entity Framework 4 Release Candidate added
• Improved dialogs for editing model objects
• Full integration with Visual Studio implemented
• Improved Find in Model functionality
• Improved One-To-One associations handling
• Fixed bug with different namespaces and procedure code generation
• Fixed bug with Unicode facet serialization
• Fixed problem with DevartEntityDeploySplit
• Fixed problem with metadata resources generation
• Fixed bug with App_Code subfolders
• Fixed bug with Many-to-Many associations
• Fixed several bugs in VB.NET code generation templates
• Fixed bug with "Trial period expired" on 64-bit Windows
• Fixed the "MSL Parsing failed" problem on some model opening
• Fixed bug with Read Only attribute
• Fixed bug with Storage attribute setting
• Fixed bug with OtherKey attribute setting
• Fixed bug with model opening in case of manual association edit
• Fixed bug with Generate related property check box

Entity Framework support

• Supported ADO.NET Entity Framework 4 Release Candidate
  • Support for new Canonical aggregate and scalar functions added
  • Ability to use standard DBMS functions in LINQ queries added
• Added support for methods creating and deleting the database (EF v1 and EF v4)
• Fixed bug with EndsWith method

2.60.79 14-Jan-10

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

LINQ to SQLite

• Fixed the "Destabilize the runtime" problem

Entity Developer

• Fixed bug with incorrect updating of the Project Explorer root node names

Entity Framework support

• Fixed bug with EntitySQL BigCount function

2.60.62 16-Dec-09

LINQ to SQLite

• Changed exception type on the Single method not returning value
• Fixed bug with DataContext.CommandTimeout
• Fixed bug with redundant quering of the nullable association end
• Fixed bug with ArgumentException on provider initialization

Entity Developer

• Fixed bug with 'Generate Related property' serialization

2.60.57 02-Dec-09

Entity Developer

• Fixed bug with the Custom.After.Microsoft.Common.targets file appending
• Fixed bug with inheritance and primary keys

2.60.54 19-Nov-09

• Integration with improved dbMonitor added
• Added orderid column for Site Map provider for custom map node ordering
• Added some DataSet Wizard design-time improvements
• Fixed bug with MembershipProvider.GetAllUsers() method
• Fixed bug with DataLink.DataSource property after regeneration of DataSet

LINQ to SQLite

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

Entity Developer

• New T4 like template engine with powerful editor added
• Updated code generation
  • Ability to generate separate files for classes added
  • Entity Framework Pregenerated Views support added
  • Improved null handling code generation
• Ability to execute LINQ and Entity SQL queries with data and native sql preview added
• Ability to preview and edit data displayed in Database Explorer added
• Table splitting added (emulation of deferred loading for "large" datatypes in EF)
• OnDelete support for associations added
• Corrected the setting of Source and Table attribute for non-database objects
• Fixed bug with attach_Entity methods
• Fixed bug with access and inheritance modifiers for properties

2.50.49 19-Oct-09

• Added SchemaTable property to DbDataTable

LINQ to SQLite

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

Entity Developer

• Fixed bug with wrong IDE configuration path
• Fixed bug with VS template
• Fixed bug with model placed in non-root project folder

2.50.44 24-Sep-09

• Added support for user-defined finctions
• Fixed bugs in DataSet Wizard with Web Service projects
• Fixed bug with licensing projects using wizard in nested folders of solution

LINQ to SQLite

• Suported DeleteOnNull attribute of association and changed default behaviour (DeleteOnNull=false now)

Entity Developer

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

Entity Framework support

• Increased performance for StartsWith, Contains and EndsWith methods

2.30.42 04-Sep-09

• Fixed bug with licensing Startup projects
• Fixed bug with using String.Format function computed at client side

LINQ to SQLite

• Fixed bug with using objects from different contexts
• Fixed bug with String.IsNullOrEmpty() function

Entity Developer

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

2.30.39 06-Aug-09

• Added some installation command line options
• Fixed bug with dotConnects and dbForge Fusion integration

Entity Developer

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

2.30.37 14-Jul-09

• Visual Studio 2010 Beta supported
• The CEROD and SEE extensions are supported
• Ability to execute SQL statements separated with ; added
• Ability to enable extensions with the EnableLoadExtension connection string parameters added
• Performance improved
• ASP.NET Web Providers: Added requiresUniqueEmail functionality

LINQ to SQLite

• Added support of the String.IsNullOrEmpty() method
• Fixed bug with nested LoadWith() methods on the query level
• Fixed bug with inserting parent and several child entities in one InsertOnSubmit() when keys are db-generated
• Fixed bug with the AssociateWith() method and VB.NET

Entity Developer

• Advanced mapping with Entity Framework QueryView supported
• Displaying of Navigation properties on diagram and project explorer implemented
• Ability to change properties order added
• Ability to edit Referential constraints added
• Ability to set OnDelete action added
• Ability to set Rows Affected parameter added
• Added dialogs for suitable storage model editing
• Added advanced search on the model
• Added support for storing connections in the application configuration files
• Added Entity Set Pluralization Naming Rule
• Fixed bug with namespaces
• Fixed bug with invisible OK button in Association Editor
• Fixed bug with <edmx:*> tags
• Fixed bug with XML Comments serialization

2.20.33 21-May-09

LINQ to SQLite

• Added support for CompiledQuery
• Fixed bug with the ExecuteCommand() method
• Fixed bug with Distinct and count symultaneous usage
• Fixed bug with DevExpress 9 integration
• Fixed bug with Bit datatype

Entity Developer

• Fixed some code generation bugs

2.20.29 28-Apr-09

LINQ to SQLite

• Supported extended errors processing
• Supported DataLoadOptions class and Include method for tuning data loading
• Supported DeferredLoadingEnable functionality
• Supported CreateDatabase() and DeleteDatabase() methods
• Supported SqlMethods class
• Added support for returning new Dictionary from query
• Fixed bug with OnValidate()
• Fixed bug with associations based on non-Primary keys
• Fixed bug with SingleOrDefault and BLOBs
• Fixed bug with update of entities that declare a version member
• Fixed bug with ArgumentException in the Contains() method

Entity Developer

• Added support for Entity Framework
• Added naming rules for database objects
• Added Visual Studio integration
• Stability and performance improvements
• Validation schema improved
• Entity Framework Complex Type supported
• Entity Framework Storage Model editing supported
• Many-to-Many associations retrieving added
• Usability improvements
• Fixed bug with the wrong type for autoincrement column

2.00.26 02-Apr-09

• Fixed bug with serialization in C++ projects

2.00.22 16-Feb-09

• Fixed bug with DbDataTable in WPF applications
• Fixed bug with Detail command in DbDataSet ParentRelation

LINQ to SQLite

• Fixed bug with refreshing field values
• Fixed bug with inserting several entities with autogenerated key

2.00.20 14-Jan-09

• Numerous Entity Framework support improvements

LINQ to SQLite

• Fixed bug with Table.Attach function
• Fixed bug with inserting and deleting entities with an associations
• Fixed bug with supporting parameters IsDbGenerated, IsVersion, UpdateCheck, CanBeNull in ColumnAttribute
• Fixed bug with refreshing key fields when an association is present

2.00.16 05-Dec-08

• Fixed bug with null value of EntityRef field in LINQ to SQLite
• Fixed bug with Queriable.Cast to interface type in LINQ to SQLite
• Fixed bug with submitting changes in DbDataTable on WPF

2.00.12 13-Nov-08

• Supported LINQ to SQLite
• Added Entity Developer for LINQ to SQLite
• Supported SQLite engine library version 3.6 and above

1.00.2 22-Apr-08

• Fixed bug with INTEGER PRIMARY KEY AUTOINCREMENT fields in Entity Framework
• Fixed bug with missing SQLite3.dll in the Standard edition

1.00.1 08-Apr-08

• First release of dotConnect for SQLite

 

 

---

© 2002-2024 Devart. All rights reserved.