public void QueryTyped_WithAnonymousParamsAndOutParam_Executes()
{
using (var c = _dataAndSchema.GetConnection())
{
c.Open();
var w = new SqlMapperWrapper(c);
IParametersFactory fact = new ParametersFactory();
var args = fact.CreateInstance(new { Val = _dataAndSchema.Value.ToString() });
args.Add("@affected", null, DbType.Int32, ParameterDirection.InputOutput);
var result = w.Query <EntityBar>(
SqlDataAndSchema.SprocNameDapperSingleInSingleOutParam,
args,
commandType: CommandType.StoredProcedure).ToList();
var outparam = args.Get <int>("@affected");
Assert.IsNotNull(result);
Assert.IsTrue(result.Count() == 1);
Assert.IsTrue(outparam == 1);
}
}
public void QueryTyped_WithAnonymousParamsAndOutParam_Executes()
{
using (var c = _dataAndSchema.GetConnection())
{
c.Open();
var w = new SqlMapperWrapper(c);
IParametersFactory fact = new ParametersFactory();
var args = fact.CreateInstance(new {Val = _dataAndSchema.Value.ToString()});
args.Add("@affected", null, DbType.Int32, ParameterDirection.InputOutput);
var result = w.Query<EntityBar>(
SqlDataAndSchema.SprocNameDapperSingleInSingleOutParam,
args,
commandType: CommandType.StoredProcedure).ToList();
var outparam = args.Get<int>("@affected");
Assert.IsNotNull(result);
Assert.IsTrue(result.Count() == 1);
Assert.IsTrue(outparam == 1);
}
}
