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 QueryMultiple_WithDynamicParams_Executes()
{
List <EntityFoo> secondResult;
List <EntityBar> result;
using (var c = _dataAndSchema.GetConnection())
{
c.Open();
var args = new { val = _dataAndSchema.Value.ToString() };
var reader = new SqlMapperWrapper(c).QueryMultiple(
SqlDataAndSchema.SprocNameDapperSingleInMultipleResultSets,
args,
commandType: CommandType.StoredProcedure);
secondResult = reader.Read <EntityFoo>().ToList();
result = reader.Read <EntityBar>().ToList();
}
Assert.IsNotNull(result);
Assert.IsTrue(result.Any());
Assert.IsNotNull(secondResult);
Assert.IsTrue(secondResult.Count() > 1);
}
public void QueryDynamic_WithDynamicParams_Executes()
{
dynamic result;
using (var c = _dataAndSchema.GetConnection())
{
var dapper = new SqlMapperWrapper(c);
c.Open();
var args = new DynamicParameters(new { val = _dataAndSchema.Value.ToString() });
result = dapper.Query<dynamic>(
SqlDataAndSchema.SprocNameDapperSingleInParam,
args,
commandType: CommandType.StoredProcedure).FirstOrDefault();
}
Assert.IsNotNull(result);
}
public void QueryDynamic_WithDynamicParams_Executes()
{
dynamic result;
using (var c = _dataAndSchema.GetConnection())
{
var dapper = new SqlMapperWrapper(c);
c.Open();
var args = new DynamicParameters(new { val = _dataAndSchema.Value.ToString() });
result = dapper.Query <dynamic>(
SqlDataAndSchema.SprocNameDapperSingleInParam,
args,
commandType: CommandType.StoredProcedure).FirstOrDefault();
}
Assert.IsNotNull(result);
}
public void QueryTyped_WithAnonymousParams_Executes()
{
EntityBar result;
using (var c = _dataAndSchema.GetConnection())
{
var dapper = new SqlMapperWrapper(c);
c.Open();
var args = new { val = _dataAndSchema.Value.ToString() };
result = dapper.Query <EntityBar>(
SqlDataAndSchema.SprocNameDapperSingleInParam,
args,
commandType: CommandType.StoredProcedure).SingleOrDefault();
}
Assert.IsNotNull(result);
}
public void QueryMultiple_WithDynamicParams_Executes()
{
List<EntityFoo> secondResult;
List<EntityBar> result;
using (var c = _dataAndSchema.GetConnection())
{
c.Open();
var args = new { val = _dataAndSchema.Value.ToString() };
var reader = new SqlMapperWrapper(c).QueryMultiple(
SqlDataAndSchema.SprocNameDapperSingleInMultipleResultSets,
args,
commandType: CommandType.StoredProcedure);
secondResult = reader.Read<EntityFoo>().ToList();
result = reader.Read<EntityBar>().ToList();
}
Assert.IsNotNull(result);
Assert.IsTrue(result.Any());
Assert.IsNotNull(secondResult);
Assert.IsTrue(secondResult.Count() > 1);
}
public void QueryTyped_WithAnonymousParams_Executes()
{
EntityBar result;
using (var c = _dataAndSchema.GetConnection())
{
var dapper = new SqlMapperWrapper(c);
c.Open();
var args = new { val = _dataAndSchema.Value.ToString() };
result = dapper.Query<EntityBar>(
SqlDataAndSchema.SprocNameDapperSingleInParam,
args,
commandType: CommandType.StoredProcedure).SingleOrDefault();
}
Assert.IsNotNull(result);
}
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);
}
}
