Linq Get next n records

Question

I have a grid with pager, I am trying to get the next 25 records starting with a start index.

for example for the first time it I return 25 records, when I change to next I want to pick the next 25 records and skip the first 25.

What is the most preferable way to do it using LINQ?

Thanks, Alaa

I think that is the best approach I got to, uvs = uvs.Skip(startIndex.Value * recordsCount.Value).Take(recordsCount.Value); is there any better solution for performance? — Alaa Osta, May 09 '12 at 15:40

score 5 · Accepted Answer · answered May 09 '12 at 15:38

5

I would use use the Take and Skip methods

var list = source.Skip(25 * page).Take(25);

answered May 09 '12 at 15:38

Aducci

score 0 · Answer 2 · edited May 23 '17 at 12:24

0

If you want better performance, you can partition your collection of records into groups of 25: here's a simple solution and an efficient solution.

Remember that each time an IEnumerable gets enumerated, the statement that created it gets executed, so be sure to use ToList() when appropriate.

edited May 23 '17 at 12:24

Community

answered May 09 '12 at 19:23

Risky Martin

2 Answers2