Join DB using c#

Question

Hi I have two different SQL servers each having a database with a table. I want to join these two tables using c# code since I dont have the necessary permission to create a linked server. So can this be achieved. How about doing in Linq?

Abhishek Jain · Answer

Yes you can do this with the help of LINQ: You just need to add reference to a library names System.Linq.Data Sample code: var firstQuery; var secondQuery; using (var dataContext = new DataContext( )) { firstQuery = (from table in dataContext. select table).ToList(); } using (var dataContext = new DataContext( )) { secondQuery = (from table in dataContext. select table).ToList(); } var finalResult = (from firstTable in firstQuery join secondTable in secondQuery on firstTable. equals secondTable. )....... Regards AJ