How to write linq query to match SQL like select top 100 * from tab?

Question

WIth Ria Service, I have a linq query like:

EntityQuery<Employee> query = from e in ctx.GetEmployeeQuery()  
                      orderby e.DateCreated descending
                              select e;

Then I want to get the top 100 records from this query, like SQL select top 100 * from Employee

How to write the linq query?

user151323 · Accepted Answer · 2009-08-31 14:38:06Z

46

EntityQuery<Employee> query = (from e in ctx.GetEmployeeQuery()  
                              orderby e.DateCreated descending
                              select e).Take (100);

answered Aug 31, 2009 at 14:38

user151323

Sign up to request clarification or add additional context in comments.

2 Comments

Wim ten Brink Over a year ago

Lol. It seemed such a complex question but again, Linq makes it real simple. (I need to make a t-shirt with "I heart Linq"...)

River-Claire Williamson Over a year ago

For the ultimate cred, the shirt would need to have a linq statement that returns "I love LINQ".

Collectives™ on Stack Overflow

How to write linq query to match SQL like select top 100 * from tab?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related