Home

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

edited August 2017
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.