Answer Posted / santosh

data reader is the connection oriented architecture, it is
forward approach, and its give more perfomanc, datareader is
only read the data.
dataset is the disconnection oriented architecture, it is
forward and backward approach and it is slow compare to
datareader, dataset is read and write.

What is commandbuilder in ado.net?

1100

---

What is defaultview in datatable?

1074

---

What is ado.net explain with diagram?

1018

---

What is ado.net code?

974

---

Which is faster ado.net or linq?

1066

---

What are all the different methods under sqlcommand?

1031

---

How to identify the updated rows in a dataset?

1054

---

Which ado.net object is very fast in getting data from the database?

1149

---

Does ado.net use odbc?

999

---

What is variable view?

924

---

Why ca not we use multiple inheritance and garbage collector paralelly in .net?

1053

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

932

---

Explain sqlconnection object?

1067

---

What is the difference between Optimistic and Pessimistic locking?

1038

---

What are the connected and disconnected modes in ado.net?

965

---