Connection pooling, DOT NET Programming

Explain the fundamental of connection pooling.

Whenever a connection is opened first time a connection pool is created and is based on the exact match of the connection string given to create the connection object. This Connection pooling works only if the connection string is the same. If the connection string is different, then the new connection will be opened, and connection pooling won't be used.

Now try to describe the same pictorially. In the  figure above you can see that there are three requests viz. "Request1", "Request2" &  "Request3". "Request1" and "Request3" have same the connection string so no new connection object is created for the "Request3" as the connection string is same. They share the similar object "ConObject1". But the new object "ConObject2" is created for "Request2" as the connection string is different.

1222_connection pooling.png

Figure : -Connection Pooling action.

Posted Date: 9/24/2012 5:06:37 AM | Location : United States

Related Discussions:- Connection pooling, Assignment Help, Ask Question on Connection pooling, Get Answer, Expert's Help, Connection pooling Discussions

Write discussion on Connection pooling
Your posts are moderated
Related Questions
Need Data Stream from Laptop to Phone Project Description: I have a notepad file that is automatically generated in a set file name and format by acquisition software and wri

C# Programming 1. What is .Net Framework? 2. Write short notes on constructors and destructors. 3. Explain boxing and unboxing with examples. 4. What is a mixed mode a

This assignment requires you to design, develop and implement a token web application. It is intended to assess your mastery of the web application development concepts and ASP.NET

Define the ToolTip control. How can you associate it with other controls? The ToolTip control produces a small pop-up window with explanatory text for an element it is displaye

What is "Common Type System" (CTS)?  CTS define all of the basic types that can be used  in the .NET Framework and the operations performed on those type. All this time we have

Simple FB Integration in MS-SQL and ASP.NET I am seeking urgent project to be done, please I am interested in someone who will present demo for retrieving personal informatio

How can we load multiple tables in a DataSet? objCommand.CommandText = "Table1" objDataAdapter.Fill(objDataSet, "Table1") objCommand.CommandText = "Table2" o

What are indexes? The Indexes in the SQL Server are similar to the indexes in books. They help SQL Server to retrieve the data quickly.These are classified into clustered and n