Answer / Subhiksha Jaiswal

Connection Pooling is a technique used to reuse database connections instead of creating new ones every time an application needs to access the database. This reduces the time required to establish a connection, improving performance. The maximum pool size can be configured using the 'Max Pool Size' parameter in the ADO.NET connection string.n```csharpnSqlConnectionStringBuilder cb = new SqlConnectionStringBuilder(); // Initialize Connection String Buildernc?.MaxPoolSize = 100; // Set Maximum Pool SizensqlConnection con = new SqlConnection(cb.ToString()); // Connect using the configured connection stringn```

What providers does ado.net uses internally ?

3 Answers   Digital GlobalSoft,

---

What are the ado.net connection pooling parameters?

1 Answers  

---

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

2 Answers  

---

What do you mean by performing asynchronous operation using command object?

1 Answers  

---

How many commands does the oledbcommand takes?what are they?

2 Answers  

---

Give few examples of datareader that is used in different dataproviders.

1 Answers  

---

What provider ado.net use by default? Explain the role of data provider in ado.net?

1 Answers  

---

What are two important objects of ADO.Net?

1 Answers  

---

What is data reader in ado.net?

1 Answers  

---

Define table relations?

1 Answers  

---

I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...

6 Answers  

---

what are the two key events for the sql connection class? explain the differnce between the two.

2 Answers   HCL, NIIT, Zensar,

---