public async Task ExecuteSystemDataSetAsync_CountForTableName_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
cmd.Log = Console.WriteLine;
cmd.CommandText = @" SELECT DEPTNO, COUNT(*) FROM EMP GROUP BY DEPTNO ";
var dataset = await cmd.ExecuteDataSetAsync();
Assert.AreEqual("EMP", dataset.Tables[0].TableName);
}
}
public async Task ExecuteSystemDataSetAsync_TableNames_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
cmd.Log = Console.WriteLine;
cmd.CommandText.AppendLine(" SELECT EMPNO FROM EMP "); // With rows
cmd.CommandText.AppendLine(" SELECT DEPTNO FROM DEPT WHERE DEPTNO = 0 "); // No rows
var dataset = await cmd.ExecuteDataSetAsync();
Assert.AreEqual("EMP", dataset.Tables[0].TableName);
Assert.AreEqual("DEPT", dataset.Tables[1].TableName);
}
}
public async Task ExecuteDataSetAsync_NoData_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
cmd.Log = Console.WriteLine;
cmd.CommandText.AppendLine(" SELECT EMPNO, ENAME FROM EMP WHERE EMPNO = 99999");
cmd.CommandText.AppendLine(" SELECT * FROM DEPT WHERE DEPTNO = 99999");
var data = await cmd.ExecuteDataSetAsync <EMP, DEPT>();
Assert.AreEqual(0, data.Item1.Count());
Assert.AreEqual(0, data.Item2.Count());
}
}
public async Task ExecuteSystemDataSetAsync_JoinForTableName_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
cmd.Log = Console.WriteLine;
cmd.CommandText = @" SELECT EMP.ENAME,
DEPT.DNAME
FROM EMP
INNER JOIN DEPT ON DEPT.DEPTNO = EMP.DEPTNO ";
var dataset = await cmd.ExecuteDataSetAsync();
Assert.AreEqual("Table1", dataset.Tables[0].TableName);
}
}
public async Task ExecuteSystemDataSetAsync_OneTable_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
cmd.Log = Console.WriteLine;
cmd.CommandText.AppendLine(" SELECT EMPNO, ENAME FROM EMP ");
var dataset = await cmd.ExecuteDataSetAsync();
var smith = dataset.Tables[0].Rows[0];
Assert.AreEqual(EMP.Smith.EmpNo, smith["EmpNo"]);
Assert.AreEqual(EMP.Smith.EName, smith["EName"]);
}
}
public async Task ExecuteDataSetAsync_2Types_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
string sql = " SELECT EMPNO, ENAME FROM EMP; ";
cmd.Log = Console.WriteLine;
cmd.CommandText.AppendLine(sql);
cmd.CommandText.AppendLine(sql);
var data = await cmd.ExecuteDataSetAsync <EMP, EMP>();
Assert.AreEqual(14, data.Item1.Count());
Assert.AreEqual(14, data.Item2.Count());
}
}
public async Task ExecuteDataSetAsync_2AnonymousTypes_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
string sql = " SELECT EMPNO, ENAME FROM EMP; ";
var emp = new { Empno = 0, Ename = "" };
cmd.Log = Console.WriteLine;
cmd.CommandText.AppendLine(sql);
cmd.CommandText.AppendLine(sql);
var data = await cmd.ExecuteDataSetAsync(emp, emp);
Assert.AreEqual(14, data.Item1.Count());
Assert.AreEqual(14, data.Item2.Count());
}
}
public async Task ExecuteDataSetTyped_Test()
{
using (var cmd = new DatabaseCommand(_connection))
{
cmd.Log = Console.WriteLine;
cmd.CommandText.AppendLine(" SELECT EMPNO, ENAME FROM EMP ");
cmd.CommandText.AppendLine(" SELECT * FROM DEPT ");
var data = await cmd.ExecuteDataSetAsync <EMP, DEPT>();
var smith = data.Item1.FirstOrDefault(i => i.EmpNo == 7369);
var accounting = data.Item2.FirstOrDefault(i => i.DeptNo == 10);
Assert.AreEqual(EMP.Smith.EmpNo, smith.EmpNo);
Assert.AreEqual(EMP.Smith.EName, smith.EName);
Assert.AreEqual(DEPT.Accounting.DName, accounting.DName);
Assert.AreEqual(DEPT.Accounting.Loc, accounting.Loc);
}
}