dotConnect for SQLite History

This page lists the functionality added in each version of dotConnect for SQLite. To view the full changelog including bug fixes, consult the dotConnect for SQLite revision history.

27-Jan-12 New features in dotConnect for SQLite 3.70

  • The Guid value is added to the SQLiteType enum

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

Entity Framework

  • Entity Framework 4.3 Beta 1 (Code First Migrations) is supported

09-Dec-11 New features in dotConnect for SQLite 3.60

  • 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

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' Oracle option is added: if this option is checked, the "StoreGeneratedPattern" will be set to Identity by default for Number 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 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 behaviour is changed: the 'Real' SQLite data type is now mapped to System.Double by default

Entity Framework

  • 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 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 Code First CreateDatabase is supported

06-Sep-11 New features in dotConnect for SQLite 3.50

  • 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

  • Fluent Mapping support is added

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
  • Disabling facets that are not applicable to the current field type is implemented (LinqConnect models)
  • The possibility of specifying the name of the connection string to be saved in the application configuration file is implemented
  • Default behaviour changed: now the Update To Database Wizard does not drop foreign keys of a table if the 'master' one is not represented in the LinqConnect model
  • The default mapping of SQLite databases with LinqConnect models is improved: integer foreign keys of one-to-one relationships are no more marked as auto-generated
  • The default attribute mapping source for LinqConnect models is made static
  • Behaviour is changed: table is not marked as "Changed" in Update Wizard if DefaultValue is set for its expression column

17-May-11 New features in dotConnect for SQLite 3.30

  • The 3.7.6 version of sqlite3.dll is included to the installation package
  • 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 Busy Timeout connection string parameter for control of access to database from multiple processes is implemented
  • The support of events which occur when connections are taken and returned to pool for processing SQLiteMonitor.TraceEvent is added
  • The "Use schema name" check box is added to DataSet Wizard

LinqConnect

  • Eager loading is implemented in case the related entities collection is referenced in the select clause of the query
  • Fetch mode customization for eager loading of related entities is implemented
  • The 'IsReference' mode of entity serialization is supported

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
  • 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 pluralization algorithm is improved when Naming rules are defined
  • Runtime support for literals specified in the 'Default Value' entity field property for LinqConnect models is implemented
  • The "Preserve schema name in storage" option is added
  • The Entity Key handling for Views in Update From Database Wizard in Entity Framework models is improved

Entity Framework

  • Entity Framework 4.2 June 2011 CTP is supported
  • 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 processing of LINQ expressions which work with literals is improved
  • The update functionality for default values is improved

27-Jan-11 New features in dotConnect for SQLite 3.10

  • Supported Visual Studio 2010 Service Pack 1
  • The 3.7.4 version of sqlite3.dll included to the installation package
  • Implemented backing up views, triggers, and indexes by SQLiteDump
  • Added support for Write-Ahead Logging (WAL) journal mode
  • Added static methods SQLiteConnection.EnableSharedCache() and SQLiteConnection.DisableSharedCache()
  • Supported SQL Server Reporting Services x64
  • 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

LinqConnect

  • 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
  • Implemented implicit sorting by the entity key in queries with defined LoadWith rules

Entity Developer

  • Added multiple database file support (using Attach connection string parameter)
  • 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
  • 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: when adding two related entities with the corresponding properties having different types, an invalid association is created now

Entity Framework

  • Entity Framework 4.1 RTW supported

29-Nov-10 New features in dotConnect for SQLite 3.00

  • Supported Visual Studio 2010 Service Pack 1 Beta
  • Added overloads for methods of DbDataReaderBase class with column name parameter
  • Added the 'Validate Connection' connection string parameter to validate connection on its retrieving from pool
  • Changed behaviour: when clearing the pool, the number of connections specified in 'Min Pool Size' is never removed

LinqConnect

  • 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
  • Implemented support for custom type arguments in LinqConnect compiled queries

Entity Developer

  • Update To Database with Storage Synchronization functionality added
  • Added possibility for changing the UpdateCheck property for several fields at once
  • Added Update Model From Database functionality
  • Added multiselect support for properties
  • Improved large models handling

Entity Framework

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

20-May-10 New features in dotConnect for SQLite 2.90

  • Implemented integration with Visual Web Developer 2008 and 2010 Express editions
  • Implemented the BackupQuery method of SQLiteDump for dumping result sets
  • Implemented host option for current process in dbMonitor
  • Added possibility for tracing the distributed transactions in DBMonitor
  • 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)
  • Supported password salt in ASP.NET membership provider
  • Improved Upgrade wizard

LinqConnect (formerly known as LINQ to SQLite)

  • Improved transaction behaviour in case when exception is thrown
  • DataContext class is now CLS-Compilant
  • Added implementation of the ITable interface for the Table class
  • Changed DataContext.Log output format for Microsoft compatibility reasons
  • 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

Entity Developer

  • Added default bindings to entity fields in Insert(Update/Delete) MethodMappings
  • Added possibility of renaming associations in the model

15-Apr-10 New features in dotConnect for SQLite 2.80

  • Supported Visual Studio 2010
  • 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

LINQ to SQLite

  • Added support for Boolean type
  • Added support for specific dynamic expressions

Entity Framework

  • Supported ADO.NET Entity Framework 4
    • 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)

Entity Developer

  • Support for ADO.NET Entity Framework 4 added
  • Improved dialogs for editing model objects
  • Full integration with Visual Studio implemented
  • Improved Find in Model functionality
  • Improved One-To-One associations handling

20-Nov-09 New features in dotConnect for SQLite 2.60

  • Integration with improved dbMonitor added
  • Added orderid column for Site Map provider for custom map node ordering
  • Added some DataSet Wizard design-time improvements

LINQ to SQLite

  • Devart DbLinqDataSource added
  • Linq performance improved
  • Supported navigation using properties (not only keys)

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

24-Sep-09 New features in dotConnect for SQLite 2.50

  • Added support for user-defined finctions

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

Entity Framework support

  • Increased performance for StartsWith, Contains and EndsWith methods

14-Jul-09 New features in dotConnect for SQLite 2.30

  • 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

Entity Developer 2.20

  • 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

28-Apr-09 New features in dotConnect for SQLite 2.20

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

Entity Developer 2.00

  • 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

13-Nov-08 New features in dotConnect for SQLite 2.00

  • Supported LINQ to SQLite
  • Supported SQLite engine library version 3.6 and above
  • Added Entity Developer for LINQ to SQLite
  • Renamed assemblies, namespaces, and classes (for information on upgrading your projects please refer to FAQ, section Subscriptions and Upgrades)

08-Apr-08 First release of dotConnect for SQLite 1.00