Linq to SQL - Return top n rows

jinsungy_1316 0
Viewed 96817

I want to return the TOP 100 records using Linq.

linq-to-sql .net
4 Answers

Use the Take extension method.

var query = db.Models.Take(100);
user_129500

You want to use Take(N);

var data = (from p in people
           select p).Take(100);

If you want to skip some records as well you can use Skip, it will skip the first N number:

var data = (from p in people
           select p).Skip(100);
user_739030

Use Take() extension

Example: 

var query = (from foo in bar).Take(100)
user_521010
Related