Answer / Chandan Kumar Keshri

ADO.NET has three main layers: Connection layer, Command layer, and Data Container layer. The Connection layer is responsible for establishing a connection to the data source; the Command layer is used for sending commands to the data source and retrieving data; and the Data Container layer manages data in memory.

Can we load multiple tables in a dataset?

1 Answers  

---

Is datareader faster than datatable?

1 Answers  

---

What are datareaders?

1 Answers  

---

Define data adapter?

1 Answers  

---

What is the difference between an ADO.NET Dataset and an ADO Recordset?

1 Answers  

---

What is ODP.NET?

2 Answers   Microsoft,

---

What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?

1 Answers   TCS,

---

How to identify the controls which can be used for binding data?

1 Answers  

---

What is the difference between Command and CommandBuilder object?

1 Answers  

---

What are the steps you will take to improve performance?

1 Answers  

---

Which provider is used to connect ms access, oracle, etc…?

1 Answers  

---

How do u implement locking concept for dataset?

2 Answers   ABC,

---