We are converting a large VFP 8 app to .NET. We have to keep a lot of our tables in FoxPro dbfs (DBC) and some tables from MySQL will be converted to MSSQL and those tables will be in the Entity Framework.

I've attempted to use the CodePlex VFP Entity Framework provider, but might not be able to because it is too slow in a Join situation with tables with 600,000 rows. FYI, these tables are properly indexed. Asking whether the CodePlex VFP EF provider can be faster is a separate question here.

The main question I have is in our FoxPro apps here and as I've seen elsewhere as well there are a lot of cascading SQL Selects that build on one another until there's a final FoxPro cursor that the application consumes and does "work" to.

Sure, one answer is to try to turn all the little VFP cascading Selects into one massive Select, but what if it is too complex and too slow?

If I can't use the VFP EF Provider and can't use LINQ then I believe I have to use the VFP Oledb driver. And I don't have a problem with that since it's pretty fast. The question I have is the multiple cascading SQL Selects. How do I do that in Oledb? Well, creating separate command objects with the SQL is easy and running the command is easy, but how do you join them and have one build on the previous result, which will be a datatable, I believe. Or a Reader.

TIA