link to sql OrderByDescending

Linq Order by Descending Query

Hello everyone, I am going to share the query for Order by Descending in Linq to SQL.


The  query detail as given below.

/// <summary>
/// This method is used to get cart using OrderByDescending.
/// </summary>
public List<Cart> MyCarts(string EmailID, long CompanyID, long TenantID)
{       
    return base.Context.Carts.Where(x => x.UserEmailID == EmailID && x.CompanyID == CompanyID && x.TenantID == TenantID && x.IsDeleted == false).OrderByDescending(x=>x.ManageShoppingCartID).ToList();

 }


                                              OR



var query = base.Context.Carts.OrderBy(x => x.PlaneName).ThenBy(x => x.DeviceName).ThenByDescending(x => x.CartID).ThenBy(x => x.Quantity).ToList();


                                              OR

var query = from cart in Carts
                    orderby cart.CartID descending, cart.DeviceName descending
                    select cart.PlaneName;



ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
My Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.