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
5925 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

ADO.NET is Disconnected Architecture. DataReader is connected Architecture, but DataReader is a part of ADO.NET. How is it possible?

3 Answers Zensar,

Can you edit data in the Repeater control?

9 Answers

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

0 Answers Infosys, Wipro,

What is the role of clr?

0 Answers

How to add a check box or a dropdown list to a column in a datagrid?

0 Answers

What are the objects of ado.net?

0 Answers

What is datatable?

3 Answers

What is difference between datagridview and datagrid control in winforms?

0 Answers

Why do we need ado.net?