Linq to SQL - returns the top n rows

Question

I want to return TOP 100 records using Linq.

Answer 1

Use the Take extension method.

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

Answer 2

Do you want to use Take (N);

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

If you want to skip some entries, you can also use Skip, it will skip the first number N:

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

Answer 3

Example with order:

 var data = (from p in db.people orderby p.IdentityKey descending select p).Take(100); 

Answer 4

Use the Take() extension

Example:

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