0

In Linqpad how can I query against two databases on one query.

I have managed to add the 2 databases like so:

https://stackoverflow.com/a/4928921/66975

so the connection says "db1 + db2".

However I am unsure how to access the tables from db2 to make queries.

I can query against tables in the first db. Note: both dbs contain more or less the same table names.

raklos
  • 28,027
  • 60
  • 183
  • 301
  • 1
    Did you try dragging a table from each database to the query box to see how it refers to them? – sgmoore Nov 20 '17 at 16:03
  • 1
    @sgmoore That did the trick, so works for first db and . works for the second db...Really feel as though I tried that before. Must have had a typo. – raklos Nov 20 '17 at 16:37

0 Answers0