public void MultipleRecordSetStoredDynamiccolumProcedure_WithThreeSelects_ReturnsCorrectDataValues()
{
// ARRANGE
var procedure = new MultipleRecordSetDynamicColumnStoredProcedure();
// ACT
var resultSet = Connection.ExecuteStoredProcedure(procedure);
var results1 = resultSet.RecordSet1;
var result1 = results1.First() as dynamic;
var results2 = resultSet.RecordSet2;
var result2 = results2.First() as dynamic;
var results3 = resultSet.RecordSet3;
var result3 = results3.First() as dynamic;
// ASSERT
Assert.IsNotNull(result1);
Assert.AreEqual("Dave", result1.Firstname);
Assert.AreEqual("Smith", result1.Surname);
Assert.AreEqual(32, result1.Age);
Assert.IsNotNull(result2);
Assert.AreEqual(true, result2.Active);
Assert.AreEqual(10.99, Math.Round(((double)result2.Price), 2));
Assert.IsNotNull(result3);
Assert.AreEqual(1, result3.Count);
}
public void MultipleRecordSetStoredDynamiccolumProcedure_WithThreeSelects_ReturnsCorrectDataTypes()
{
// ARRANGE
var procedure = new MultipleRecordSetDynamicColumnStoredProcedure();
// ACT
var resultSet = Connection.ExecuteStoredProcedure(procedure);
var results1 = resultSet.RecordSet1;
var result1 = results1.First() as dynamic;
var results2 = resultSet.RecordSet2;
var result2 = results2.First() as dynamic;
var results3 = resultSet.RecordSet3;
var result3 = results3.First() as dynamic;
// ASSERT
Assert.IsNotNull(result1);
Assert.IsInstanceOfType(result1.Firstname, typeof(string));
Assert.IsInstanceOfType(result1.Age, typeof(int));
Assert.IsInstanceOfType(result1.DateOfBirth, typeof(DateTime));
Assert.IsNotNull(result2);
Assert.IsInstanceOfType(result2.Active, typeof(bool));
Assert.IsInstanceOfType(result2.Price, typeof(decimal));
Assert.IsNotNull(result3);
Assert.IsInstanceOfType(result3.UniqueIdentifier, typeof(Guid));
Assert.IsInstanceOfType(result3.Count, typeof(int));
}
public void MultipleRecordSetStoredDynamiccolumProcedure_WithThreeSelects_ReturnsThreeRecordSets()
{
// ARRANGE
var procedure = new MultipleRecordSetDynamicColumnStoredProcedure();
// ACT
var resultSet = Connection.ExecuteStoredProcedure(procedure);
var results1 = resultSet.RecordSet1;
var results2 = resultSet.RecordSet2;
var results3 = resultSet.RecordSet3;
// ASSERT
Assert.IsNotNull(results1);
Assert.IsNotNull(results2);
Assert.IsNotNull(results3);
}
