SQL Compact 3.5 Attach Multiple DB/ Cross-db Query?

Is it possible to attach multiple DBs to SQL CE 3.5 (Compact edition) e.g. MasterData.sdf, Orders.sdf and apply queries against them e.g.: select Orders.iOrderID, Orders.cItemID, M

Solution 1:

No, this is not possible - but you could load each table as a list of business objects, and use LINQ to query cross these collections. (Requires more memory)