Menu
Is it possible to perform joins across different databases using LINQ? If yes then how?
705
SQL Server allows you to join tables from different databases as long as those databases are on the same server. The join syntax is the same; the only difference is that you must fully qualify table names.
In LINQ, an inner join is used to serve a result which contains only those elements from the first data source that appears only one time in the second data source. And if an element of the first data source does not have matching elements, then it will not appear in the result data set.
In LINQ to SQL, the data model of a relational database is mapped to an object model expressed in the programming language of the developer. When the application runs, LINQ to SQL translates into SQL the language-integrated queries in the object model and sends them to the database for execution.
If the databases are on the same server, you can create views (and 3 part naming) so that all the tables are queryable from one database.
If the databases are on different servers, you can use linked servers and views (and 4 part naming) so that all the tables are queryable from one database.
119
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
