什么是处理在C＃中多个数据库连接的最佳方法 [英] What is the best way to handle multiple database connections in C#

问题描述

如果说我需要在其上运行两个单独的数据库两个单独的SQL语句。现在我做的（伪）：

If say I need to run two separate SQL statements against two separate databases. Right now I do (pseudocode):

Try{

declare variable connectionA to DatabaseA 
declare variable connectionB to DatabaseB 

connectionA.open()
connectionB.open() 


declare variable SQLCmdA with ConnectionA and one SQL statement 
declare variable SQLCmdB with ConnectionB and another SQL statement 

SQLCmdA.executeNonQuery() 
SQLCmdB.executeNonQuery()

}

Catch () 
{
   print error message
}

Finally(){ 
  connectionA.close() 
  connectionB.close()
  SQLCmdA.Dispose()
  SQLCmdB.Dispose() 
}

上面看起来很笨拙。如果我有三个不同的SQL语句，我将需要三种不同的SQLCMD变量。

The above seems very clumsy. And if I have three different sql statements, i would need three different SQLCmd variables.

有没有做这样的事情，尤其是在效率方面的一个标准的方式，性能？如果任何人都可以提供一个简单改进的伪代码，那简直太好了。

Is there a "standard" way of doing such things, especially in terms of efficiency, performance? if anyone can provide a simple improved pseudocode, that'd be great.

另外，我需要担心实现连接池，以节约资源，加快程序？如果是这样，我怎么在这种情况下实施的？

In addition, do I need to worry about implementing Connection Pooling, to conserve resource and speed up the program? If so, how do I implement it in this case?

谢谢！

推荐答案

而不是增加变量，为什么不能让一个类？

Instead of adding variables, why not make a class?

public class MyDatabaseConnection {
    public MyDatabaseConnection(string connectionString) {
        this.connectionString = connectionString;
        // create a database connection perhaps
    }
    // some methods for querying a database
    public void execute(string query) { }
}

在这种情况下，可以很容易地添加第三个数据库连接

In this case it's easy to add a third database connection

MyDatabaseConnection con1 = new MyDatabaseConnection("Server=localhost");
MyDatabaseConnection con2 = new MyDatabaseConnection("Server=other_server");
MyDatabaseConnection con3 = new MyDatabaseConnection("Server=third_one");

和执行上的每个

MyDatabaseConnection[] cons = new MyDatabaseConnection[]{ con1, con2, con3 };
foreach (MyDatabaseConnection con in cons) {
    con.execute(someSqlCommandText);
}

这篇关于什么是处理在C＃中多个数据库连接的最佳方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！