原貼位址:https://www.connectionstrings.com/sqlite/
SQLite.NET
-
Basic
Version 2 is not supported by this class library.Data Source=c:\mydb.db;Version=3;
- SQLite
-
In-Memory Database
An SQLite database is normally stored on disk but the database can also be stored in memory. Read more about SQLite in-memory databases here.Data Source=:memory:;Version=3;New=True;
- SQLite
-
Using UTF16
Data Source=c:\mydb.db;Version=3;UseUTF16Encoding=True;
- SQLite
-
With password
Data Source=c:\mydb.db;Version=3;Password=myPassword;
- SQLite
-
SqlLite連接配接字元串 -
Using the pre 3.3x database format
Data Source=c:\mydb.db;Version=3;Legacy Format=True;
- SQLite
-
With connection pooling
Connection pooling is not enabled by default. Use the following parameters to control the connection pooling mechanism.Data Source=c:\mydb.db;Version=3;Pooling=True;Max Pool Size=100;
- SQLite
-
Read only connection
Data Source=c:\mydb.db;Version=3;Read Only=True;
- SQLite
-
Using DateTime.Ticks as datetime format
The default value is ISO8601 which activates the use of the ISO8601 datetime formatData Source=c:\mydb.db;Version=3;DateTimeFormat=Ticks;
- SQLite
-
Store GUID as text
Normally, GUIDs are stored in a binary format. Use this connection string to store GUIDs as text.
Note that storing GUIDs as text uses more space in the database.Data Source=c:\mydb.db;Version=3;BinaryGUID=False;
- SQLite
-
Specify cache size
The Cache Size value measured in bytesData Source=c:\mydb.db;Version=3;Cache Size=2000;
- SQLite
-
Specify page size
The Page Size value measured in bytesData Source=c:\mydb.db;Version=3;Page Size=1024;
- SQLite
-
Disable enlistment in distributed transactions
Data Source=c:\mydb.db;Version=3;Enlist=N;
- SQLite
-
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=c:\mydb.db;Version=3;FailIfMissing=True;
- SQLite
-
Limit the size of database
The Max Page Count is measured in pages. This parameter limits the maximum number of pages of the database.Data Source=c:\mydb.db;Version=3;Max Page Count=5000;
- SQLite
-
Disable the Journal File
This one disables the rollback journal entirely.Data Source=c:\mydb.db;Version=3;Journal Mode=Off;
- SQLite
-
Persist the Journal File
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=c:\mydb.db;Version=3;Journal Mode=Persist;
- SQLite
-
Controling file flushing
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.Data Source=c:\mydb.db;Version=3;Synchronous=Full;
- SQLite
↯ Problems connecting? Get answer in the SQLite Q & A forum
Finisar.SQLite ADO.NET Data Provider
-
Standard
The "Version" key can take value "2" for SQLite 2.x (default) or value "3" for SQLite 3.xData Source=c:\mydb.db;Version=3;
- SQLite
-
SQLite Version 2.X
Data Source=c:\mydb.db;Version=2;
- SQLite
-
Create a new database
Data Source=c:\mydb.db;Version=3;New=True;
- SQLite
-
Using compression
Data Source=c:\mydb.db;Version=3;Compress=True;
- SQLite
-
Specifying Cache Size
The Cache Size value represents the amount of data pages that are held in memory. Try increase this value for speed improvements but don't forget to keep track of the applications memory usage.Data Source=c:\mydb.db;Version=3;Cache Size=3000;
- SQLite
-
UTF 8
Data Source=c:\mydb.db;Version=3;UTF8Encoding=True;
- SQLite
-
UTF 16
Data Source=c:\mydb.db;Version=3;UTF16Encoding=True;
- SQLite
SQLite3 ODBC Driver
-
Standard
DRIVER=SQLite3 ODBC Driver;Database=c:\mydb.db;LongNames=0;Timeout=1000;NoTXN=0; SyncPragma=NORMAL;StepAPI=0;
- SQLite
.NET Framework Data Provider for ODBC
-
Use an ODBC driver from .NET
See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;