110,533
社区成员
发帖
与我相关
我的任务
分享
<MultipleResultMap Id="QueryByPageMReuslt">
<Result Property="Total"/>
<Result Property="List"/>
</MultipleResultMap>
<Statement Id="MQueryByPage" MultipleResultMap="QueryByPageMReuslt">
Select Count(1) From T_Entity;
Select Top 10 T.* From T_Entity T
</Statement>
public class QueryByPageResponse
{
public int Total { get; set; }
public IEnumerable<T_Entity> List { get; set; }
}
QueryByPageResponse MQueryByPage();
using (var multiResult = _sqlMapper.QueryMultiple(reqContext))
{
var totalRecord = multiResult.Read<int>();
var list = multiResult.Read<Entity>();
}
(int,User) QueryByPage(object reqParams);
(int,T) QueryByPage<T>(object reqParams);