SQLite.NET

This .NET Framework Class Library is provided by SQLite. The main functionality of the class library is contained in the file System.Data.SQLite.dll.

Add a reference to the assembly System.Data.SQLite and include the System.Data.SQLite namespace. Instantiate a new SQLiteConnection connection object. Set the connection string and open the connection.

VB.NET code sample

Imports System.Data.SQLite
Dim myConnection As SQLiteConnection = New SQLiteConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()

C# code sample

using System.Data.SQLite;
SQLiteConnection myConnection = new SQLiteConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();

Description

  This class library is a wrapper around the SQLite database engine and implements every feature of the underlying SQLite database engine.

  The provider has full UTF-8 and UTF-16 support, each with optimized pipelines into the native database core.

  Full source for the entire engine and wrapper. No copyrights. Public Domain. 100% free for commercial and non-commercial use.

Download

There is no 'SQLite.NET' installation package to download. (if you know about an installation package URL you can contribute to the community by submitting the info to us through this message form)

Connection Strings

The SQLite.NET class library can be used to connect to the following data sources by using the following connection string references:

SQLite