ADO.Net Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1988 Page Views: 

Explain ADO.Net connection pooling?



Posted By: Avi Date: 4 September 2009 07:05:56 AM
 Answer:

Connecting to a database server typically consists of several time-consuming steps. ADO.Net uses an optimization technique to increase the performance of any application by reusing active connections from the pool for consecutive requests. This optimization technique is known as connection pooling.


Posted By: eTechPlanet


Date: 4 September 2009 07:05:56 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image QmZ8ik
Related Questions
ADO.Net : How do you create dataset object and populate it with data from c# code?

How do you create dataset object and populate it with data from c# code?

DataSet ds = new DataSet(); ds.Tables.Add(new DataTable()); ds.Tables[0].Columns.Add(“col1”); ds.Tab....
Category: ADO.Net Date: 10/14/2010 1:54:47 PM
ADO.Net : What is MARS technology?

What is MARS technology?

Multiple Active Results Sets. It’s a technology that allow applications to maintain multiple active ....
Category: ADO.Net Date: 10/14/2010 1:11:48 PM
ADO.Net : How do use CommandBuilder class?

How do use CommandBuilder class?

CommandBuilder objects generates INSERT, UPDATE, DELETE statements for a DataTable based on Select q....
Category: ADO.Net Date: 10/14/2010 11:17:47 AM
ADO.Net : How can you access children of XmlNode?

How can you access children of XmlNode?

By using Item[“node name”] property or ChildNodes collection
Category: ADO.Net Date: 10/14/2010 10:25:48 AM
ADO.Net : How do you check if connection to SQL server is open?

How do you check if connection to SQL server is open?

By using ConnectionState property
Category: ADO.Net Date: 10/14/2010 10:15:48 AM