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.

04-Mar-10 New features in dotConnect for SQLite 2.80 Beta

  • Supported Visual Studio 2010 Release Candidate
  • Install Wizard improved (ability to automatically uninstall previous version added)
  • The 3.6.22 version of sqlite3.dll included to the installation package
  • ADO.NET Data Services v1.5 CTP2 supported
  • Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors

Entity Framework

  • 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

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

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