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