System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 6aeb070410356210bbc5e29a8d7d16e753cae0cf
Title: SQLite.SQLiteConnectionStringBuilder: Failure in converting DefaultIsolationLevel
Status: Closed Type: Incident
Severity: Minor Priority: Medium
Subsystem: Connection Resolution: Not_A_Bug
Last Modified: 2012-03-01 19:30:58
Version Found In: 1.0.79.0
Description:
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 = "***"


mistachkin added on 2012-03-01 19:30:58 UTC:
The "ReadUncommitted" isolation level is not supported by System.Data.SQLite. The issue you are seeing has nothing to do with the SQLiteConnectionStringBuilder class.