dotConnect for SQLite History

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