Tech Off Post

Single Post Permalink

View Thread: LINQ to Entities and using a collection in the query...
  • User profile image

    ulas said:
    dpratt71 said:
    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).


    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.