ulas said:Ah, thanks for the reply I will give this a try in a bit and let you know what happensdpratt71 said:*snip*
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).
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.