Pankaj Upadhyay Pankaj Upadhyay - 7 months ago 27
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.



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.