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.


New features in dotConnect for SQLite 5.6

The current build is 5.6.743 from 22-Sep-2016

  • The sqlite3.dll library that is included into the installation package is updated to version 3.14.2
  • Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services, Reporting Services, and Integration Services (mapping wizards) in Visual Studio 2015 are supported
  • Microsoft SQL Server 2016 is supported in SSIS DataFlow components

Entity Developer

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

Entity Framework

  • Entity Framework Core 1.0.1 is supported
  • The SQLiteConventionSetBuilder class is implemented in the Entity Framework Core support
  • SQLiteCSharpMigrationCodeGenerator and SQLiteVisualBasicMigrationCodeGenerator for code-based migrations are implemented for EF4, EF5, EF6
  • The config.QueryOptions.CaseInsensitiveComparison option is implemented to manage the compare behaviour when using Linq to Entities comparison expression such as "a == b" (by default, false)
  • The config.QueryOptions.CaseInsensitiveLike option is implemented to manage LIKE behaviour when using Linq to Entities extention methods .Contains() .EndsWith() .StartsWith() (by default, false)
  • The DatabaseFacade.GetSQLiteConnection() extension method, which returns SQLiteConnection, is implemented in EF Core
  • The new optional parameter Action<SQLiteDbContextOptionsBuilder> is added to UseSQLite() extension method of DbContextOptionsBuilder in EF Core

New features in dotConnect for SQLite 5.5

The current build is 5.6.743 from 22-Sep-2016

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

Entity Developer

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

Entity Framework

  • Entity Framework Core RC2 is supported
  • Entity Framework-related assemblies are renamed
  • Upgrade Wizard is improved for upgrading projects with the Entity Framework functionality

New features in dotConnect for SQLite 5.3

  • Visual Studio 2015 is supported
  • The sqlite3.dll library that is included into the installation package is updated to version 3.11.1
  • The new Cell Size Check, Cache Spill, Journal Size Limit, Threads, WAL Auto Checkpoint connection string parameters are supported
  • The SQLiteConnection.SQLCipherExport() method is added to migrate from an existing non-encrypted database to a new encrypted one
  • The support for the binary representation of the GUID data types is added to the SQLiteDump class
  • The SQLiteConnection.IsFunctionRegistered() method is added to check if some user-defined function has already been registered for a current session
  • The new metadata collection is added: SQLiteConnection.GetSchema("UserDefinedFunctions") returns information about all user-defined functions registered for a current session

LinqConnect (formerly known as LINQ to SQLite)

  • The possibility to use .IsRowVersion() method for properties with non-binary data types when using the fluent mapping approach is added
  • The Parent property is added to the IInheritanceConfiguration interface

Entity Developer

  • The Use ObservableCollection property of the DbContext template is implemented (Entity Framework models)
  • The behaviour is changed: now the 1:1 and 1:0..1 associations are displayed differently on the diagram (LinqConnect models)

Entity Framework

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

