The use of SQLiteConnectionStringBuilder with default isolation level results in an error.
The resulting connection string should be 'default isolation level=...'. Unfortunately, the result is 'default isolationlevel' (missing space!). Because of the false statement, the following error message during connection establishment is generated: Invalid Default IsolationLevel specified
Dim ConnStr As New SQLite.SQLiteConnectionStringBuilder
ConnStr.DataSource = "...\Storage.db3"
ConnStr.DefaultIsolationLevel = IsolationLevel.ReadUncommitted
ConnStr.JournalMode = SQLite.SQLiteJournalModeEnum.Off
ConnStr.Password = "***"
<hr /><i>mistachkin added on 2012-03-01 19:30:58 UTC:</i><br />
The "ReadUncommitted" isolation level is not supported by System.Data.SQLite. The issue you are seeing has nothing to do with the SQLiteConnectionStringBuilder class.
|