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.

Which control of the BindingNavigator returns the current position within the data source?

1208

---

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

1078

---

What is data view and variable view?

972

---

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

1064

---

What are the 3 major types of connection objects in ado.net?

1050

---

Explain the difference between an ado.net dataset and an ado recordset?

1106

---

What is the difference between connected and disconnected environment?

1171

---

How do you merge 2 datasets into the third dataset in a simple manner?

1057

---

What is aggregate root?

1187

---

Which method is used to sort the data in ADO.Net?

2026

---

What is the significance of CommandBehavior.CloseConnection ?

1212

---

Define table relations?

1032

---

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

1016

---

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

1057

---

What is datatable in ado.net?

1007

---