>>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.....