>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

Did you look into using ViewModel? I think this is for the cases where we need to do more than a simple Model bound view.