Linq to SQL - Return top n rows
.NetLinq to-Sql.Net Problem Overview
I want to return the TOP 100 records using Linq.
.Net Solutions
Solution 1 - .Net
Use the Take extension method.
var query = db.Models.Take(100);
Solution 2 - .Net
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);
Solution 3 - .Net
Example with order by:
var data = (from p in db.people
orderby p.IdentityKey descending
select p).Take(100);
Solution 4 - .Net
Use Take()
extension
Example:
var query = (from foo in bar).Take(100)