Reference Tables From 2 or more Different Databases
I have 2 different databases with different connection strings. What is the best way to reference both databases so that I can access the tables within the same query within LinqPad. Is there an example to look at?
Thanks
Comments
If the databases have the same schema:
https://forum.linqpad.net/discussion/2762/multiple-connections-same-schema
If the databases have different schemas, but are both SQL server and on the same server or linked servers:
https://stackoverflow.com/questions/1495357/linqpad-using-multiple-datacontexts
Otherwise, you will need to manually reference a DLL that contains an EF Core context for one of the databases.