Join DB using c#

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