Paging using Linq

Question

I need to apply paging logic to this Query. How can i do that?

My query is as follows,

myresultset = from req in myreqTable
              join streq in myStreqTable on req.ID.ToString() equals new SPFieldLookupValue( Convert.ToString( streq[FormID] ) ).LookupValue
              where (filter(req) && filter1(streq))
              join plnts in plantDetails on Convert.ToString( streq[RequestID) equals Convert.ToString(plnts[RequestID]) into mySet
              from s in mySet.DefaultIfEmpty()
              select new Mytable() {
                  FormID = Convert.ToString(streq[FormID]),
                  RequestID = Convert.ToString(streq[RequestID])
              };

score 3 · Answer 1 · answered Jul 12 '13 at 06:34

3

Add .Skip( pageSize * pageIndex ).Take( pageSize ); to the end of your query. Note that pageIndex is zero-based (so the first page is 0, the second page is 1 and so on).

However your Linq doesn't look valid to me, and has some syntax errors. Are you sure this is your code as it is in your editor?

answered Jul 12 '13 at 06:34

Dai

126,861
25
221
322

hi i have added it jst after myset.Skip( pageSize * pageIndex ).Take( pageSize ) – Sreejith Unnikrishnan Jul 12 '13 at 06:44

score 0 · Answer 2 · answered Jul 12 '13 at 06:36

0

Use Take and Skip methods:

myresults = myresults.Skip((page - 1) * pageSize).Take(pageSize);

I assumed page numeration starts from 1.

answered Jul 12 '13 at 06:36

MarcinJuraszek

121,297
15
183
252

Chris · Accepted Answer · 2013-07-12T06:46:47.353

0

recordsForCurrentPage = myresultset.Skip( recordsPerPage * pageNumber ).Take( recordsPerPage )

This is assuming that your page number starts with 0. Otherwise subtract 1 from pageNumber.

edited Jul 12 '13 at 06:46

answered Jul 12 '13 at 06:36

Chris

6,647
3
53
78

hi i have added it jst after myset. Skip( pageSize * pageIndex ).Take( pageSize ); bt still it returns all records ... – Sreejith Unnikrishnan Jul 12 '13 at 06:44
You will need to use the return value, i.e. `recordsForThisPage = myresultset.Skip(...).Take(...)` – Chris Jul 12 '13 at 06:46
I have 2000 records, i have added like this myresults = myresults.Skip(1 * 10).Take(10); . but it returns only one record ??.. – Sreejith Unnikrishnan Jul 12 '13 at 06:56
hi chris any update ? – Sreejith Unnikrishnan Jul 12 '13 at 07:00
Thanks for ur help. it worked – Sreejith Unnikrishnan Jul 12 '13 at 07:04

Paging using Linq

3 Answers3