public void ExecuteStoredProcedure_WhenNotAlreadyOpened_ClosesConnection() { // ARRANGE const int expectedId = 10; var parameters = new ParametersAndReturnTypeStoredProcedure.Parameter() { Id = expectedId }; var procedure = new ParametersAndReturnTypeStoredProcedure(parameters); // ACT Connection.ExecuteStoredProcedure(procedure); var connectionStillOpen = Connection.State == ConnectionState.Open; // ASSERT Assert.IsFalse(connectionStillOpen); }
public void NormalStoredProcedure_WhenCalledOnSqlConnection_ReturnsCorrectValues() { // ARRANGE const int expectedId = 10; const string expectedName = @"Dave"; const bool expectedActive = true; var parameters = new ParametersAndReturnTypeStoredProcedure.Parameter() { Id = expectedId }; var procedure = new ParametersAndReturnTypeStoredProcedure(parameters); // ACT Connection.Open(); var resultList = Connection.ExecuteStoredProcedure(procedure); Connection.Close(); var result = resultList.First(); // ASSERT Assert.AreEqual(expectedId, result.Id); Assert.AreEqual(expectedName, result.Name); Assert.AreEqual(expectedActive, result.Active); }