.NET Framework Data Provider for ODBC

===0;
This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.

SQLite3 ODBC Driver

===0;

SQLite.NET

Basic（基本的）

=3;

Using UTF16（使用UTF16編碼）

=3;UseUTF16Encoding=True;

With password（帶密碼的）

=3;Password=myPassword;

Using the pre 3.3x database format（使用3.3x前數據庫格式）

=3;Legacy Format=True;

Read only connection（只讀連接）

=3;Read Only=True;

With connection pooling（設置連接池）

==100;

Using DateTime.Ticks as datetime format（）

=

Store GUID as text（把Guid作為文本存儲，默認是Binary）

=3;BinaryGUID=False;
      如果把Guid作為文本存儲需要更多的存儲空間

Specify cache size（指定Cache大小）=3;Cache Size=2000;
      Cache Size 單位是字節

Specify page size（指定頁大小）

=

Disable enlistment in distributed transactions

=3;Enlist=N;

Disable create database behaviour（禁用創建數據庫行為）=3;FailIfMissing=True;
      默認情況下，如果數據庫文件不存在，會自動創建一個新的，使用這個參數，將不會創建，而是拋出異常信息

Limit the size of database（限制數據庫大小）

=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 （禁用日志回滾）

=3;Journal Mode=Off;
      This one disables the rollback journal entirely.

Persist the Journal File（持久）

=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.

Controling file flushing

=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.