What is the difference between a Dataset and DataReader?
Can dataReader hold data from multiple tables?
- 3 Answers
- 7996 Views
- Fulcrum Logic, Merrill Lynch, I also Faced
- E-Mail Answers
Answer Posted / naresh
Data reader:
1. It is a read only and forward only data access to data.
2. You can access one table at time.
3. It can't persist the data.
4. It is comes under connected architecture.
5. One of the most advantage is it is much faster than Data
Adapter
Data set:
1. It can access multiple tables at a time.
2. It can persist the data.
3. It is a relational data cache hosted in application
domain during execution.
4. It is a disconnected architecture.
5. It can't define with out data adapter.
Yes.dataReader hold data from multiple tables. The SELECT
statement may have columns that belong to one or more
"tables in the database". By example using a JOIN
or something similar.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the difference between DataReader and DataSet in ADO.NET?
What is the namespaces being used to access oracle database?
Where is adodb dll located?
What do you know about ado.net's methods?
What is ado in agriculture?
Can datareader hold data from multiple tables?
What is difference between executenonquery and executequery?
Define Execute Scalar?
What is the default Timeout for SqlCommand.CommandTimeout property?
Which is better entity framework or ado.net?
What is connection in ado.net?
What are the key features of ado.net?
What is ado control?
How does entity framework work?
What is a serialized object?
