See Also: SqliteConnection Members
| ParameterValuesRequiredDefault | ||||
|---|---|---|---|---|
| Data Source | {filename} | Y | ||
| Version | 3 | N | 3 | |
| UseUTF16Encoding | True False | N | False | |
| DateTimeFormat | Ticks - Use DateTime.Ticks ISO8601 - Use ISO8601 DateTime format | N | ISO8601 | |
| BinaryGUID | True - Store GUID columns in binary form False - Store GUID columns as text | N | True | |
| Cache Size | {size in bytes} | N | 2000 | |
| Synchronous | Normal - Normal file flushing behavior Full - Full flushing after all writes Off - Underlying OS flushes I/O's | N | Normal | |
| Page Size | {size in bytes} | N | 1024 | |
| Password | {password} | N | ||
| Enlist | Y - Automatically enlist in distributed transactions N - No automatic enlistment | N | Y | |
| Pooling | True - Use connection pooling False - Do not use connection pooling | N | False | |
| FailIfMissing | True - Don't create the database if it does not exist, throw an error instead False - Automatically create the database if it does not exist | N | False | |
| Max Page Count | {size in pages} - Limits the maximum number of pages (limits the size) of the database | N | 0 | |
| Legacy Format | True - Use the more compatible legacy 3.x database format False - Use the newer 3.3x database format which compresses numbers more effectively | N | False | |
| Default Timeout | {time in seconds}The default command timeout | N | 30 | |
| Journal Mode | Delete - Delete the journal file after a commit Persist - Zero out and leave the journal file on disk after a commit Off - Disable the rollback journal entirely | N | Delete | |
| Read Only | True - Open the database for read only access False - Open the database for normal read/write access | N | False | |
| Max Pool Size | The maximum number of connections for the given connection string that can be in the connection pool | N | 100 | |
| Default IsolationLevel | The default transaciton isolation level | N | Serializable | |
| FileProtectionComplete | iOS only - Sets the SQLite file protection level to Complete, requires the "DataProtectionClass" entitlement in your application. The data will only be available when the device is unlocked, and the safety is only as gooas the device passcode. | N | False | |
| FileProtectionCompleteUnlessOpen | iOS only - Sets the SQLite file protection level to CompleteUNlessOpen, requries the "DataProtectionClass" entitlement in your application. You can access the data even if the device is locked and you can also create these files if the device is unlocked. | N | False | |
| FileProtectionCompleteUntilFirstUserAuthentication | iOS only - Sets the SQLite file protection level to CompleteUnlessOpen, requries the "DataProtectionClass" entitlement in your application. | N | False | |
| FileProtectioNone | iOS only - forces the file to not have any file protection. Useful if the containing directory has been flagged to be protected, this overrides the behavior. | N | False |