Difference between Dataset and DataReader ?
- 4 Answers
- 16378 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
when a request is made in Life cycle of ASP.NET page .
How many types of session state management options available in asp.net?
How do u declare static variable and how it is declared and what is its lifetime?
Write some code using interfaces, virtual methods, and an abstract class`
What are the types of caching in asp.net?
How would you get asp.net running in apache web servers?
What is the use of response redirect in asp.net?
Explain one critical mapping?
What is difference between abstract class and an interface?
Why do we need Sessions?
What is http session state?
If I am developing an application that must accomodate multiple security levels though secure login and my asp.net web application is spanned across three web-servers (using round-robin load balancing). What would be the best approach to maintain login-in state for the users?
Explain the difference between sql invalidation and sql notification.
What are sessions in asp net?
Define page output caching?
