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