ulas said:
dpratt71 said:
*snip*
Ah, thanks for the reply Smiley I will give this a try in a bit and let you know what happens Smiley

Quick question though - what is the main reason why my initial version was not working? Did I miss something obvious or is this a matter of lack of support in Linq for a particular type of query? (during runtime since VS does not complain at compiletime).

ulas

Basically, it has to do with the fact that the Entity Framework is handed an object graph that represents your query. EF then has to translate that representation into a SQL query. There are many things you can do in code that EF simply cannot translate.