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;
select cart.PlaneName;