allow multiple data contexts per query
I would like to be able to take data from multiple sources and munge them together, but right now only a single context is allowed. I guess you could do this with mega data context that references other data contexts.
-
Adam Schiavone commented
Found myself today using multiple (differently formatted) CSV and OData connections, but unable to use them all in the same query. Had to install CsvHelper and do it manually! I would love to see a feature like this implemented.
-
Ivan Gavryliuk commented
This would be ideal to have. At the moment I have to keep multiple script files open, huge pain, and theres no way to easily pass data between them. Alternatively a single script can just connect to data source via code, but then we don't use connections at all.
-
Ingo Gambin commented
it seems especially these days when everyone is switching to cloud, less and less real DBAdmins are working on our clients database systems. So we often face database systems that are distributed between cloud service environments and on-premise database servers. Sadly many of these have no DB link due to the fact that now there are services in place that handle their data independently. Still for some quick reporting feature it would be lovely to have linqpad to connect to two different sql servers, having 2 contexts and beeing able to pull filtered data from then and then join them locally.
-
Anonymous commented
+1
-
Jens Theisen commented
Very useful for Azure where you can't do cross-db queries.
-
Pete Wilson commented
Would like this to work with the SQL window as well...
-
Anonymous commented
+1
-
Pif commented
Would be really nice, especially when there is no DB link between two databases....