Answer / Akanksha Chauhan

To improve the performance of ADO.NET applications, you can follow these steps: 1) Use parameters instead of string concatenation to prevent SQL injection attacks and improve query performance. 2) Use CommandBehavior.SequentialAccess when dealing with large amounts of data to read data in chunks instead of all at once. 3) Use typed datasets or DataTables instead of untyped datasets for better performance and type safety. 4) Avoid unnecessary round trips to the database by using caching strategies like Query Notification and DataSet Caching. 5) Optimize SQL queries by using indexes, joining tables efficiently, and reducing the number of subqueries.

What is basic use of data view?

1 Answers  

---

What is untyped dataset?

1 Answers  

---

Describe datareader object of ado.net with example.

1 Answers  

---

What are the different layers of ado.net?

1 Answers  

---

what is the criteria of selection in sbi interview?

1 Answers   BCS, State Bank Of India SBI,

---

ADO and ADO.NET differences?

3 Answers   Microsoft,

---

What are the data access namespaces in .NET?

1 Answers  

---

Difference between OLEDB Provider and SqlClient ?

2 Answers  

---

What are typed and untyped dataset?

1 Answers  

---

What is ado object model?

1 Answers  

---

What is the provider and namespaces being used to access oracle database?

4 Answers   Microsoft,

---

What are the two fundamental objects in ADO.NET?

6 Answers  

---