New features in dotConnect for SQLite 5.2

  • Visual Studio 2015 Release Candidate is supported
  • The ADO.NET implementation of ASP.NET Identity support is added
    • The ICloneable interface is implemented in the IdentityUser and IdentityRole classes
    • The User_Id column in the AspNetUserClaims table is renamed to UserId
  • The ADO.NET implementation of ASP.NET Identity 2.0 support is added
    • The new \Web\ASP.NET Identity 2\Devart.Data.SQLite.Web.Identity.dll assembly (its revision number is 2) is added to the provider installation folder
    • The new \Web\ASP.NET Identity 2\Install_identity_tables.sql and \Web\ASP.NET Identity 2\Uninstall_identity_tables.sql files are added to the provider installation folder
    • The new \Web\ASP.NET Identity 2\Upgrade_identity_tables_from_v1_to_v2.sql file is added to the provider installation folder
    • The new IUserEmailStore<TIdentityUser, TKey>, IUserPhoneNumberStore<TIdentityUser, TKey>, IUserTwoFactorStore<TIdentityUser, TKey>, IUserLockoutStore<TIdentityUser, TKey> interfaces are implemented in the UserStore class
    • The new IUserStore<T>, IUserClaimStore<T>, IUserLoginStore<T>, IUserPasswordStore<T>, IUserRoleStore<T>, IUserEmailStore<T>, IUserPhoneNumberStore<T> interfaces are implemented in the SQLiteUserStore and SQLiteUserStore<TIdentityUser, TIdentityRole> classes
    • The new IRoleStore<T> interface is supported in the SQLiteRoleStore and SQLiteRoleStore<TIdentityUser, TIdentityRole> classes
    • The new IQueryableUserStore interface is implemented in the UserStore class
    • The new IQueryableRoleStore interface is implemented in the RoleStore class
  • The sqlite3.dll library that is included into the installation package is updated to version 3.8.10.2
  • SQLiteUtils class is added
  • The SQLiteScript.Cancel() method is added to stop query execution
  • The SQLCipher extension is supported
  • The RefreshMode and RefreshingFields properties for generating row refresh statements are added to the SQLiteCommandBuilder and SQLiteDataTable classes
  • The Enterprise Library 6 support is added; all previous versions of Enterprise Library are no longer maintained
  • The new \Web\ASP.NET 45\Devart.Data.SQLite.Web.dll assembly (its revision number is 5) is added to the provider installation folder to support SimpleMembership in MVC5
  • The enableExpiredSessionAutoDeletion and expiredSessionAutoDeletionInterval options for deleting expired sessions are added to the session-state store provider definition in the web.config file
  • Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
  • SSIS DataFlow Source and Destination components are supported in SSDT-BI for Visual Studio 2013
  • The Time member of the SQLiteType enumeration is implemented; the GetValue and GetProviderSpecificValue methods of SQLiteDataReader return TimeSpan for SQLiteType.Time
  • The performance of the GetSchemaTable method of SQLiteDataReader class is improved
  • The behaviour is changed: the SQLiteMonitor now hides information about the password and "SQLiteCrypt License Key" connection string parameters
  • The behaviour is changed: the GetSchemaTable method of SQLiteDataReader returns information on whether a column is unique only when the command was performed with CommandBehavior.KeyInfo

LinqConnect (formerly known as LINQ to SQLite)

  • The CommandTimeout property is added to the DataProvider class
  • The OpenConnection() method is added to the DataContext class
  • The dependency on the System.Windows.Forms.dll assembly is removed

Entity Developer

  • The information message about availability of NuGet Package Manager on the workstation is added in the Entity Developer version integrated into Visual Studio (Entity Framework models)
  • The override modifier for DbSet class properties generated by DbContext templates is added (Entity Framework models)
  • The View Generation option of the model with Entity Framework version = Entity Framework 6 is supported for the DbContext (only with XML mapping), EntityObject, POCO, and Self-Tracking Entities templates (Entity Framework models)
  • The possibility to use relative paths to assemblies in code generation templates is implemented
  • The Implement Equals property is added to the DbContext, ObjectContext, and POCO Entity templates (Entity Framework models)
  • The Remove Invalid Characters option (by default, True) is added to the Model Naming rules; if it is set to False, all invalid characters will be replaced with underscores
  • The Enable WinForms Data Binding property of the DbContext template is implemented (Entity Framework models)
  • The Property Change Partial Methods property of the DbContext template is implemented for generating partial methods On%PropertyName%Changing and On%PropertyName%Changed for each primitive property of entity classes (Entity Framework models)
  • The support of ID generators for primary keys in the Fluent Mapping template is added (LinqConnect models)
  • The possibility of setting default values for enum properties is implemented (LinqConnect models)
  • The behaviour is changed: now partial configuration classes are generated when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses options (Entity Framework models)
  • The behaviour is changed: now paths to assemblies with attributes (Model Settings -> Model -> Attributes) are saved and used as relative paths
  • The behaviour is changed: now a property in the generated code is initialized basing on the default value in CSDL only (instead of default values in any of SSDL and CSDL; Entity Framework models)
  • The behaviour is changed: now the default value for the 'File Per Class' option of the DbContext template is True (Entity Framework models)
  • The behaviour is changed: Generate Database Script From Model saves the output in ASCII format if there are no unicode symbols in the script; UTF-8 is used otherwise
  • The default behaviour is changed: the INTEGER database type is mapped now to System.Int64 .NET type when using Database-First approach; the new mapping will be applied after pressing Reset in Server Options settings of Entity Developer
  • The behaviour is changed: now the default values are not set for string properties, that correspond to fields with the default values like expressions (Entity Framework models)

