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