Limit Number of Results being returned in a List from Linq

c# asp.net-mvc-3 linq entity-framework
Jared picture Jared · Jun 4, 2012 · Viewed 95.7k times · Source

I'm using Linq/EF4.1 to pull some results from a database and would like to limit the results to the (X) most recent results. Where X is a number set by the user.

Is there a way to do this?

I'm currently passing them back as a List if this will help with limiting the result set. While I can limit this by looping until I hit X I'd just assume not pass the extra data around.

Just in case it is relevant... C# MVC3 project running from a SQL Server database.

Answer

Shyju picture Shyju · Jun 4, 2012

Use the Take function

int numberOfrecords=10; // read from user
listOfItems.OrderByDescending(x => x.CreatedDate).Take(numberOfrecords)

Assuming listOfItems is List of your entity objects and CreatedDate is a field which has the date created value (used here to do the Order by descending to get recent items).

Take() Function returns a specified number of contiguous elements from the start of a sequence.

http://msdn.microsoft.com/en-us/library/bb503062.aspx

Related questions

A lambda expression with a statement body cannot be converted to an expression tree in nopCommerce

I try to create a linq join query in the nopCommerce 3.0. i join two table in linq and write the code successfully. but the visual studio intellicence shows the error like A lambda expression with a statement body cannot be …

Read More
Creating HiddenFor IEnumerable<String> in View

I have a Property that is an IEnumerable public IEnumerable<string> ChangesOthersResult { get; set; } I need to collect all values from ChangesOthersResult and post from a view back to the controller. How can I loop through the Ienumerable …

Read More
DevExpress MVC Gridview + LINQ

We have a DX gridview being rendered in a specifically designed view. We pass a predefined ViewModel object whose values are filled from a Linq-2-Entities query. The problem is that in our callback function the L2E query is …

Read More