Entity Framework

  • Entity Framework 6.1.0 RTM is supported
  • Entity Framework 6.1.0 Tools for Visual Studio 2012 & 2013 are supported
  • The UpdateDatabaseOperation operation in Code-First Migrations for Entity Framework 6.x is supported
  • Multiple EntityContainers in the Code-First CreateDatabase()/CreateDatabaseScript()/DeleteDatabase() functionality are supported
  • The Database.Delete(DbConnection) functionality is supported: all objects in the database are removed if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects
  • The Database.Exists(DbConnection) functionality is supported: the method returns true if DatabaseScript.Schema.DeleteDatabaseBehaviour = AllSchemaObjects and at least one table exists in the current database
  • Determining correct datatypes of data retrieved by EntitySQL queries with UNION ALL and similar constructions is improved
  • The compatibility with Hibernating Rhinos EntityFramework Profiler is improved
  • The database server version is added to the generated Code-First Migrations script
  • The datetimeoffset pseudo type of SSDL, which corresponds to System.DateTimeOffset, is implemented
  • The int16 / int32 / int64 synonyms of the SMALLINT / INT / INTEGER database types are supported in Entity Data Model Wizard
  • The releasing of memory, which was allocated for commands and readers of ObjectContext / DbContext, is improved
  • The performance of generating SQL for Enumerable.Contains in LINQ queries is improved by supporting a new expression type, DbInExpression, in Entity Framework 6
  • The behaviour is changed: now a semicolon (;) after the very last statement is generated in the Code-First CreateDatabaseScript() functionality

31-October-13 New features in dotConnect for SQLite 5.1

  • Visual Studio 2013 is supported
  • The "Native Library Pre-Loading" feature is implemented
  • The sqlite3.dll library that is included into the installation package is updated to version 3.8.2
  • The behaviour is changed: installation with the /VERYSILENT install parameter will uninstall the other version of the provider without any dialog box if it is installed
  • The behaviour is changed: now a transaction rollbacks on Connection.Close() if Transaction.Commit() was not called before closing the connection
  • The behaviour is changed: IndexOutOfRangeException is generated now instead of InvalidOperationException when SQLiteDataReader.GetOrdinal(String name) finds nothing in the result set

LinqConnect (formerly known as LINQ to SQLite)

  • The possibility to inherit from the data provider classes is added
  • The behaviour is changed: now the script is generated with "ON DELETE NO ACTION" when using the CreateDatabase() method and the "Delete Rule" for the association is set to "NO ACTION"
  • The behaviour is changed: now the CreateDatabase() method uses the same algorithm for naming foreign keys as in Entity Developer

Entity Developer

  • Entity Framework 6 is supported
  • The new "Provider Manifest Token" model property is implemented to identify the target server (Entity Framework models)
  • The "WCF DataMember Attribute on Navigation Properties" property is added to the Data Transfer Object template for pointing the end (-s) where the attribute should be generated (Entity Framework models)
  • The predefined templates (POCO Entity and LinqConnect) are improved: new template setting, "Generate Dummy Comments", is added (LinqConnect models)
  • More information messages, when validating EF6 models basing on the EntityFramework.dll functionality, are added (Entity Framework models)
  • The behaviour is changed: the values of "Target Server" and "Server Version" can be reset via the Model Settings > Synchronization > Mapping dialog despite the fact whether connection is specified in Database Explorer or not
  • The behaviour is changed: the validation of EF6 models depends on the EntityFramework.dll functionality only (.NET Framework 4.5 is not required any more) (Entity Framework models)

