Entity Framework 使用sql语句分页(查询单表)

最新推荐文章于 2023-08-01 20:53:48 发布

weixin_30559481

最新推荐文章于 2023-08-01 20:53:48 发布

阅读量190

点赞数

原文链接：http://www.cnblogs.com/renzaijianghu/p/4230173.html

版权

1、查询单表

                var pageSize = 2;//条数
                var pageIndex = 2;//索引

                var sql = @" SELECT D.*
 FROM   ( SELECT    ROW_NUMBER() OVER ( ORDER BY B_MemberId ASC ) AS rownum ,
                    *
          FROM      Bxy_MembersData
        ) AS D
 WHERE  rownum BETWEEN ( @pageIndex - 1 ) * @pageSize + 1
               AND     @pageIndex * @pageSize
 ORDER BY B_MemberId ASC";
                object[] sqlParameter =
                {
                    new SqlParameter("@pageIndex",pageIndex),
                    new SqlParameter("@pageSize",pageSize), 
                };
                var list = dataaccess.QueryList<Bxy_MembersData>(sql, sqlParameter);

转载于:https://www.cnblogs.com/renzaijianghu/p/4230173.html