SQLite.NET
Data Source=filename;Version=3;
Data Source=filename;Version=3;UseUTF16Encoding=True;
Data Source=filename;Version=3;Password=myPassword;
Data Source=filename;Version=3;Legacy Format=True;
Data Source=filename;Version=3;Read Only=True;
Data Source=filename;Version=3;Pooling=False;Max Pool Size=100;
Data Source=filename;Version=3;DateTimeFormat=Ticks;
The default value is ISO8601 which activates the use of the ISO8601 datetime format
The default value is ISO8601 which activates the use of the ISO8601 datetime format
Data Source=filename;Version=3;BinaryGUID=False;
如果把Guid作为文本存储需要更多的存储空间
如果把Guid作为文本存储需要更多的存储空间
Data Source=filename;Version=3;Page Size=1024;
Page Size单位是字节
Page Size单位是字节
Data Source=filename;Version=3;Enlist=N;
Data Source=filename;Version=3;Max Page Count=5000;
Data Source=filename;Version=3;Journal Mode=Persist;
This one blanks and leaves the journal file on disk after a commit. Default behaviour is to delete the Journal File after each commit.
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=filename;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