Difference between Dataset and DataReader ?
Answer Posted / umamahadevan
DataSet
Data set can be said as a temporary data base which works
on disconnected architecture which stores schema and data
in application memory area..It fetches all data at a time..
DML is entertained here
DataReader
Datareader is like a forward only recordset. It fetches one
row at a time.DataReader is readonly so we cannot do any
transaction on them. DataReader will be the best choice
where we need to show the data to the user which requires
no transaction ie reports. Due to DataReader is forward
only we cannot fetch the data randomly. .NET Dataproviders
optimizes the datareaders to handle the huge amount of data.
Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
What is the adavantage of using ASP.NET routing?
What is application in asp net?
What is jade template engine?
What is the full form of asp.net?
What is the asp.net control toolkit?
Which method do you use to kill explicitly a users session?
Is asp.net web forms dead?
Disable Mouse right click on web page in asp.net?
Explain different types of validators in asp.net?
What is connection pooling and how to enable and disable connection pooling?
Differentiate globalization and localization.
Where is the view state data stored?
What is meant by server side scripting?
What is state management in .net?
How do you declare static variable? What is its lifetime?