public void TwoRows()
{
var tableName = ObjectName.Parse("APP.test_table");
var expr = SqlExpression.Parse("last_name = 'Provenzano'");
var count = AdminQuery.Delete(tableName, expr);
Assert.AreEqual(2, count);
var table = AdminQuery.Access().GetTable(tableName);
Assert.AreEqual(0, table.RowCount);
}
public void OnlyOneRow()
{
var tableName = ObjectName.Parse("APP.test_table");
var expr = SqlExpression.Parse("first_name = 'Antonello'");
var count = AdminQuery.Delete(tableName, expr);
Assert.AreEqual(1, count);
var table = AdminQuery.Access().GetTable(tableName);
Assert.AreEqual(1, table.RowCount);
}