Connection Pooling in ADO.NET

Amit Maheshwari

Hi friends,

I want to know that what's the meaning of connection pooling in ADO.NET? How do we implement it in programming scenario?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Hi Amit,

Connecting to a database server typically consists of several time-consuming steps. A physical channel such as a socket or a named pipe must be established, the initial handshake with the server must occur, the connection string information must be parsed, the connection must be authenticated by the server, checks must be run for enlisting in the current transaction, and so on.

In practice, most applications use only one or a few different configurations for connections. This means that during application execution, many identical connections will be repeatedly opened and closed. To minimize the cost of opening connections, ADO.NET uses an optimization technique called connection pooling.

name="sqlConnectionString"
connectionString="Data Source=vhimabindu;Initial Catalog=DNN;password=himavejella;Integrated Security=True; Pooling=true; Max pool size=200; Min poolsize=0" />

for more info:
http://ondotnet.com/pub/a/dotnet/2004/02/09/connpool.html
http://beyondrelational.com/modules/2/blogs/61/posts/11202/connection-pooling-in-adonet.aspx
http://www.codeproject.com/Articles/17768/ADO-NET-Connection-Pooling-at-a-Glance
Satyapriya Nayak14y ago
Hi Amit,

Please refer Our recommended articles

http://www.c-sharpcorner.com/uploadfile/mahesh/understanding-connection-pooling-in-ado-net/default.aspx

http://www.c-sharpcorner.com/uploadfile/4d56e1/connection-pooling-ado-net/default.aspx

http://www.c-sharpcorner.com/UploadFile/dsdaf/ConnPooling07262006093645AM/ConnPooling.aspx

http://www.c-sharpcorner.com/UploadFile/munnamax/connectionpooling08112007062332AM/connectionpooling.aspx

Thanks