public async Task DeleteData(int tableId, int deletingRowId)
{
var tableMeta = _dbContext.TableInfos.Where(x => x.Id == tableId)
.Include(x => x.FieldInfos).First();
if (tableMeta == null)
{
throw new TableNotFoundException(tableId);
}
var table = _mapper.Map <Table>(tableMeta);
var deleteQuery = _commandDirector.BuildDeleteCommand(table, deletingRowId);
await _dbContext.ExcecuteSqlQueryAsync(deleteQuery);
}
public void TestCreateDeleteCommandWithCondition()
{
var sqlQuery = _crudCommandDirector.BuildDeleteCommand(_table, 0);
Assert.Equal("DELETE FROM data.Car WHERE gid = '0'", sqlQuery);
}
