Difference between Dataset and DataReader ?
- 4 Answers
- 16362 Views
- Accenture, BirlaSoft, Infosys, Microsoft, Techseol, I also Faced
- E-Mail Answers
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 appSettings Section in the web.config file?
Differentiate between namespace and assembly.
Explain how cookies work.
What is the difference between application state and caching?
Tell me what is the request flow used for asp.net mvc framework? : asp.net mvc
Explain the difference between debug.write and trace.write?
Where session id is stored?
Securitywise What are the Enhancements in 2.0?
Explain diff. Betn dataset and recordset?
When does a session actually start?
What are the components of ado.net?
What is cache in asp net?
Is asp.net and .net same?
Explain about Application and Session Events ?
Where is the view state data stored?
