SQLite - Overview

This article is relevant to entity models that utilize the deprecated Visual Studio integration of Telerik Data Access. The current documentation of the Data Access framework is available here.

To use Telerik Data Access with SQLite you need to download and install the latest version of SQLite from here.

Telerik Data Access has been tested with the 3.7.17 version of SQLite.

SQLite is an ACID-compliant embedded relational database management system. Unlike client–server database management systems, the SQLite engine is not a standalone process with which the application program communicates. Instead, the SQLite library is linked in and thus becomes an integral part of the application program. The library can also be called dynamically. The application program uses SQLite's functionality through simple function calls, which reduces latency in database access as function calls within a single process are more efficient than inter-process communication. The entire database (definitions, tables, indices, and the data itself) is stored as a single cross-platform file on a host machine. This simple design is achieved by locking the entire database file during writing.

In order to develop applications for SQLite with Telerik Data Access, you should download ADO.NET 2.0 Provider for SQLite. This will install the System.Data.SQLite.dll assembly on your computer. The System.Data.SQLite.dll assembly is a wrapper around an unmanaged dll - SQLite.dll. In order to reduce deployment issues, the System.Data.SQLite.dll assembly includes the unmanaged SQLite.dll as a resource. When installing the ADO.NET 2.0 Provider for SQLite, two versions of the driver ( the System.Data.SQLite.dll assembly ) will be installed on your computer - one with the x86 version of the unmanaged dll and another with the x64 version of the unmanaged dll. When an application using SQLite is built with target Any CPU the appropriate version of the System.Data.SQLite.dll assembly needs to be installed (copied) on the target machine. Your installer can decide which version of the System.Data.SQLite.dll assembly to install, based on the target platform.

Type Mapping

The Type Mapping topic shows the default mapping from .NET types to SQLite specific types.