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