Connection pooling, DOT NET Programming

Assignment Help:

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.


Related Discussions:- Connection pooling

Digital invy - inventory management, Project Description: Digital invy -...

Project Description: Digital invy - inventory management Main Features User friendly windows based software Multi Branch Multi company facility Multi user Integra

Difference between convert.tostring and .tostring() method, What is the dif...

What is the difference between Convert.toString and .toString() method To know the difference between Convert.toString and .toString() see the below code : int i =0; Mess

Propose an object oriented design and show drawback, Project Description: ...

Project Description: Simple task and requirements to be done professionally. Propose an Object Oriented design and show drawback. .NET, C Programming, Business Analysis, P

Find out the factorial - c# program, Find out the Factorial - C# Program ...

Find out the Factorial - C# Program I've been trying so many codes for this but those codes didn't work well. Please write the code for find out the factorial of an integer nu

I want a c# windows app, I want a C# Windows App Project Description: ...

I want a C# Windows App Project Description: Windows App written in C# that can: Check for Internet connection Load dynamic web site If Internet connection drops rec

I want to develop a real state website, Develop real state website We wa...

Develop real state website We want a programmer who is talented to create a website using html5, css3, jQuery, php, MySQL. All connected to a CRM to manage all the information f

Program for declaration and additions of variables in c#, Program for Decla...

Program for Declaration and Additions of Variables, I am a learner of C# language and i am struggling with the declaration of variables in C#. Can you have any code examples for th

Steps involved to fill a dataset, What are the steps involved to fill a dat...

What are the steps involved to fill a dataset ? The sample code is shown below: Private Sub LoadData() Dim strConnectionString As String strConnectionString = AppSetti

Web application and xml data storage, Web application and XML data storage ...

Web application and XML data storage One person should create a library (Java package of classes) for managing the list of bibliography entries, and for saving and loading th

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd