Finisar.SQLite ADO.NET Data Provider connection strings

SQLite

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

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;