dotConnect for SQLite Standard 3.80.350 - Changelog

What's new in dotConnect for SQLite Standard 3.80.350:

May 4th, 2012

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)

What's new in dotConnect for SQLite Standard 3.80.341:

April 13th, 2012

· 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:z
· 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)

What's new in dotConnect for SQLite Standard 3.80.332:

April 13th, 2012

· 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

What's new in dotConnect for SQLite Standard 3.80.325:

March 16th, 2012

· 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

What's new in dotConnect for SQLite Standard 3.70.311:

February 27th, 2012

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

What's new in dotConnect for SQLite Standard 3.70.302:

February 10th, 2012

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

What's new in dotConnect for SQLite Standard 3.70.293:

January 27th, 2012

· 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

What's new in dotConnect for SQLite Standard 3.60.283:

January 13th, 2012

· 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

What's new in dotConnect for SQLite Standard 3.60.268:

December 27th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.60.258:

December 9th, 2011

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

What's new in dotConnect for SQLite Standard 3.50.250:

November 25th, 2011

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

What's new in dotConnect for SQLite Standard 3.50.244:

November 11th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.50.237:

October 21st, 2011

· 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)
· The bug with license check in ILMerged assembly in Mobile Edition is fixed

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

What's new in dotConnect for SQLite Standard 3.50.228:

September 30th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.50.214:

September 7th, 2011

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

What's new in dotConnect for SQLite Standard 3.30.202:

August 19th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.30.196:

July 29th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.30.185:

July 9th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.30.172:

June 16th, 2011

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

What's new in dotConnect for SQLite Standard 3.30.165:

June 8th, 2011

· The sqlite3.dll library that is included into the istallation package renewed 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

What's new in dotConnect for SQLite Standard 3.30.160:

May 18th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.10.141:

May 18th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.10.135:

May 18th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.10.126:

May 18th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.10.121:

May 18th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.10.111:

May 18th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.10.103:

May 18th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.10.96:

May 18th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.00.86:

May 18th, 2011

· 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

What's new in dotConnect for SQLite Standard 3.00.69:

May 18th, 2011

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

What's new in dotConnect for SQLite Standard 2.90.140:

May 22nd, 2010

· 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

What's new in dotConnect for SQLite Standard 2.80.124:

May 22nd, 2010

· Supported Visual Studio 2010
· Entity Developer
· Support for ADO.NET Entity Framework 4 added
· Entity Framework support
· Supported ADO.NET Entity Framework 4

What's new in dotConnect for SQLite Standard 2.80.120:

May 22nd, 2010

· 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

What's new in dotConnect for SQLite Standard 2.60.79:

January 14th, 2010

· 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

What's new in dotConnect for SQLite Standard 2.60.62:

December 21st, 2009

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

What's new in dotConnect for SQLite Standard 2.60.57:

December 7th, 2009

Entity Developer:
· Fixed bug with the Custom.After.Microsoft.Common.targets file appending
· Fixed bug with inheritance and primary keys

What's new in dotConnect for SQLite Standard 2.60.54:

November 24th, 2009

· 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

What's new in dotConnect for SQLite Standard 2.50.49:

October 22nd, 2009

· 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

What's new in dotConnect for SQLite Standard 2.50.44:

September 29th, 2009

· 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

What's new in dotConnect for SQLite Standard 2.30.42:

September 21st, 2009

· 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

What's new in dotConnect for SQLite Standard 2.30.39:

September 3rd, 2009

· 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

What's new in dotConnect for SQLite Standard 2.30.37:

July 18th, 2009

· 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 tags
· Fixed bug with XML Comments serialization

What's new in dotConnect for SQLite Standard 2.20:

May 14th, 2009

· Supported extended errors processing
· Supported DataLoadOptions class and Include method for tuning data loading
Supported DeferredLoadingEnable functionality Entity Developer:
· Added support for Entity Framework
· Added naming rules for database objects
· And more...