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
- 9334 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 sqldatareader and sqldataadapter?
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....
What is the difference between DataReader and DataSet in ADO.NET?
What is the use of SqlCommand object?
What is partial class?
What is an ado?
What you mean by filtering of data?
What is a column variable?
Which object is used to add relationship between two Datatables?
Explain ado.net features?
How is entity framework different from ado.net?
What is the difference in an abstract class and an interface?
What is a sqldataadapter?
How to add a javaScript function in a datagrid?
Is bulk insert faster than insert?
