How can I page my LINQ to SQL result set?

Question

Remembering MySQL could use the instruction "limit" to indicate where I was starting my result set and how many wanted to have included.

Select * FROM Users Limit [start], [Length]

How can I do this in LINQ to SQL?

Answer 1

You want to look up, Take and Skip.

Take and Skip

var query = listOfItems.Take("25").Skip("50");

Answer 2

var limit = 10;
var start = 30;

var result = ( from x in MyList
               select x ).Skip(start)
                         .Take(limit)
                         .ToList()

Answer 3

You can see the Kigg Starter Kit for this problem and another ones