Finisar.SQLite ADO.NET Data Provider connection strings

Connects to


  • Standard

    Data Source=c:\mydb.db;Version=3;

    The "Version" key can take value "2" for SQLite 2.x (default) or value "3" for SQLite 3.x

  • SQLite Version 2.X

    Data Source=c:\mydb.db;Version=2;
  • Create a new database

    Data Source=c:\mydb.db;Version=3;New=True;
  • Using compression

    Data Source=c:\mydb.db;Version=3;Compress=True;
  • Specifying Cache Size

    The Cache Size value represents the amount of data pages that are held in memory. Try increase this value for speed improvements but don't forget to keep track of the applications memory usage.

    Data Source=c:\mydb.db;Version=3;Cache Size=3000;
  • UTF 8

    Data Source=c:\mydb.db;Version=3;UTF8Encoding=True;
  • UTF 16

    Data Source=c:\mydb.db;Version=3;UTF16Encoding=True;
Problems connecting?
Get answer in the SQLite Q & A forum
.NET Framework Class LibraryFinisar.SQLite.SQLiteConnectionInfo and class library downloads

Articlesread all »



Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.