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);
}
}));
}
