>>>>Maybe just retrieve the SQL data using the simple startdate-endate query then use linq to objects to filter the results on the remaining criteria.
>>>>If the number of records returned from the simple query is excessive then perhaps a CLR proc in SQLServer ?
>>>
>>>I found solution here
http://stackoverflow.com/questions/10000338/using-datetime-value-timeofday-in-linq-query which I am trying now.
>>
>>Interesting. Hadn't come across canonical functions. Let us know how you get on.....
>
>It did work out (although I replaced them to DbFunctions as the other ones were deprecated). I didn't find anything for WeekDay, though, so I kept that logic separate after getting result back.
And how much more efficient was the SQL execution compared to the original attempt ?