About SQLite.NET

This class library is an ADO.NET wrapper around the popular (and free!) SQLite database engine. For information on SQL syntax, features of SQLite and a good understanding of how it works and what it does, I highly recommend heading over to sqlite.org and reading the documentation there.

The C# provider, the very minor C code modifications to SQLite, documentation and etc were written by Robert Simpson, and the SourceForge project page can be found here.

The System.Data.SQLite project is currently maintained by the SQLite Development Team and the latest source code and project information can be found here.


What's New?

Click here to see the version history of this SQLite.NET provider


Using this library

The following are links to information on various aspects of the library and how to use it in your application(s)

How to install Visual Studio Design-Time Support

How to configure and enumerate SQLite.NET through the DbProviderFactories object

Getting the best performance out of SQLite

Limitations of the SQLite.NET provider and the SQLite engine (compared to other providers and engines)


SQLite.NET Provider Features

This SQLite provider implements every feature of the underlying SQLite database engine without omission. Here's a brief summary:


Distributing the Binaries (Desktop)

When using the mixed-mode assembly, the System.Data.SQLite.DLL file includes all the native and managed code. In that case, this is the only DLL required to be redistributed with your SQLite.NET application(s).  When using separate native and managed assemblies, the System.Data.SQLite.DLL file contains all the managed code and the SQLite.Interop.DLL file contains all the native code. The native code comes in 3 flavors: Win32, Itanium and x64 (AMD64).
Itanium processor support not currently included.

Distributing the Binaries (Compact Framework)

Both the System.Data.SQLite.DLL and SQLite.Interop.XXX.DLL files must be deployed on the Compact Framework.  The XXX is the build number of the System.Data.SQLite library (e.g. "095").  The SQLite.Interop.XXX.DLL file is a fully native assembly compiled for the ARM processor, and System.Data.SQLite is the fully-managed Compact Framework assembly.