如何在C＃中的多个数据库上执行单个命令？

问题描述

我有四个数据库名称Server1，Server2，Server3和Server4，每个包含一个表。

I have four databases names Server1, Server2, Server3, and Server4 which contains a single table each.

SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["Server1"].ToString());
   SqlConnection con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["Server2"].ToString());
   SqlConnection con3 = new SqlConnection(ConfigurationManager.ConnectionStrings["Server3"].ToString());
   SqlConnection con4 = new SqlConnection(ConfigurationManager.ConnectionStrings["Server4"].ToString());

i想在C＃中激活以下命令： -

i want to fire the following command in C# :-

select id, filename, Server from Server1.dbo.UploadedData where userid='1'
union
select id, filename,Server from Server3.dbo.UploadedData where userid='1'
union
select id, filename,Server from Server3.dbo.UploadedData where userid='1'
union
select id, filename,Server from Server4.dbo.UploadedData where userid='1'

执行此命令我必须传递每个数据库的连接对象。



喜欢......

for executing this command i have to pass connection object of each database.

like...

cmd= new SqlCommand("select id, filename, Server from Server1.dbo.UploadedData where userid='1'union select id, filename,Server from Server3.dbo.UploadedData where userid='1' union select id, filename,Server from Server3.dbo.UploadedData where userid='1' union select id, filename,Server from Server4.dbo.UploadedData where userid='1',con1,con2,con3,con4 ");

这是不可能传递4个连接对象.......什么是另一个最好的选择??

this is not possible to pass 4 connection object.......what will be the other best option??

推荐答案

这篇关于如何在C＃中的多个数据库上执行单个命令？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！