Developers community number 1 connection string reference

SQLite.NET

This is a .NET Framework Class Library provided by SQLite.
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
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.

Connection Strings
The SQLite.NET class library can be used to connect to the following data sources.

To see the available connection options, navigate to the connection strings reference by clicking the data source link.
SQLite
Additional info or comments on this class library? Want to submit content?

Send an e-mail to
Copyright © 2010 ConnectionStrings.com   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.