Answer Posted / anju

- Data reader is a connection oriented architecture as its
requires continues connection with Data base.
while Data set is disconnected oriented architecture,
whenever user wants to pull the data he/she build the
connection with Data base.


-Data readers execution is very fast. as it reads only
forward stream.
while
Data set execution is slow as compare to Data reader, as it
carries bundle of data.


- when data changes requires frequently then User should go
for Data set, when user doesn't require data changes
frequently then he/ should go for Data Reader.

What are the advantage of ado.net?

521

---

Can we do database operations without using any of the ado.net objects?

535

---

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

528

---

Where is adodb dll located?

527

---

What DataReader class do in ADO.NET ?

588

---

---

Explain the two fundamental objects in ado.net?

507

---

How to connect and retrieve data from database using dataset

539

---

What you mean by filtering of data?

542

---

What is the difference between data reader and data adapter?

540

---

What is ole2 format?

504

---

What is aggregating data ?

513

---

What is data view and variable view?

487

---

What is dataadapter in ado.net?

497

---

How can I retrieve two tables of data at a time by using data reader?

513

---

Describe the command object and its method.

524

---