Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Linq Orderby nullable DateTime (C#)
Title: Linq Orderby nullable DateTime Language: C#
Description: 2 good ways that seem to translate in Linq-to-sql Views: 67
Author: Brandon Dimperio Date Added: 2/8/2010
Copy Code   
1orderby x.AddedDate ?? DateTime.MaxValue descending;
2
3option 2:
4
5orderby x.AddedDate.HasValue descending
6          orderby x.AddedDate descending;
7
8
Usage 
return from ju in context.Job_Users_Assigned
          where ju.UserID == user.ID
          orderby ju.Created ?? DateTime.MaxValue descending;


return from ju in context.Job_Users_Assigned
          where ju.UserID == user.ID
          orderby ju.Created.HasValue descending
          orderby ju.Created descending;
Notes
noted from: http://stackoverflow.com/questions/1107767/ordering-nullable-datetime-in-linq-to-sql/1107841