Skip to main content

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;