Is it True that can't join tables from different servers?

edited August 21
https://stackoverflow.com/questions/32272091/joining-two-tables-from-different-servers-using-linq

According to this, it's not possible. If it is, what is the syntax? I have a connection that used additional linked servers but don't know how to differentiate primary connection and additional one when it is a different server

from p in TableInPrimaryServer join r in TableInSecondaryServer.RM00101s on p.PHONE equals r.PHONE1

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!