How to update multiple Server tables using dblink in C#

[Ashokkumar9892]

Hi,

I have requirement to update multiple data base which is in different server, i thought its straight like executenonquery using ado.net but its always updating 1st server, not all server.


Query is like this :

Connection.open()


Begin.Transaction();



Update SchemaName.TableName@server1 set colum1 ='abc, where column2="vv";


CommitTransaction();

Begin.Transaction();

Update SchemaName.TableName@server2 set colum1 ='abc, where column2="vv";

CommitTransaction();


Begin.Transaction();

Update SchemaName.TableName@server3 set colum1 ='abc, where column2="vv";

CommitTransaction();


Connection.Close();

Please help me what i dm doing wrong??



Jumping

Continue reading...