ElegantCode

Using TransactionScope with SQLite

Earlier this week I ran into a little quirk with SQLite. Take a look at the following code snippet: using(var transaction = new TransactionScope(TransactionScopeOption.Required)) { using(var connection1 = new SQLiteConnection(_connectionString)) { connection1.Open(); … // Do stuff with the open connection } // Closes the connection (so we think …) using(var connection2 = new SQLiteConnection(_connectionString)) { […]