>I know that there are at least two kludge workarounds from doing joins from on EF Model to another. The first is to create a view in one of the Model db and the second is a LINQ query that calls a method that joins to another Model.
>
>Does anyone know of anything else?
>
>To complicate matters: What if I need to join an EF entity (table) to a FoxPro table using the VFP Oledb driver? (This question is similar to my other question on cascading FoxPro queries, but a little different.)
>
>TIA
So are the models to different databases (ex. one in SQL vs VFP)? You really can't directly do this. You could run one query which retrieves the data into some type (ex. List<T>), do the same for VFP, then run a LINQ query against both of them. But depending on how much info you're talking about that could be a really bad idea.