Menu
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.
949
If you think there is a chance your table may be empty, use LastOrDefault()[^] instead. This will return null if nothing is found. var lastItem = yourQuery. LastOrDefault(); if(lastItem == null) { //Table was empty. }
Query syntax and method syntax are semantically identical, but many people find query syntax simpler and easier to read. Some queries must be expressed as method calls. For example, you must use a method call to express a query that retrieves the number of elements that match a specified condition.
LINQ query syntax always ends with a Select or Group clause. The Select clause is used to shape the data.
LINQ
var lastFiveProducts = (from p in products orderby p.ProductDate descending select p).Take(5); Lambda
var lastFiveProducts = products.OrderByDescending(p => p.ProductDate).Take(5); Which ever you prefer.
139
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
