SQLite database connection string (C #)

Basic (Base)Data Source=filename; version=3; Using UTF16(using UTF16 encoding) Data Source=filename; version=3; Useutf16encoding=true; with password (password)Data Source=filename; version=3; Password=mypassword; Using the pre 3.3xdatabase format (using the 3.3x pre-databases) Data Source=filename; version=3; Legacy format=true; Read only connection (read-only connection) Data Source=filename; version=3; Read only=true; With connection pooling (set connection pool)Data Source=filename; version=3; Pooling=false; Max Pool size=100; Using datetime.ticks as DateTime format ()Data Source=filename; Version=3;datetimeformat=ticks;  Store GUID as text (store GUID as text, binary by default)Data Source=filename; version=3; Binaryguid=false;

If you need more storage space for the GUID as a text store

Specify cache Size (Specify cache sizes)

Data Source=filename; version=3; Cache size=2000;

Cache Size Unit is byte

Specify page size (Specify page sizes)Data Source=filename; version=3; Page size=1024;

Page Size Unit is byte

Disable enlistment in distributed transactionsData Source=filename; version=3; Enlist=n; Disable Create DATABASE behaviour (disable the creation of databases behavior)

Data Source=filename; version=3; Failifmissing=true;

by default, if the database file does not exist, it will automatically create a new one, using this parameter, will not be created, but throw exception information

Limit the size of database ( limits the size of databases ) Data Source=filename; 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.

Disable the Journal File ( disables log rollback )

Data Source=filename; version=3; Journal Mode=off;

This one disables the rollback journal entirely.

Persist the Journal File (persistent)Data Source=filename; version=3; Journal mode=persist;   Basic connection to SQLite database:

Data source=mydb.db; version=3;

Possible values for "Version": "2″ refers to SQLite 2.x (default);" 3″ refers to SQLite 3.x

Connect to create a new SQLite database at the same time:

Data source=mydb.db; version=3; New=true;

To enable a compressed connection to the SQLite database:

Data source=mydb.db; version=3; Compress=true;

Specify the cache size to connect to the SQLite database:

Data source=mydb.db; version=3; Cache size=3000;

SQLite database connection string (C #)