首页 > 其他 > 详细

linq,skip(),take实现分页

时间:2016-10-06 12:54:38      阅读:263      评论:0      收藏:0      [点我收藏+]

using (AdventureWorks2012Entities db = new AdventureWorks2012Entities())
{
int num = (from stu in db.Customer orderby stu.CustomerID select stu).ToList().Count;

for (int i = 0; i < num;i=i+100)
{
var students = (from stu in db.Customer
orderby stu.CustomerID
select stu).Skip(i).Take(100).ToList();
foreach (var stu in students)
{
System.Diagnostics.Debug.WriteLine(stu.CustomerID + "," + stu.AccountNumber);
}
int pageCount = i / 100 + 1;
System.Diagnostics.Debug.WriteLine("This is page " + pageCount + "\n");
}

Console.ReadLine();
}

 

技术分享

 

linq,skip(),take实现分页

原文:http://www.cnblogs.com/Fred1987/p/5933590.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!