Entity Framework

  • The 6.0.0 and 6.0.1 versions of Entity Framework are supported
  • The AddForeignKey constraint operation for one-column FK is supported in Code-First Migrations for the case when a new column for FK is created
  • The compatibility of Entity Framework provider for EF v1, v4, v5 with medium trust level environment is improved
  • The behaviour is changed: Entity Data Model Wizard shows a more detailed error message in case of connecting to unsupported database or using incorrect provider manifest tokens
  • The behaviour is changed: a more detailed error message is shown ("OUTER APPLY is not supported by SQLite") in case when the generated SQL contains OUTER APPLY
  • The behaviour is changed: Code-First Migrations generates DEFAULT values for new NOT NULL columns of Boolean, Guid, DateTime types when adding them in the existing table

17-October-13 New features in dotConnect for SQLite 5.0

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

LinqConnect (formerly known as LINQ to SQLite)

  • The Collate method of the SqlMethods class is implemented

Entity Developer

  • The predefined templates are improved: new template setting, "Use Compiled Query Cache", is added (LinqConnect models)

Entity Framework

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

04-April-13 New features in dotConnect for SQLite 4.6

  • Visual Studio 2013 Release Candidate is supported
  • The support of the URI format for the connection string is implemented
  • The LoadExtension connection string parameter is implemented to load sqlite extension(s) right after opening a connection
  • The SQLiteCryptLicenseKey connection string parameter is added to support SQLiteCrypt API
  • The LoadExtension method of the SQLiteConnection object is implemented to load sqlite extension
  • SQL Server 2012 Reporting Services is supported
  • The sqlite3.dll library that is included into the installation package is updated to version 3.7.17
  • The support of asynchronous backing up and restoring for SQLiteDump is implemented
  • The BackupDatabase method of the SQLiteConnection class is implemented
  • The behaviour is changed: provider's build action is installed on the target workstation, on which .NET Framework is available, without Visual Studio integration

LinqConnect (formerly known as LINQ to SQLite)

  • LINQPad integration is supported
  • The possibility to disable query cache via the DataContext's 'EntityCachingMode' property is added
  • The possibility to use the extension method AsQueryable() in LINQ queries is added
  • The support for correct retrieving of the TimeSpan and DateTimeOffset values while materializing is added
  • The performance when working with the TPT-inheritance and retrieving descendants via OfType<> is improved
  • The behaviour is changed: now batch updates are disabled by default

