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 dotConnect for SQLite offers you advanced Entity Framework support.

Full-text Search Functionality Support

New dotConnect for SQLite version supports full-text search functionality of SQLite and implements classes for working with full-text search functions in LINQ to Entities. Full-text indexing was supported in Code-First Migrations. The SQLiteCreateTableConfiguration class was created to customize CreateTable operation.

Entity Framework Provider Configuration

Entity Framework provider behaviour can now be configured not only in code but also in the config file of the application. The corresponding xsd file is added to the dotConnect for SQLite installation package to allow using Visual Studio intellisense and validation when editing the corresponding config file sections. Configuring Entity Framework provider through the config file provides you more flexibility than configuring with code because you don't need to recompile your solution to apply new configuration.

Code-First Support Improvements

Creating indexes for foreign key columns is implemented in Code-First CreateDatabase functionality. The config.DatabaseScript.ForeignKey.IndexCreation option is used to control the creation of these indexes.

A new config.Workarounds.IgnoreDboSchemaName option for configuring Entity Framework providers is added. This option is for ignoring the dbo schema name and is enabled by default when using Code-First Migrations, thus allowing you to use Code-First Migrations out-of-the-box without the need to add or remove any conventions manually in your solutions. This also allows you to specify the schema (database) for a table in Code-First Migrations.

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

• 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.11

LinqConnect (formerly known as LINQ to SQLite)

• The bug with enumerating queries that have empty result sets is fixed
• The bug with materializing query results into invalid object properties is fixed
• The query cache bug with distinguishing compiled queries that have nullable parameters is fixed
• The bug with deleting many-to-many links of entity having multiple many-to-many associations is fixed

Entity Developer

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

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

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