public void ExecuteTwoRowsDynamic_Test() { using (var cmd = new DatabaseCommand(_connection)) { cmd.Log = Console.WriteLine; cmd.CommandText = " SELECT EMPNO, ENAME, HIREDATE, COMM FROM EMP WHERE EMPNO = 7369"; var emp1 = cmd.ExecuteRow <dynamic>(); cmd.Clear(); cmd.CommandText = " SELECT EMPNO, ENAME, HIREDATE, COMM FROM EMP WHERE EMPNO = 7499"; var emp2 = cmd.ExecuteRow <dynamic>(); Assert.AreEqual(7369, emp1.EMPNO); Assert.AreEqual("SMITH", emp1.ENAME); Assert.AreEqual(new DateTime(1980, 12, 17), emp1.HIREDATE); Assert.AreEqual(null, emp1.COMM); Assert.AreEqual(7499, emp2.EMPNO); Assert.AreEqual("ALLEN", emp2.ENAME); Assert.AreEqual(new DateTime(1981, 02, 20), emp2.HIREDATE); Assert.AreEqual(300, emp2.COMM); } }