How to perform cross database LINQ join operation

Hello Folks,

Today I will tell you how we can use the power of LINQ to perform join on tables from two different database.

Idea is very much similar to the way we perform join on the tables within a single database with little twist.

After dragging the table from first database, try dragging the table from the second database. Visual studio will give warning but ignore it.

I say Ignore it as it will just change the connection string. This should not be a matter of concern as long as both the database are within the same database engine.

And then go to the property of first table and change the  source value to fully qualified name i.e. <DatabaseName>.dbo.<TableName>

See the steps described below:

And then right the code to perform join operation.

static void Main(string[] args)

        {

            CrossDBLinqDataContext crossdbContext = new CrossDBLinqDataContext();

            var result = from t1 in crossdbContext.Test1Tables

                         join t2 in crossdbContext.Test2Tables on t1.Id equals t2.id

                         select new { t1, t2 };

            foreach (var item in result)

            {

                Console.WriteLine(item.t1.name);

                Console.WriteLine(item.t2.name);

            }

        } 


Happy Coding :)