Answer Posted / sagar

Data reader is a connection oriented architecture as its
requires continues connection with Data base.
while Data set is disconnected oriented architecture,
whenever user wants to pull the data he/she build the
connection with Data base.


-Data readers execution is very fast. as it reads only
forward stream.
while
Data set execution is slow as compare to Data reader, as it
carries bundle of data.


- when data changes requires frequently then User should go
for Data set, when user doesn't require data changes
frequently then he/ should go for Data Reader.

Describe the disconnected architecture of ADO.NET’s data access model.

1106

---

Explain the overview of ado.net architecture?

1116

---

Difference between sqlcommand and sqlcommandbuilder?

1183

---

Explain sqlconnection object?

1061

---

What is the use of ADO.NET and XML web services?

1088

---

What is serialization and de-serialization in .net? How can we serialize the dataset object?

1013

---

What is ado or jdbc?

977

---

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

1080

---

What are advantages of microsoft-provided data provider classes in ado.net?

1035

---

What are the parameters that control most of connection pooling behaviours?

1119

---

How to add a javaScript function in a datagrid?

1176

---

What are the benefits of using of ADO.NET in .NET 4.0?

1151

---

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?)

1052

---

How to pass values into a datatable?

1177

---

What does executenonquery () method return?

979

---