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 · 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 => !x.Items && x.DeliverySelection)
                                .OrderByDescending(x => x.Delivery.SubmissionDate);
}

That approach is fine, but if you wanted it straight into a List Object:

var itemList = context.Items.Where(x => !x.Items && x.DeliverySelection)
                                .OrderByDescending(x => 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

You need to choose a Property to sort by and pass it as a lambda expression to OrderByDescending  like    OrderByDescending x   gt  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

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