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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book