SQLite.NET
This .NET Framework Class Library is provided by SQLite.
The class library is contained in the file System.Data.SQLite.dll.
The class library is contained in the file System.Data.SQLite.dll.
Coding
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
C# code sample
VB.NET code sample
Imports System.Data.SQLite
Dim myConnection As SQLiteConnection = New SQLiteConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()
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();
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 link missing
The SQLite.NET installation package download link is missing. Please provide info and contribute to the community by email to
Connection Strings
Additional info or comments on this class library? Want to submit content?