I am trying to sort the SQL query with LINQ based on two fields. The first area is sometimes a tap that automatically goes to the top of an ascending query. Is there any way to make Zero entries like that?
Here's an example:
SampleDataContact.Exchange x to x command, x.Sequence_Number _x.Date, x.Sequence_Number 12/2/09, 5 12/3/09, 2 Desired order:
- 12/2/09, 5
- 12 / 3/09, 2
- 12/3/09, 3
- Zero, 1
- NULL, 4
If they are string:
by order (string.IsNullOrEmpty (x.Date)? " Zzzzzz ": x.Date)
If they are spaces:
to order (x. Date? Datetime.maxvalue)
No comments:
Post a Comment