开发者

order collection by date where some items dont have a value

开发者 https://www.devze.com 2023-01-05 23:21 出处:网络
i have a collection of objects and i am looking to sort by a property that is a DateTime? list.OrderBy(r => r.Milestone)

i have a collection of objects and i am looking to sort by a property that is a DateTime?

  list.OrderBy(r => r.Milestone)

where milestone is a:

  public DateTime? Milestone { get; set; }

it seems to put all of the items with novalue at the top of the sort. Is there anyway to sort by date but put the empty items at the bottom of the list. (i dont care about the ordering of the empty ones of course)

So if i have 4 items:

  1. 1/1/2001
  2. 1/1/2开发者_C百科002
  3. [No DateTime]
  4. 1/1/2004

i would want to order the list 1,2,4,3


One easy option:

list.OrderBy(r => r.Milestone ?? DateTime.MaxValue)

That won't work nicely if there are values with a mileston of DateTime.MaxValue, of course.

Recently there was a related question about implementing IComparer<T> to put nulls at the end, but I can't find it now... the above is definitely the simplest solution though, if you won't be using MaxValue for anything else.

Alternatively:

list.OrderBy(r => !r.Milestone.HasValue)
    .ThenBy(r => r.Milestone)

will order all the values that do have a milestone first, and then the ones which don't. That way you it will work even if some milestones use DateTime.MaxValue. It's a little more obscure to my eyes, but you may prefer it.


try this:

list.OrderBy(r => r.Milestone.GetValueOrDefault(DateTime.Maxvalue)) 
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号