Linq 选择记录范围

Question

    var q = (from Comments in db.tblBlogComments where Comments.blogID == this.ID orderby Comments.date descending select new {
        Comments.userID, Comments.comment, Comments.date
    });

这会返回我所有的关联记录，我如何最好地只选择记录 #10 到 #20，这样我就不会加载任何冗余数据？

Answer 1

怎么样:

var q = (
from Comments in db.tblBlogComments 
where Comments.blogID == this.ID 
orderby Comments.date descending 
select new { Comments.userID, Comments.comment, Comments.date }).Skip(10).Take(10);