Devart Forums

Dear users,

Devart is glad to announce the release of the new version of dotConnect for SQLite, enhanced database connectivity solution, built over the ADO.NET architecture, that supports Entity Framework and LinqConnect ORM solutions.

New version of dotConnect for SQLite offers you support for Microsoft Sync Framework 2.1 and SQLite Online Backup API.

Sync Framework Support

dotConnect for SQLite now provides support for Sync Framework 2.1. It provides SQLiteSyncProvider class, classes for provisioning and deprovisioning, and SQLiteSyncDescriptionBuilder class. Now you can easily synchronize your SQLite databases using dotConnect for SQLite.

SQLite Online Backup API Support

Previously dotConnect for SQLite offered the SQLiteDump component for backing up a SQLite database to a DDL/DML script. Now you can use also SQLite Online Backup API for backing up a database with dotConnect for SQLite.


Here is the complete list of dotConnect for SQLite 5.0.17 features:

• 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
• The bug with ignoring 'IsDbGenerated = True' when using Attach(TEntity entity, bool asModified) method is fixed
• The bug with the compiled query cache when query contains parameters with the same values is fixed

Entity Developer

• The predefined templates are improved: new template setting, "Use Compiled Query Cache", is added (LinqConnect models)
• The bug with "DevartEntityDeploy" task, which generates mapping files, in Visual Studio 2013 Release Candidate is fixed

Entity Framework support

• 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

Devart development team
http://www.devart.com/dotconnect/sqlite/