Diff. b/w DataReader and DataSet?

Answer Posted / santosh

data reader is the connection oriented architecture, it is
forward approach, and its give more perfomanc, datareader is
only read the data.
dataset is the disconnection oriented architecture, it is
forward and backward approach and it is slow compare to
datareader, dataset is read and write.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to call the sql commands asynchronously in ado.net version 2.0?

498


What is maximum pool size in ado.net connection string?

494


What are the benefits of using ado.net?

512


Explain sqlconnection object?

530


What are the core objects of ADO.NET?

582






Define atomicity?

573


Which is faster datareader or dataadapter?

520


What are the different methods available under the sqlcommand class to access the data?

571


What is the difference between an ADO.NET Dataset and an ADO Recordset?

543


What is a datareader object?

575


What are the ado.net connection pooling parameters?

459


What is ado.net in vb net?

498


What are all features of ADO.Net?

544


How will you fill the gridview by using datatable object at runtime?

546


What provider ado.net use by default? Explain the role of data provider in ado.net?

521