LINQ Orderby Descending Query

Question

I m sure this will be a relatively simple one   I have a LINQ query that I want to order by the most recently created date   See           var itemList   from t in ctn Items                         where  t Items  amp  amp  t DeliverySelection                         orderby t Delivery SubmissionDate descending                         select t    I have also tried          var itemList    from t in ctn Items                         where  t Items  amp  amp  t DeliverySelection                         select t  OrderByDescending      but this gives an error       No overload for method    OrderByDescending  takes 0 arguments   From what I ve read  I m fairly sure the first way I ve done it should work  I ve tried changing descending to ascending just to see if it does anything but it stays the same    I d be grateful if someone could take a look at the query and see if I m doing anything wrong  Thanks

User · Accepted Answer

You need to choose a Property to sort by and pass it as a lambda expression to OrderByDescending

like:

.OrderByDescending(x => x.Delivery.SubmissionDate);

Really, though the first version of your LINQ statement should work. Is t.Delivery.SubmissionDate actually populated with valid dates?

User · Answer

I think this first failed because you are ordering value which is null  If Delivery is a foreign key associated table then you should include this table first  example below   var itemList   from t in ctn Items Include x  gt x Delivery                      where  t Items  amp  amp  t DeliverySelection                     orderby t Delivery SubmissionDate descending                     select t

User · Answer

Just to show it in a different format that I prefer to use for some reason  The first way returns your itemList as an System Linq IOrderedQueryable  using var context   new ItemEntities          var itemList   context Items Where x   gt   x Items  amp  amp  x DeliverySelection                                   OrderByDescending x   gt  x Delivery SubmissionDate       That approach is fine  but if you wanted it straight into a List Object   var itemList   context Items Where x   gt   x Items  amp  amp  x DeliverySelection                                   OrderByDescending x   gt  x Delivery SubmissionDate  ToList      All you have to do is append a  ToList   call to the end of the Query   Something to note  off the top of my head I can t recall if the   not  expression is acceptable in the Where   call

User · Answer

I think the second one should be  var itemList    from t in ctn Items                 where  t Items  amp  amp  t DeliverySelection                 select t  OrderByDescending c   gt  c Delivery SubmissionDate

[c#] LINQ Orderby Descending Query

Examples related to c#

Examples related to linq

Examples related to sql-order-by