How does LinqPad generate a single SQL across databases?
Just wondering in this era of Entity Framework Core, how does LinqPad under the covers support querying across databases? I click on the SQL tab I see a unified SQL statement with fully qualified database.schema.table names and everything works. Is there any way to do this within my applications? Everything I find online indicates that short of creating views or other hacks, you can't query across databases with DbContext. But somehow, LinqPad manages. ?