根据我的理解,.Net将默认将连接字符串相同的sqlConnection对象集中在一起.如果我调用Dispose方法,连接是否仍会被合并？
在ASP.NET应用程序的上下文中询问此问题,该应用程序有时会在单个PageLoad事件中对数据库进行多次命中.我希望将连接汇集在一起,但是希望确认在数据操作完成后关闭和处理连接不会干扰.NET对连接池的处理.
解决方法
使用连接池时,关闭sqlConnection只会告诉连接池您已完成它.然后,池将决定是否实际关闭连接,或重用连接.
If the sqlConnection goes out of scope,it won’t be closed. Therefore,you must explicitly close the connection by calling Close or Dispose. Close and Dispose are functionally equivalent. If the connection pooling value Pooling is set to true or yes,the underlying connection is returned back to the connection pool. On the other hand,if Pooling is set to false or no,the underlying connection to the server is closed.