Entity Developer

  • A new MVC Controller template, generating a ASP.NET MVC controller with data access code, is added
  • A new MVC View Advanced template, generating an ASP.NET MVC view based in Twitter Bootstrap, is added
  • A new Data Transfer Object template for DTO classes generation is implemented
  • A new Data Annotation Metadata template, generating Data Annotation metadata classes and decorating classes and properties with data annotation attributes for validation, presentation and defining metadata, is added
  • A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart Entity Framework model is added
  • A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart LinqConnect model is added
  • The design time support for model-defined functions is added (Entity Framework models)
  • Add Template dialog box is improved
  • The Namespace property of class, complex type, enum is implemented
  • The Entity Container Namespace properties of the model is implemented (Entity Framework models)
  • The support for enums declared in external assemblies is implemented
  • The capability for setting special rules for generating default names of database objects when using the Model First approach is implemented (a new Advanced page is added to the Synchronization->Database Naming section of the Model Settings dialog box)
  • The capability to customize properties that are automatically added when creating a new entity, and options that are automatically set when creating a new property is added (a new Initialization page is added to the Model->General section of the Model Settings dialog box)
  • The Refresh option in the Attributes tab of the Model Settings window is implemented; it updates the list of available attributes types in the referenced assemblies
  • The capability to modify custom attributes for several selected entities or properties at the same time is implemented
  • Automatic adding of references to Entity Framework specific assemblies when adding a new Devart Entity model to a project is implemented
  • The capability to cancel metadata reading in wizards and Database Explorer is added
  • The "Recreate Database Tables" check box, which allows to drop and recreate database tables, is added to the "Update To Database" wizard
  • New setting "Detect Table Per Type inheritances", which enables automatic detection of TPT inheritances, is added for Create Model Wizard and model
  • The "Include Drop" check box for including DROP commands for database objects to the generated script is added to Generate Database Script Wizard
  • A new shortcut menu command "Include Related", which allows making a copy of the related objects in the specified diagram, is added
  • A new shortcut menu command "Add To Model with Related", which allows adding tables, related to the selected one, to the model, is added to the shortcut menu of tables in Database Explorer
  • A new shortcut menu command "Add On Diagram With Related", which allows creating an object and all the objects related to it on a diagram, is added to the shortcut menu of classes, complex types, and enums in Model Explorer
  • New "Simple" diagram skin is added for displaying a diagram in metro style
  • The "Default Width" diagram property for specifying the default width for newly created diagram shapes (entities, complex types and enums) is added
  • The Save and Refresh buttons for persisting and reloading changes to / from a database is added to the Retrieve Data grid
  • The "WCF DataMember Attribute on Navigation Properties" property is added to the DbContext and POCO templates for pointing the end (-s) where the attribute should be generated
  • Devart.Data.Linq.Binary type is added to the "Type Mapping Rule Editor" (LinqConnect models)
  • The "Rewrite connection string during regeneration" check box of Model Settings is implemented to determine whether to overwrite the connection string in the project config file with the one, currently set in Entity Developer for the model, each time when regenerating code for the model (LinqConnect models)
  • The "Regenerate Storage and Mapping" option for regenerating model parts, specific to the database server, is added to the diagram shortcut menu
  • The "Model Name As Files Prefix" property is implemented for the templates which generate classes for model entities
  • The possibility of adding custom attributes to enum members is implemented
  • DbContext template is improved: a "WCF Data Contract Attributes" setting for generation of DataContract, KnownType, and DataMember attributes for classes and properties is added (Entity Framework models)
  • DbContext template is improved: "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged" template settings are added (Entity Framework models)
  • DbContext template is improved: a new "Mapping Generation Strategy" property that determines the method of mapping generation is implemented (Entity Framework models)
  • POCO template is improved: a new "WCF Data Contract Attributes" setting for generating DataContract, KnownType, and DataMember attributes for classes and properties is added (Entity Framework models)
  • POCO template is improved: "Proxy Creation Enabled" setting is implemented (Entity Framework models)
  • POCO template is improved: new template settings, "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged", are added (Entity Framework models)
  • POCO Entity template is improved: new template setting, "Property Change Notifiers", is added (LinqConnect models)
  • The "Rewrite connection string during regeneration" option (default value is True) of model settings is added to provide the possibility to turn off modifying connection string in *.config after model is saved first time (Entity Framework models)
  • Create Model Wizard is improved: it is now able to download and install the required 'EnityFramework' Nuget package for Entity Framework 6 models, and for models for Entity Framework 4 and 5 in case they use the DbContext template
  • The Storage Column Editor dialog box is improved: the possibility to specify different settings that were previously available only in the Properties docking window are implemented (Entity Framework models)
  • Class Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
  • Type Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
  • Storage Entity Editor is improved: the capability to edit extended columns settings, such as facets, is added (Entity Framework models)
  • The "Close the window when the generation completes successfully" option in the Generation Process window is implemented in the standalone Entity Developer
  • The behaviour is changed: "Save connection string in App.Config as" check box in Model Settings dialog box is renamed to "Use connection string from App.Config as" (LinqConnect models)
  • The behaviour is changed: now, when creating a new TPH discriminator column in Inheritance Editor, it has the string type by default
  • The behaviour is changed: the error is generated if the Abstract inheritance modifier is set for the class which is involved in the Table Per Type inheritance
  • The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of class property without assigned value
  • The behaviour is changed: a string default value for the property can be set without quotes in the Properties window
  • The behaviour is changed: the validation error is not generated when an abstract class is used in Table Per Type inheritance (Entity Framework models)
  • The behaviour is changed: auto-implemented properties are generated when DbContext template is used with ImplementINotifyPropertyChanged=False and ImplementINotifyPropertyChanging=False (Entity Framework models)
  • The behaviour is changed: DatabaseGeneratedOption is always generated for EntityKey properties when using fluent mapping (Entity Framework models)
  • The behaviour is changed: a default value for the "Detect Table Per Type inheritances" option in Model settings is set to False
  • The behaviour is changed: the possibility to exclude the generation of keys (primary, foreign) in "Update Database From Model" and "Generate Database Script From Model " wizards is added
  • The behaviour is changed: the possibility to add one-to-one associations with nullable foreign key properties is added (LinqConnect models)
  • The behaviour is changed: now by default MVC Controller template generates files in the model folder, MVC View Advanced template creates files in the Views model subfolder
  • The behaviour is changed: now connection string is configured with the name of the assembly, where the model is located, in case when the context class is located in another assembly (Entity Framework models)

