关于连接池资源释放的问题
柯嘉 2004-08-29 03:54:44 /*
请问,以下这段程序执行后,并未显式关闭连接,连接对象myConnection会不会Close?即使它被系统
自动回收,那连接池中的连接资源是否被立即释放?
*/
public void CreateMyOdbcCommand()
{
OdbcConnection myConnection = new OdbcConnection("DRIVER={SQL
Server};SERVER=MyServer;Trusted_connection=yes;DATABASE=northwind;");
string mySelectQuery = "SELECT * FROM Categories ORDER BY CategoryID";
OdbcCommand myCommand = new OdbcCommand(mySelectQuery, myConnection);
myCommand.CommandTimeout = 20;
}