Answer Posted / mukul anand

Datareader object is used to directly connect with the data
source and Dataset object is used to create a cache of the
original data source and then retrieve or update the date in
the dataset. It is a disconnected enviornment.

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

538

---

What are the namespaces used in ado.net for data access?

479

---

What is data access pattern?

493

---

What is executequery?

496

---

What is data view and variable view?

487

---

---

Explain the basic use of "dataview" and explain its methods.

529

---

What does ado stand for in ado.net?

456

---

What is disconnected data?

578

---

What is the use of ADO.NET and XML web services?

594

---

What is ado object model?

515

---

Do we use stored procedure in ADO.Net?

574

---

What is the return type of executescalar?

495

---

What is commandbuilder in ado.net?

526

---

What is maximum pool size in ado.net connection string?

499

---

What is defaultview in datatable?

535

---