Entity Framework

  • Entity Framework 6 Release Candidate 1 is supported
  • The config.DatabaseScript.ForeignKey.Enabled option (default value is True) is added to turn on/off generation of foreign key constraints
  • The config.Workarounds.UseInvariantProviderManifestToken configuration option (default value is False) is added to provide the possibility of returning the invariant string literal as the provider manifest token
  • The config.SqlFormatting.Identation option is renamed to config.SqlFormatting.Indenting

28-February-13 New features in dotConnect for SQLite 4.5

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

Entity Developer

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

Entity Framework

  • Entity Framework 6 Alpha 3 is supported

17-January-13 New features in dotConnect for SQLite 4.4

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

Entity Developer

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

Entity Framework

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

20-December-12 New features in dotConnect for SQLite 4.3

Entity Developer

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

06-September-12 New features in dotConnect for SQLite 4.2

  • Visual Studio 2012 is supported
  • The sqlite3.dll library that is included into the installation package is updated to version 3.7.14
  • The Read-Only connection string parameter is implemented for establishing a connection in the read-only mode

LinqConnect (formerly known as LINQ to SQLite)

  • The fluent mapping is improved: support of the ID generators for primary keys is added

Entity Developer

  • Support for ADO.NET Entity Framework 5 is added
  • Predefined template for generating Repositories and Unit of Work classes is added
  • Integration with Visual Studio refactoring for renaming model objects is implemented
  • The possibility to set different namespaces for the context and its entities when using the DbContext template is implemented (Entity Framework models)
  • The "Use Database Comments" option of Model Settings is implemented to determine whether comments for database objects, if supported by DBMS, will be used for model objects Documentation initialization and taken into account when executing model or database update operations
  • The "Implement IClonable" option for the generated classes based on the model entities is added to all templates
  • The 'Entity Base' class property, which allows specifying the ancestor class/interface for a particular entity type, is implemented (LinqConnect models)
  • The behaviour is changed: the "Save connection string in App.Config as" option is available for LinqConnect models in the standalone version Entity Developer (the entry in App.Config must be added manually afterwards)
  • The behaviour is changed: only particular (not all) property characteristics are regenerated when using Update Model From Database wizard after the metadata of the corresponding column have been changed (LinqConnect models)

Entity Framework

  • ADO.NET Entity Framework 5 is supported
  • The behaviour is changed: Devart.Data.SQLite.Entity.Migrations.dll is built with the 4.4 version of EntityFramework.dll now

17-July-12 New features in dotConnect for SQLite 4.1

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

Entity Developer

  • The possibility to unload assemblies from the main application domain by using separate application domain is implemented
  • The possibility to disable such Database First Settings as type mapping rules is implemented
  • The design time copy/cut/paste functionality for enum members is added
  • The behaviour is changed: the warning, related to the missing property setter, is disabled (LinqConnect models)
  • The behaviour is changed: for the association, in which the many-side entity hasn't the primary key, the code and the mapping are not generated (LinqConnect models)
  • The behaviour is changed: the properties, that correspond autoincrement fields, are generated with a ReadOnly keyword in VB.NET (LinqConnect models)

