>>>I am going to try now this solution http://archive.msdn.microsoft.com/LinqEntityDataReader by MS employee David Browne.
>>
>>Like this:

    DataTable dt = new DataTable();
>>            dt.Load(resultingQuery.AsDataReader());

Interested to know if it works.....
>
>
>Yes, worked fine.

But the fact that such a rather simple idea needs a threat shows the not-rounded nature of LINQ even today.
Not only vfp would not hiccup there, but ANY disc based middle layer - in SQLite you could even steer the resulting new table to RAM or disc.