public void NormalStoredProcedure_WhenCalledOnSqlConnection_ReturnsCorrectValues()
{
// ARRANGE
const int expectedId = 10;
const string expectedName = @"Dave";
const bool expectedActive = true;
var parameters = new NormalStoredProcedureParameters
{
Id = expectedId
};
List<NormalStoredProcedureReturnType> results;
var procedure = new NormalStoredProcedure(parameters);
var connectionString = ConfigurationManager.ConnectionStrings["IntegrationTestConnection"].ConnectionString;
// ACT
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
results = connection.ExecuteStoredProcedure(procedure);
}
var result = results.First();
// ASSERT
Assert.AreEqual(expectedId, result.Id);
Assert.AreEqual(expectedName, result.Name);
Assert.AreEqual(expectedActive, result.Active);
}
public void NormalStoredProcedure_WhenCalledOnDbContext_ReturnsCorrectValues()
{
// ARRANGE
const int expectedId = 10;
const string expectedName = @"Dave";
const bool expectedActive = true;
var parameters = new NormalStoredProcedureParameters
{
Id = expectedId
};
var procedure = new NormalStoredProcedure(parameters);
// ACT
var results = Context.ExecuteStoredProcedure(procedure);
var result = results.First();
// ASSERT
Assert.AreEqual(expectedId, result.Id);
Assert.AreEqual(expectedName, result.Name);
Assert.AreEqual(expectedActive, result.Active);
}
public void Parameters_WhenSuppliedProcedureHasParametersAndUsingFluidApi_ParametersAreNull()
{
// ARRANGE
const int expectedParameterCount = 1;
const int expectedValue = 1;
var parameters = new NormalStoredProcedureParameters
{
Id = 1
};
var procedure = new NormalStoredProcedure(parameters);
// ACT
var actualParameters = new StoredProcedureSqlParameterBuilder<List<NormalStoredProcedureRecordSetReturnType>, NormalStoredProcedureParameters>(procedure)
.BuildSqlParameters()
.SqlParameters;
// ASSERT
Assert.AreEqual(expectedParameterCount, actualParameters.Count);
Assert.AreEqual(expectedValue, actualParameters.First().Value);
}
public void HasNullStoredProcedureParameters_WhenProceduredDoesNotHaveNullStoredProcedureParameters_ReturnsFalse()
{
// ARRANGE
var parameters = new NormalStoredProcedureParameters { Id = 1 };
var procedure = new NormalStoredProcedure(parameters);
// ACT
var actualresult = procedure.HasNullStoredProcedureParameters;
// ASSERT
Assert.IsFalse(actualresult);
}
