public void CallDecimalProcedureWithValuesIncorrectPrecision_ThrowsSqlParameterOutOfRangeException()
{
// ARRANGE
const decimal initialValue = 1234567.123M;
var parameters = new DecimalPrecisionAndScaleStoredProcedure.Parameter
{
Value1 = initialValue,
Value2 = initialValue
};
var procedure = new DecimalPrecisionAndScaleStoredProcedure(parameters);
// ACT
Context.ExecuteStoredProcedure(procedure);
// ASSERT
Assert.Fail();
}
public void CallDecimalProcedureWithIncorrectScale_ThrowsSqlParameterOutOfRangeException()
{
// ARRANGE
const decimal initialValue1 = 1234567.891M;
const decimal initialValue2 = 12345.67M;
var parameters = new DecimalPrecisionAndScaleStoredProcedure.Parameter
{
Value1 = initialValue1,
Value2 = initialValue2
};
var procedure = new DecimalPrecisionAndScaleStoredProcedure(parameters);
// ACT
Connection.ExecuteStoredProcedure(procedure);
// ASSERT
Assert.Fail();
}
public void CallDecimalProcedureWithValuesCorrectPrecisionAndScale_ResultsInNoLossOfData()
{
// ARRANGE
const decimal initialValue1 = 1234567.123M;
const decimal initialValue2 = 123456.7M;
var parameters = new DecimalPrecisionAndScaleStoredProcedure.Parameter
{
Value1 = initialValue1,
Value2 = initialValue2
};
var procedure = new DecimalPrecisionAndScaleStoredProcedure(parameters);
// ACT
var results = Context.ExecuteStoredProcedure(procedure);
var result = results.FirstOrDefault();
// ASSERT
Assert.IsNotNull(result);
Assert.AreEqual(initialValue1, result.Value1);
Assert.AreEqual(initialValue2, result.Value2);
}
