Documentation for this section has not yet been entered.
| ParameterValuesRequiredDefault | ||||
|---|---|---|---|---|
| Data Source | {filename} | Y | ||
| Version | 3 | N | 3 | |
| UseUTF16Encoding | True False | N | False | |
| DateTimeFormat | Ticks - Use DateTime.TicksISO8601 - Use ISO8601 DateTime formatJulianDay - Use JulianDay format | N | ISO8601 | |
| BinaryGUID | Yes/On/1 - Store GUID columns in binary formNo/Off/0 - Store GUID columns as text | N | On | |
| Cache Size | {size in bytes} | N | 2000 | |
| Synchronous | Normal - Normal file flushing behaviorFull - Full flushing after all writesOff - Underlying OS flushes I/O's | N | Normal | |
| Page Size | {size in bytes} | N | 1024 | |
| Password | {password} | N | ||
| Enlist | Y - Automatically enlist in distributed transactionsN - No automatic enlistment | N | Y | |
| Pooling | True - Use connection poolingFalse - Do not use connection pooling | N | False | |
| FailIfMissing | True - Don't create the database if it does not exist, throw an error insteadFalse - 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 formatFalse - 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 commitPersist - Zero out and leave the journal file on disk after a commitOff - Disable the rollback journal entirely | N | Delete | |
| Read Only | True - Open the database for read only accessFalse - 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 |