Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Dataset and DataReader?
Can dataReader hold data from multiple tables?
- 3 Answers
- 9345 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
Does ado.net use odbc?
How we can provide data to ado.net?
How can we serialize the dataset object?
What is ado connection?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What is the difference between ADO and ADO.Net?
Explian About DataAdapters
What is sql command in ado net?
Is ado.net an orm?
Explain the advantages and disadvantages of using datalist?
What is ado.net explain with diagram?
What is ado.net in mvc?
What do you know about ado.net's methods?
What is the meaning of executenonquery?
How do you update database through dataset?
