LINQ to Entities returns the top N records.

Question

LINQ to Entities returns the top N records.

entity-framework linq

Question

I am using Linq to entities and would like to know if I can get a limited number of records when i query. I just need the top N records as the query do the orderby and other clauses. Is this possible or I will have to get the top N using foreach loop?

Abdel Raoof

Popular Answer

There are multiple ways

1)

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

2)

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

3) or you can skip certain results

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

Mohit Verma

Related Questions

View more on Stack Overflow

sovanesyan · Accepted Answer · 5/20/2010 2:27:52 PM

Accepted Answer

You can just use the .Take method call to get a couple of result. You can read more on this topic here.

You need to understand that the query will not be executed unless someone executes the GetEnumerator().

sovanesyan

LINQ to Entities returns the top N records.

Question

Fastest Entity Framework Extensions

Accepted Answer

Popular Answer

Related Questions

Fastest Entity Framework Extensions

Performance

Expression Evaluator

Related