C # connect the SQLite string

Transferred from: Liang Ronghua technical space

Basic)
Data Source = filename; Version = 3;
Using UTF16 (UTF-8 encoding)
Data Source = filename; Version = 3; UseUTF16Encoding = True;
With password (With password)
Data Source = filename; Version = 3; Password = myPassword;
Using the pre 3.3x database format (Using the database format before 3.3x)
Data Source = filename; Version = 3; Legacy Format = True;
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 (The Guid is stored as text, which is Binary by default)
Data Source = filename; Version = 3; BinaryGUID = False;
More storage space is required if the Guid is used as the text storage.
Specify cache size (Specify the Cache size)
Data Source = filename; Version = 3; Cache Size = 2000;
The Cache Size is in bytes.
Specify page size (Specify the page size)
Data Source = filename; Version = 2; Page Size = 1024;
Page Size in bytes