public void SP_QueryByPage_From_RealSql()
{
DbParameterCollection dbParameterCollection = new DbParameterCollection();
dbParameterCollection.Add(new DbParameter
{
Name = "Total",
DbType = System.Data.DbType.Int32,
Direction = System.Data.ParameterDirection.Output
});
var list = _repository.SP_QueryByPage_From_RealSql(dbParameterCollection);
var total = dbParameterCollection.GetValue <int>("Total");
}
public void StoredProcedure_From_RealSql()
{
DbParameterCollection dbParameterCollection = new DbParameterCollection();
dbParameterCollection.Add(new DbParameter
{
Name = "Total",
DbType = System.Data.DbType.Int32,
Direction = System.Data.ParameterDirection.Output
});
RequestContext context = new RequestContext
{
CommandType = System.Data.CommandType.StoredProcedure,
RealSql = "SP_QueryByPage",
Request = dbParameterCollection
};
var list = _sqlMapper.Query <T_Entity>(context);
var total = dbParameterCollection.GetValue <int>("Total");
}
