paginationlinq-to-sql

How can I page my LINQ to SQL result set?


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?


Solution

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