SQLite.NET connection strings

SQLite

Basic

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

Version 2 is not supported by this class library.

With connection pooling

Connection pooling is not enabled by default. Use the following parameters to control the connection pooling mechanism.

Data Source=c:\mydb.db;Version=3;Pooling=True;Max Pool Size=100;

Store GUID as text

Normally, GUIDs are stored in a binary format. Use this connection string to store GUIDs as text.

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

Note that storing GUIDs as text uses more space in the database.

Disable create database behaviour

If the database file doesn't exist, the default behaviour is to create a new file. Use the following parameter to raise an error instead of creating a new database file.

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

Limit the size of database

Data Source=c:\mydb.db;Version=3;Max Page Count=5000;

The Max Page Count is measured in pages. This parameter limits the maximum number of pages of the database.

Persist the Journal File

This one blanks and leaves the journal file on disk after a commit. Default behaviour is to delete the Journal File after each commit.

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

Controling file flushing

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

Full specifies a full flush to take action after each write. Normal is the default value. Off means that the underlying OS flushes I/O's.