once data is fetched into dataset connection gets closed. but in datareader co

once data is fetched into dataset connection gets closed. but in datareader
connection is always maintained...then why datareader is fast and mainly
recommended ?

Question Posted / darshan.naokhare

2 Answers
5781 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

once data is fetched into dataset connection gets closed. but in datareader connection is always m..

Answer / hhh

DataSet carry considerable overhead because of relations,
multiple tables,
While DataReader only readony and fawardonly stream of
data, it fatch only one row at a time. thats y its faster

Is This Answer Correct ?

9 Yes

0 No

once data is fetched into dataset connection gets closed. but in datareader connection is always m..

Answer / abhishek

datareader is forwardonly thus is fast and is mostly used
while retrieving the data from the database.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

Difference between ADO and ADO.Net

4 Answers IBM,

What is executequery?

0 Answers

Explain the various objects in dataset.

0 Answers

Difference between datareader and dataset?

26 Answers Microsoft, Noel Infotech, Satyam, Value Labs,

Is datareader faster than datatable?

0 Answers

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

0 Answers

What is the difference between sqldatareader and sqldataadapter?

0 Answers

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

0 Answers

What is bubbled event?

0 Answers

What is the provider and namespaces being used to access oracle database?

5 Answers E2E, Microsoft,

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers

Why DataReader is Forward Only?

16 Answers IBM, NIIT,

For more ADO.NET Interview Questions Click Here