Difference between datareader and dataset?
Answer Posted / abhijeet kumar sharma
DataReader is faster for read data.DateReader is readonly
propurse,DataReader read data between reader Read() and
close() methods.When we read data from database help of
DataReader then database connection is must open.
DataSet is disconnected architecture. We store multiple
data at a time in dataset.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is command class in ado.net?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
What does executenonquery () method return?
What is a datareader object?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What is difference in record set and dataset?
Why do we serialize data?
What are the parameters that control most of connection pooling behaviors?
Define ado.net?
What is XML serialization
What is difference between executenonquery and executequery?
Explain sqlconnection object?
How would you connect to database using .NET?
Define Execute Reader?
How to identify the updated rows in a dataset?