private void DisposeConnection() { try { lock (_disposeLock) { using (WriteLock.Write()) { if (_connection != null) { using (_connection) { _connection.Close(); } _connection = null; } CloseConnection(); } } } catch (Exception ex) { Logger.LogError(ex, "Error disposing database"); } }
protected ManagedConnection CreateConnection(bool isReadOnly = false) { if (_connection != null) { return(_connection); } lock (WriteLock) { if (!_versionLogged) { _versionLogged = true; Logger.LogInformation("Sqlite version: " + SQLite3.Version); Logger.LogInformation("Sqlite compiler options: " + string.Join(",", SQLite3.CompilerOptions.ToArray())); } ConnectionFlags connectionFlags; if (isReadOnly) { //Logger.LogInformation("Opening read connection"); //connectionFlags = ConnectionFlags.ReadOnly; connectionFlags = ConnectionFlags.Create; connectionFlags |= ConnectionFlags.ReadWrite; } else { //Logger.LogInformation("Opening write connection"); connectionFlags = ConnectionFlags.Create; connectionFlags |= ConnectionFlags.ReadWrite; } if (EnableSingleConnection) { connectionFlags |= ConnectionFlags.PrivateCache; } else { connectionFlags |= ConnectionFlags.SharedCached; } connectionFlags |= ConnectionFlags.NoMutex; var db = SQLite3.Open(DbFilePath, connectionFlags, null); try { if (string.IsNullOrWhiteSpace(_defaultWal)) { _defaultWal = db.Query("PRAGMA journal_mode").SelectScalarString().First(); Logger.LogInformation("Default journal_mode for {0} is {1}", DbFilePath, _defaultWal); } var queries = new List <string> { //"PRAGMA cache size=-10000" //"PRAGMA read_uncommitted = true", "PRAGMA synchronous=Normal" }; if (CacheSize.HasValue) { queries.Add("PRAGMA cache_size=" + CacheSize.Value.ToString(CultureInfo.InvariantCulture)); } if (EnableTempStoreMemory) { queries.Add("PRAGMA temp_store = memory"); } else { queries.Add("PRAGMA temp_store = file"); } foreach (var query in queries) { db.Execute(query); } } catch { using (db) { } throw; } _connection = new ManagedConnection(db, false); return(_connection); } }