Pankaj Upadhyay Pankaj Upadhyay - 1 year ago 90
C# Question

How to retrieve last 5 records using LINQ method or query expression in C#

On my homepage, I want to show the recently added products. I have added a ChildAction to my controller but i am unable to understand what Linq query should i run to fetch the last five records.

Answer Source


var lastFiveProducts = (from p in products 
                        orderby p.ProductDate descending
                        select p).Take(5);


var lastFiveProducts = products.OrderByDescending(p => p.ProductDate).Take(5);

Which ever you prefer.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download