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