Provide a method to select a database (from the droplist) via code in c# statements mode
I'd like a method (maybe exposed via the LINQPad object) to change the data context to any of those present in the 'Add Connection' pane.
As we know linq cannot perform cross database (cross data context) joins. To cope with this, in Visual Studio, I often use one data context, obtain data into a table or array, then switch to another data context, obtain more data, then fuse the result sets.
This is simple enough in VS, but in LINQPad I cannot work out how to change the data context via code in C# Statements mode; the only way I can see is to use the drop list ('databases') in the Query window. This effectively precludes the approach I'm using from working.
Apologies if there's already an obvious way to do this (I've checked the forum and the suggestions lists and faq but cannot determine how).
-
John Rusk commented
Yes please. This is the main thing I want LINQPad for. I just purchased a licence, thinking it would do this, and it doesn't.