CODEWITHSUNDEEP
paginationlinq-to-sql
cyberdantes
cyberdantes

Reputation: 1422

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?

Upvotes: 2

Views: 480

Answers (3)

cyberdantes
cyberdantes

Reputation: 1422

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

Upvotes: 0

Filip Ekberg
Filip Ekberg

Reputation: 36327

var limit = 10;
var start = 30;

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

Upvotes: 2

Jack Marchetti
Jack Marchetti

Reputation: 15754

You want to look up, Take and Skip.

Take and Skip

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

Upvotes: 2

Related Questions