C# – SqlConnection.ClearAllPools issue

ado.netcconnection-poolingnetsql-server-2008

I am using VSTS 2008 + .Net 3.5 + C# + ADO.Net + SQL Server 2008 Enterprise. I am learning http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.clearallpools.aspx about SqlConnection.ClearAllPools method. I want to know the behavior of this method is, if any connections from connection pool is idle when method ClearAllPools is called, such idle connections will be disconnected from SQL Server? Is that correct understanding?

I did not find related comments from the MSDN link.

Best Answer

The answer is Yes.
But the situations in which this is useful are rare.

Related Solutions

How to connect to local instance of SQL Server 2008 Express

Please check the ServerName which you provided. It should match with the below shown Name in the UserName textbox, and that name should followed with \SQLEXPRESS:

Connect dialog

C# – how to make DataSet return two related Tables

Try this

Dim myAdapter as SqlDataAdapter = new SqlDataAdapter(
      “SELECT * FROM Customers; SELECT * FROM Orders“, connection)

myAdapter.Fill(dsTables)
dsTables.Tables(0).TableName = “Customers“)
dsTables.Tables(1).TableName = “Orders“)

http://pietschsoft.com/post/2004/08/22/Fill-DataSet-with-multiple-Tables-and-update-them-with-DataAdapter.aspx

Best Answer

Related Solutions

How to connect to local instance of SQL Server 2008 Express

C# – how to make DataSet return two related Tables

Related Topic