Linq ordering smartdates

In your LINQ statement you should be able to do whatever transformations you want and still return whatever result set you want.  You should be able to return your smartDate but order on x=>x.Smartdate.Date

This returns a subset of child data where my keys match ordered by the date where ScheduledDate is a SmartDate

return ParentScheduleExplorer.ScheduleDetailList.Where(x => x.ParentScheduleId == ScheduleId).OrderBy(x =>x.ScheduledDate.Date);

I must admit, once you start thinking of changing databound controls to read DateProperty.Text or DateProperty.Value and changing all validationRules etc, it makes me not want to change from a String property to a SmartDate.

"Prior to LINQ, a class implmentingthe IComparer interface was used to build a custom Compare. Then Sort would be provided the class implementing IComparer to use to perform a custom sort. "

Can LINQ use/specify an IComparer class for sorting? Or is there something similar in LINQ?
That would be great if there is going to have to google it and see what i can find.  Does anyone know if this is possible and have they used it.

Thanks for the tip

then convert your string to date in the orderby clause.

pseudo code

OrderBy(x => Convert.DateTime(x.MyStringDate));

Yes this would work, but i am returning a string not a smartdate

Not sure that I really follow but generally what I do to get around any of these things where I can't do an override at runtime is just add pseudo properties to my BO so that I can use them whenever I want.

The code I provided just does an initial sort on the underlying collection.  If you stick it in a grid and click on the column header then its going to use the column/property to sort.

So if you add a:

public DateTime MyStringDateSort { get{return Convert.DateTime(MyStringDate);}}

to you BO then you can always use that whenever you need to provide a field for sorting.  You could then replace your MyStringDate in the override of the sort command with MyStringDateSort

Jack, i dont know much about linq, but this sounds good and possibly exactly what i need! Thanks

Not sure if this will make sense, but since you seem to know abit about linq etc, do you know if you can override the sort command using linq?

Basically i have a grid control within my web page that uses linq to order the data, i can override the sort command on the grid and get the field name, order etc that the grid is going to order the list in, but i didnt know if i could somehow make a sort override against my BO, so that instead of the grid attempting to sort my list by strings, i could use your code above?

Sorry if this doesnt make to much sense