public async Task ExecuteRowPrimitive_Test() { using (var cmd = new DatabaseCommand(_connection)) { cmd.Log = Console.WriteLine; cmd.CommandText = "SELECT EMPNO FROM EMP WHERE EMPNO = 7369"; int emp = await cmd.ExecuteRowAsync <int>(); Assert.AreEqual(7369, emp); } }
public async Task ExecuteRowTyped_Test() { using (var cmd = new DatabaseCommand(_connection)) { cmd.Log = Console.WriteLine; cmd.CommandText = "SELECT * FROM EMP WHERE EMPNO = 7369"; EMP emp = await cmd.ExecuteRowAsync <EMP>(); Assert.AreEqual(7369, emp.EmpNo); } }
public async Task ExecuteRowAnonymous_Test() { using (var cmd = new DatabaseCommand(_connection)) { cmd.Log = Console.WriteLine; cmd.CommandText = "SELECT EName, Empno FROM EMP WHERE EMPNO = 7369"; var emp = await cmd.ExecuteRowAsync(new { EName = default(string), Empno = default(int) }); Assert.AreEqual(7369, emp.Empno); } }
public async Task ExecuteRowFunction_Test() { using (var cmd = new DatabaseCommand(_connection)) { cmd.Log = Console.WriteLine; cmd.CommandText = "SELECT EName, Empno FROM EMP WHERE EMPNO = 7369"; var emp = await cmd.ExecuteRowAsync(row => { return(new { Empno = row.Field <int>("Empno") }); }); Assert.AreEqual(7369, emp.Empno); } }