protected void Execute <T>(RemoveQuery <T> query, Action action = null)
where T : DataRecord
{
var item = query.CreateWork(action);
Client.EnqueueWork(item);
}
protected void BlockingExecute <T>(RemoveQuery <T> query)
where T : DataRecord
{
requireDbLockAccess();
lock (_L_databaseSync)
{
Execute(query, unlockDbAction);
//wait until query is finished
Monitor.Wait(_L_databaseSync);
}
}
public override void RemoveRows <ActiveRecord>(DataTable <ActiveRecord> table, RemoveQuery <ActiveRecord> query, Action executor)
{
enqueueWork((w) =>
{
w.RemoveRows(table, query, executor);
});
}
public override void RemoveRows <ActiveRecord>(DataTable <ActiveRecord> table, RemoveQuery <ActiveRecord> query, Action executor)
{
ExecuteRows(table, query.Select, (res) =>
{
foreach (var row in res.Rows)
{
table.MemoryRecords.Remove(row.ID);
}
});
executor();
}
public Task <RemoveResult> RemoveUserProps([FromBody] RemoveQuery model)
{
return(_mediator.Send <RemoveResult>(model));
}
public override void RemoveRows <ActiveRecord>(DataTable <ActiveRecord> table, RemoveQuery <ActiveRecord> query, Action executor)
{
var queryCmd = getQuery();
queryCmd.AppendFormat("DELETE FROM {0} WHERE ", table.Name);
appendCondition(queryCmd, query.Select.Condition);
queryCmd.ExecuteNonQuery();
executor();
}
