public void RemoveTracklistItemWithIds(int trackId, int trackCollectionId) { using (connection.Lock()) { connection.Execute("DELETE FROM TracklistItem WHERE TrackCollectionId=? AND TrackId=?;", trackCollectionId, trackId); } }
public void Clear() { using (connection.Lock()) { connection.Execute($"DELETE FROM {nameof(BackgroundTrackItem)}"); } }
public void Execute(string query, params object[] args) { using (Connection.Lock()) { Connection.Execute(query, args); } }
public void RemoveRecipe(int id) { if (_isDisposed) { throw new ObjectDisposedException(nameof(RecipePersistenceService)); } using (_connection.Lock()) { _connection.RunInTransaction(() => { //Remove all fields var mapping = _connection.GetMapping <RecipeTextFieldRow>(); _connection.Execute($"DELETE FROM {mapping.TableName} WHERE RecipeId = ?", id); //Remove recipe _connection.Delete <RecipeRow>(id); }); } }
public Task <int> ExecuteAsync(string query, params object[] args) { if (query == null) { throw new ArgumentNullException("query"); } if (args == null) { throw new ArgumentNullException("args"); } return(Task.Factory.StartNew(() => { SQLiteConnectionWithLock conn = GetConnection(); using (conn.Lock()) { return conn.Execute(query, args); } }, CancellationToken.None, _taskCreationOptions, _taskScheduler ?? TaskScheduler.Default)); }
public Task <int> ExecuteAsync(string query, params object[] args) { if (query == null) { throw new ArgumentNullException("query"); } if (args == null) { throw new ArgumentNullException("args"); } return(_taskFactory.StartNew(() => { SQLiteConnectionWithLock conn = GetConnection(); using (conn.Lock()) { return conn.Execute(query, args); } })); }