protected void RunDefaultInitialization(IDatabaseConnection db) { var queries = new List <string> { "PRAGMA journal_mode=WAL", "PRAGMA page_size=4096", "PRAGMA synchronous=Normal" }; if (EnableTempStoreMemory) { queries.AddRange(new List <string> { "pragma default_temp_store = memory", "pragma temp_store = memory" }); } else { queries.AddRange(new List <string> { "pragma temp_store = file" }); } db.ExecuteAll(string.Join(";", queries.ToArray())); }
public static void RunQueries(this IDatabaseConnection db, string[] queries) { db.BeginTransaction(TransactionMode.Deferred); try { db.ExecuteAll(string.Join(";", queries)); db.CommitTransaction(); } catch (Exception) { db.RollbackTransaction(); throw; } }