Joining Tables across Databases

Question

 

Hi

 

I have to join almost five to six tables across databases. So I have created a different context and written join qery it is throwing exception. How to do it using LINQ?

 

Thanks

Anandraj.A.

Answer 1

You will need to cast the results of each table fetch ToList and then use LINQ to Objects to perform the heterogeneous join. If you know that the result of particular queries are rather small, you may be able to use the Where list.Contains(item.value) syntax to perform an Where value IN (list) SQL statement. Be aware that heterogeneous queries require that you take a fair amount of care to avoid fetching the least number of rows across the network.

 

Jim Wooley

www.ThinqLinq.com

Answer 2

Another option is just to create the query as a view in your database and then access that via LINQ to SQL.

 

[)amien