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 QueryDynamic_WithAnonymousParams_Executes() { dynamic result; using (var c = _dataAndSchema.GetConnection()) { var dapper = new SqlMapperWrapper(c); c.Open(); var args = 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 QueryTyped_WithDynamicParams_Executes() { EntityBar 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<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); } }