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); } }