public async Task ExecuteNonQueryAsync_NoData_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
cmd.Log = Console.WriteLine;
cmd.CommandText.AppendLine(" DELETE FROM EMP WHERE EMPNO = 99999 ");
var count = await cmd.ExecuteNonQueryAsync();
Assert.AreEqual(0, count);
}
}
public async Task ExecuteNonQueryAsync_Transaction_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
cmd.Log = Console.WriteLine;
cmd.CommandText.AppendLine(" DELETE FROM EMP ");
cmd.TransactionBegin();
int count = await cmd.ExecuteNonQueryAsync();
cmd.TransactionRollback();
Assert.AreEqual(14, count);
Assert.AreEqual(14, EMP.GetEmployeesCount(_connection));
}
}
