I suggest you ...

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.

105 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    mcintyre321 shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    7 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Ivan Gavryliuk commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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.

      • Pif commented  ·   ·  Flag as inappropriate

        Would be really nice, especially when there is no DB link between two databases....

      Feedback and Knowledge Base