I have starting doing a lot of MVC2 development without doing enough research about the EF4. This lead me to a path which I am not happy with. The way that I laid out my project is that my Models are all ADO.NET Entity Framework Models. Each model is representing a database Table. Today, I attempted to do a LINQ join on entities which belong to two different data contexts. This resulted in a nasty LINQ error telling me that it can't be done. I hate the fact that the only viable way to use the EF seems to create large models. Can someone please recommend an alternative method, with or without using the EF?
View Complete Post