Index: Riskeer/Storage/src/Riskeer.Storage.Core/StorageSqliteCreator.cs =================================================================== diff -u -rf832d4da5c9a3a96a075f69ddee5421ad6046e21 -rec93edc085bd84feaa02dce4b50bf53c37253903 --- Riskeer/Storage/src/Riskeer.Storage.Core/StorageSqliteCreator.cs (.../StorageSqliteCreator.cs) (revision f832d4da5c9a3a96a075f69ddee5421ad6046e21) +++ Riskeer/Storage/src/Riskeer.Storage.Core/StorageSqliteCreator.cs (.../StorageSqliteCreator.cs) (revision ec93edc085bd84feaa02dce4b50bf53c37253903) @@ -63,10 +63,13 @@ using (var dbContext = new SQLiteConnection(connectionString, true)) { dbContext.Open(); + using (SQLiteTransaction transaction = dbContext.BeginTransaction()) using (SQLiteCommand command = dbContext.CreateCommand()) { command.CommandText = Resources.DatabaseStructure; command.ExecuteNonQuery(); + + transaction.Commit(); } } } Index: Riskeer/Storage/test/Riskeer.Storage.Core.TestUtil/SqLiteDatabaseHelper.cs =================================================================== diff -u -r0cc69844d7123adac5c3cf5d43769d37186536b0 -rec93edc085bd84feaa02dce4b50bf53c37253903 --- Riskeer/Storage/test/Riskeer.Storage.Core.TestUtil/SqLiteDatabaseHelper.cs (.../SqLiteDatabaseHelper.cs) (revision 0cc69844d7123adac5c3cf5d43769d37186536b0) +++ Riskeer/Storage/test/Riskeer.Storage.Core.TestUtil/SqLiteDatabaseHelper.cs (.../SqLiteDatabaseHelper.cs) (revision ec93edc085bd84feaa02dce4b50bf53c37253903) @@ -155,17 +155,19 @@ using (var dbContext = new SQLiteConnection(connectionString, true)) { dbContext.Open(); + using (SQLiteTransaction transaction = dbContext.BeginTransaction()) using (SQLiteCommand command = dbContext.CreateCommand()) { try { command.CommandText = commandText; command.ExecuteNonQuery(); + + transaction.Commit(); } finally { SQLiteConnection.ClearAllPools(); - dbContext.Close(); } } }