SQLite数据库连接方式

SQLite数据库连接方式
 
SQLite.NET
Type:    .NET Framework Class Library
Usage:  System.Data.SQLite.SQLiteConnection
Basic
Data Source=filename;Version=3;
Version 2 is not supported by this class library.
 Using UTF16
Data Source=filename;Version=3;UseUTF16Encoding=True;
 With password
Data Source=filename;Version=3;Password=myPassword;
 Using the pre 3.3x database format
Data Source=filename;Version=3;Legacy Format=True;
 With connection pooling
Connection pooling is not enabled by default. Use the following parameters to control the connection pooling mechanism.
Data Source=filename;Version=3;Pooling=False;Max Pool Size=100;
 Read only connection
Data Source=filename;Version=3;Read Only=True;
 
Using DateTime.Ticks as datetime format
Data Source=filename;Version=3;DateTimeFormat=Ticks;
The default value is ISO8601 which activates the use of the ISO8601 datetime format
 
Store GUID as text
Normally, GUIDs are stored in a binary format. Use this connection string to store GUIDs as text.
Data Source=filename;Version=3;BinaryGUID=False;
Note that storing GUIDs as text uses more space in the database.
 
Specify cache size
Data Source=filename;Version=3;Cache Size=2000;
The Cache Size value measured in bytes
 
Specify page size
Data Source=filename;Version=3;Page Size=1024;
The Page Size value measured in bytes
 
Disable enlistment in distributed transactions
Data Source=filename;Version=3;Enlist=N;
 
 Disable enlistment in distributed transactions
Data Source=filename;Version=3;Enlist=N;
 
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=filename;Version=3;FailIfMissing=True;
  Limit the size of database
Data Source=filename;Version=3;Max Page Count=5000