.net connection pooling

c# .net ado.net connection-pooling
Erez picture Erez · Mar 9, 2011 · Viewed 92.6k times · Source

I don't get what is the syntax difference between regular connection and connection pool.

When I'm using the using key such as:

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    command.ExecuteNonQuery();
}

Is this the way to perform a connection pool?

Answer

Øyvind Bråthen picture Øyvind Bråthen · Mar 9, 2011

You can read about connection pooling here.

Basically as long as the connection string is the same (including case), connections will be taken from the same connection pool.

Related questions

Connection pool with possible severed connections

I have multiple threads accessing the same database (with same connection string). Each thread: creates it's own SqlConnection instance using the same connection string uses code below to open it's own connection instance whenever it needs one try { wasOpened = connection.…

Read More
MetadataException: Unable to load the specified metadata resource

All of a sudden I keep getting a MetadataException on instantiating my generated ObjectContext class. The connection string in App.Config looks correct - hasn't changed since last it worked - and I've tried regenerating a new model (edmx-file) from …

Read More
Populate data table from data reader

I'm doing a basic thing in C# (MS VS2008) and have a question more about proper design than specific code. I am creating a datatable and then trying to load the datatable from a datareader (which is based on an …

Read More