Entity Framework

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

22-May-12 New features in dotConnect for SQLite 4.0

  • Visual Studio 2012 Release Candidate is supported
  • The RegisterProgressHandler and UnRegisterProgressHandler methods are added to the SQLiteConnection class
  • The Initialization Command connection string parameter is implemented
  • The behaviour is changed: the 'sender' parameter in MonitorEventHandler is a connection and the MonitorEventArgs.ExtraInfo property is filled with the connection string
  • The behaviour is changed: the access modifier of the connectionString field of web provider classes is changed from private to protected

LinqConnect (formerly known as LINQ to SQLite)

  • References to System.Data.Linq are removed; now LinqConnect uses only its own classes
  • Upgrade wizard for upgrading projects to the new version of LinqConnect automatically is added
  • The possibility to choose cache mode (classic mode for cases when DataContext is used as a unit of work, and self-cleaning mode for cases when DataContext is a long-lived object) is added
  • The possibility to map stored procedure out parameters of the CURSOR type to IEnumerable parameters of the corresponding methods is added
  • Tracking of complex object graphs with chains of parent-child objects is optimized
  • Number of database calls required for managing objects with a many-to-many association is reduced
  • Delete rule performance is improved
  • Compilation performance is improved
  • Materialization performance is improved
  • Compiled query cache is improved

Entity Developer

  • The sticker notes for adding comments to diagrams are implemented
  • The possibility to add a stamp, specifying diagram author, company, version, copyrights, project name, and date, to a diagram is implemented
  • New Collapse All and Expand All menu commands for collapsing and expanding diagram shapes are added
  • The support for Ticks-based DateTime columns is added (Entity Framework models)
  • The "Pluralize collection navigation properties" option for the possibility to turn off the pluralization of the many-end names of associations is implemented
  • The "sealed override" inheritance modifier for methods based on stored procedures and functions is added (LinqConnect models)
  • The behaviour is changed: context menu commands for working with diagram are grouped to the Diagram submenu of the context menu
  • The behaviour is changed: the possibility to change diagram shape color via the corresponding Shape -> Color context menu command is added
  • The behaviour is changed: when pasting a copied entity to a new diagram, a new entity is not created, the existing entity is added to this diagram
  • The behaviour is changed: when cutting an entity from the diagram, the entity is not cut from the model, only from the diagram
  • The behaviour is changed: "Update Model From Database" wizard places newly added properties to the base abstract class now instead of putting them into child classes where the mapping is (Entity Framework models)

Entity Framework

  • The config.CodeFirstOptions.RemoveSchemaFromDefaultConstraintName option for removing schema name from the default constraint name is implemented in Code-First Migrations (by default, true)
  • The config.CodeFirstOptions.AddTableNameInDefaultIndexName option for adding a table name to the default index name is implemented in Code-First Migrations (by default, true)
  • The support for Ticks-based DateTime columns is added

15-Mar-12 New features in dotConnect for SQLite 3.80
  • Visual Studio 11 Beta is supported
  • The sqlite3.dll library that is included into the installation package is updated to version 3.7.11
  • The handling of empty options in the connection string is improved

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 multiline popup editor for the Documentation.Summary property is implemented
  • 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

Entity Framework

  • Entity Framework 5.0 Beta 2 is supported
  • SQL generation for .Any method in LINQ to Entities is improved
  • The behaviour is changed: Devart.Data.SQLite.Entity.Migrations.dll is built with the 4.3.1 version of EntityFramework.dll now

27-Jan-12 New features in dotConnect for SQLite 3.70
  • The Guid value is added to the SQLiteType enum

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

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 (formerly known as LINQ to SQLite)

  • 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 (formerly known as LINQ to SQLite)

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