Connection Pooling in ADO.NET

Question

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?

Satyapriya Nayak · Answer

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

Senthilkumar · Answer

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