Answer Posted / prakash tiwari

Data Reader will read only one record at a time.So memory
consumption will be less,it is purely connection oriented
it will use connection exclusively when datareader is
closed.the memory will be released on the server machine
and connection will be used for any other purpose.

Data Adapter acts as a mediator between dataset and
database server.
it will read data from the database server and places with
in dataset
the manipulations on the dataset will be updated with the
database server

What is the difference between ado.net and entity framework?

1095

---

Define partial class?

1026

---

What is ado connection?

1008

---

What is dbcontext and dbset in entity framework?

979

---

What do you know about ado.net's objects?

1073

---

What is an orm, and why would you use one instead of plain old ado.net?

1098

---

Is entity framework better than ado.net?

1075

---

How to copy the contents from one table to another table and how to delete the source table in ado.net?

1085

---

What is serialization and de-serialization in .net? How can we serialize the dataset object?

1017

---

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

1065

---

What is row state?

1034

---

What are the different methods by which we can populate a dataset?

1283

---

What does datareader object do?

1058

---

What DataReader class do in ADO.NET ?

1161

---

What are the benefits of ADO.NET?

1172

---