public void GetValueFromOutputParameter()
{
//ARRANGE
const string text = "testText";
const string duplicateText = "testTexttestText";
const string queryText = "exec dbo.spDuplicateString @text out";
var parameter = new SpecifiedParameter("@text", text, direction: ParameterDirection.InputOutput, size: 128);
var query = _queryFactory.CreateQuery();
//ACT
query.Execute(queryText, parameter);
//ASSERT
Assert.AreEqual(duplicateText, parameter.GetOutputValue <string>());
query.Dispose();
}
public void GetOutputValue_ShouldReturnValueFromDataParameter()
{
//ARRANGE
const string parameterName = "testParameterName";
var parameter = new SpecifiedParameter(parameterName);
const int value = 5;
IDbDataParameter dataParameter = A.Fake <IDbDataParameter>();
dataParameter.CallsTo(x => x.Value)
.Returns(value);
//ACT
parameter.SetParameter(dataParameter);
var valueFromParameter = parameter.GetOutputValue <int>();
//ASSERT
Assert.AreEqual(value, valueFromParameter);
dataParameter.CallsTo(x => x.Value)
.MustHaveHappened(Repeated.Exactly.Once);
}