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

Want a new e- payment gateway, Project Description: I want a new payment...

Project Description: I want a new payment gateway of my own. Anyone who has previous experience in preparing a new payment gateway. I mean new payment gateway not any integratio

What is extensible markup language, What is Extensible Markup Language (XML...

What is Extensible Markup Language (XML). XML is an easy and flexible mark-up language in the text format. Nowadays, it is widely used to exchange a large variety of data over

Develop a new website, I need to develop a new website. Previous site was n...

I need to develop a new website. Previous site was not good and I need better one with not only static but using also more details . Skills required: .NET, MySQL, C# Programm

Readymade erp for college, Project Description: College erp Erp key f...

Project Description: College erp Erp key features: Panacea ERP Online Suite is server based college based management software. Gives Password facility for different use

Textile pro, Could not find any resources appropriate for the specified cul...

Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "Textilepro.frmLogin.resources" was correctly embedded or linked into assembly

Web-app developer for startup, Web-App Developer for Startup Project Des...

Web-App Developer for Startup Project Description: I am seeking someone who is good at building dynamic sites that will run on both desktops and tablets. The core of the w

Explain the dataadapter.update, Explain the DataAdapter.Update() and DataSe...

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods. The DataAdapter.Update() method calls any of the DML statements, like UPDATE, INSERT, or DELETE statements,

Differentiate between managed and unmanaged code, Differentiate between man...

Differentiate between managed and unmanaged code? Managed code is the code that is implemented directly by the CLR instead of the operating system. The code compiler first comp

What are code contracts, What are code contracts? Code contracts help y...

What are code contracts? Code contracts help you to state the code assumptions and statements stating the behavior of your code in a language-neutral way. The contracts are con

Write an application in c# or c++, Project Description: We are seeking s...

Project Description: We are seeking someone who can write a program in C# or C++. The idea is to prepare the program using a Cross Platform environment like Mono or Qt which

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