public void SingleResultStubDataReaderReturnsCorrectValues()
{
DateTime testDate = DateTime.Now;
StubResultSet resultSet = new StubResultSet("col0", "col1", "col2");
resultSet.AddRow(1, "Test", testDate);
resultSet.AddRow(2, "Test2", testDate.AddDays(1));
StubDataReader reader = new StubDataReader(resultSet);
//Advance to first row.
Assert.IsTrue(reader.Read(), "Expected data.");
Assert.AreEqual(1, reader["col0"], "Misread row 0, col 0.");
Assert.AreEqual("Test", reader["col1"], "Misread row 0, col 1.");
Assert.AreEqual(testDate, reader["col2"], "Misread row 0, col 3.");
Assert.AreEqual(1, reader.GetInt32(0), "Misread row 0, col 0.");
Assert.AreEqual("Test", reader.GetString(1), "Misread row 0, col 1.");
Assert.AreEqual(testDate, reader.GetDateTime(2), "Misread row 0, col 3.");
Assert.AreEqual(1, reader[0], "Misread row 0, col 0.");
Assert.AreEqual("Test", reader[1], "Misread row 0, col 1.");
Assert.AreEqual(testDate, reader[2], "Misread row 0, col 3.");
//Advance to second row.
Assert.IsTrue(reader.Read(), "Expected data.");
Assert.AreEqual(2, reader.GetInt32(0), "Misread row 1, col 0.");
Assert.AreEqual("Test2", reader.GetString(1), "Misread row 1, col 1.");
Assert.AreEqual(testDate.AddDays(1), reader.GetDateTime(2), "Misread row 1, col 3.");
Assert.AreEqual(2, reader[0], "Misread row 1, col 0.");
Assert.AreEqual("Test2", reader[1], "Misread row 1, col 1.");
Assert.AreEqual(testDate.AddDays(1), reader[2], "Misread row 1, col 3.");
Assert.AreEqual(2, reader["col0"], "Misread row 1, col 0.");
Assert.AreEqual("Test2", reader["col1"], "Misread row 1, col 1.");
Assert.AreEqual(testDate.AddDays(1), reader["col2"], "Misread row 1, col 3.");
}
public void MultipleResultStubDataReaderReturnsCorrectValues()
{
DateTime testDate = DateTime.Now;
StubResultSet resultSet = new StubResultSet("col0", "col1", "col2");
resultSet.AddRow(1, "Test", testDate);
StubResultSet anotherResultSet = new StubResultSet("first", "second");
anotherResultSet.AddRow((decimal)1.618, "Foo");
anotherResultSet.AddRow((decimal)2.718, "Bar");
anotherResultSet.AddRow((decimal)3.142, "Baz");
StubDataReader reader = new StubDataReader(resultSet, anotherResultSet);
//Advance to first row.
Assert.IsTrue(reader.Read(), "Expected data.");
Assert.AreEqual(1, reader["col0"]);
//Advance to second ResultSet.
Assert.IsTrue(reader.NextResult(), "Expected next result set");
//Advance to first row.
Assert.IsTrue(reader.Read(), "Expected data.");
Assert.AreEqual((decimal)1.618, reader["first"]);
Assert.AreEqual("Foo", reader["second"]);
Assert.IsTrue(reader.Read(), "Expected data.");
Assert.AreEqual((decimal)2.718, reader["first"]);
Assert.AreEqual("Bar", reader["second"]);
Assert.IsTrue(reader.Read(), "Expected data.");
Assert.AreEqual((decimal)3.142, reader["first"]);
Assert.AreEqual("Baz", reader["second"]);
}