1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

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

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

How to find the given query is optimised one or not?

0 Answers  

What are the steps in connecting to database?

3 Answers   IBM, Microsoft,

What are the Features and disadvantages of dataset

0 Answers   Microsoft,

Is it possible to edit data in Repeater control?

0 Answers  

What is bubbled event?

0 Answers  




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

0 Answers  

what is a dataset?

9 Answers   Choice Solutions,

Describe ado.net object model in detail.

0 Answers  

How to read data with the sqldatareader ?

0 Answers  

What is the difference between dataset and datatable?

0 Answers  

How do you implement locking concept for dataset?

0 Answers  

Define partial class?

0 Answers  

For more ADO.NET Interview Questions Click Here
Categories