[question] Multiple Servers

[fe-velazquez]

Hello there, in my application I'm using 3 diferent servers with their respective database objects. is there a way to express it with the current notation?

best regards

[nvquanghuy]

Hi @fe-velazquez, I don't quite understand your problem. What stops you from creating 3 different DBML file to define 3 different databases?

[fe-velazquez]

Hello @nvquanghuy, thanks for your early response. What i´m trying to display is how data is related across multiple systems for example:

1. server1 1.1 databaseC 1.1.1 table1 1.1.1.1 customKeyField1

2. server2 2.1 databaseN 2.1.1 table32 2.1.1.1 customKeyField1

the query would be on t-sql sintax SELECT * FROM [server1].[databaseC].[dbo].[table1] t0 inner join [server2].[databaseN].[dbo].[table32] t1 on t0.[customKeyField1] = t1.[customKeyField1]

I know this can be achieved using multiple files, however is not as clean as it could be.

best regards.