public void SP_QueryUser()
{
SqlParameterCollection dbParameterCollection = new SqlParameterCollection();
dbParameterCollection.Add(new SqlParameter("Total", null, typeof(int))
{
DbType = System.Data.DbType.Int32,
Direction = System.Data.ParameterDirection.Output
});
var list = _userRepository.SP_QueryUser(dbParameterCollection);
Assert.NotNull(list);
dbParameterCollection.TryGetParameterValue("Total", out int total);
Assert.NotEqual(0, total);
}
public void SP()
{
SqlParameterCollection dbParameterCollection = new SqlParameterCollection();
dbParameterCollection.Add(new SqlParameter("Total", null, typeof(int))
{
DbType = System.Data.DbType.Int32,
Direction = System.Data.ParameterDirection.Output
});
RequestContext context = new RequestContext
{
CommandType = System.Data.CommandType.StoredProcedure,
RealSql = "SP_QueryUser",
Request = dbParameterCollection
};
var list = DbSession.Query <User>(context);
dbParameterCollection.TryGetParameterValue("Total", out int total);
}
public void SP()
{
SqlParameterCollection dbParameterCollection = new SqlParameterCollection();
dbParameterCollection.Add(new SqlParameter
{
Name = "Total",
DbType = System.Data.DbType.Int32,
Direction = System.Data.ParameterDirection.Output
});
RequestContext context = new RequestContext
{
CommandType = System.Data.CommandType.StoredProcedure,
RealSql = "SP_Query",
Request = dbParameterCollection
};
var list = SqlMapper.Query <AllPrimitive>(context);
dbParameterCollection.TryGetParameterValue("Total", out int total);
}
public void SP_SourceParameter()
{
SqlParameterCollection dbParameterCollection = new SqlParameterCollection();
dbParameterCollection.Add(new SqlParameter("Total", null)
{
SourceParameter = new Microsoft.Data.SqlClient.SqlParameter("Total", DbType.Int32)
{
Direction = ParameterDirection.Output
}
});
RequestContext context = new RequestContext
{
CommandType = CommandType.StoredProcedure,
RealSql = "SP_QueryUser",
Request = dbParameterCollection
};
var list = SqlMapper.Query <User>(context);
dbParameterCollection.TryGetParameterValue("Total", out int total);
}
public void SP_SourceParameter()
{
SqlParameterCollection dbParameterCollection = new SqlParameterCollection();
dbParameterCollection.Add(new SqlParameter("Total", null)
{
SourceParameter = new MySqlParameter("Total", DbType.Int32)
{
Direction = ParameterDirection.Output
}
});
RequestContext context = new RequestContext
{
CommandType = CommandType.StoredProcedure,
RealSql = "SP_Query",
Request = dbParameterCollection
};
var list = SqlMapper.Query <AllPrimitive>(context);
Assert.NotNull(list);
dbParameterCollection.TryGetParameterValue("Total", out int total);
}