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?

Answer 1

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