Answer / debadutta

ADO.Net uses
1) Oledb
2) ODBC
3) JET Providers

Answer / vivek

Before ado.net 2.0 they give only interfaces to implemetn
them then every provider started implementing on their own
way so problem araised with these implementation.
From ado.net2.0 it gives abstract classes like DbConnetion
to providers.Then the providers create classes to implement
those abstract classes.
Ex:SqlConnection,OracleConnection.
with thses abstract classes we can connect to any backend.

Answer / shwetha

Data Reader
and
Data Adaptor

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

1 Answers  

---

What are the namespaces used in ado.net for data access?

1 Answers  

---

Which keyword is used to accept variable number of parameters?

1 Answers  

---

What are the pre-requisites for connection pooling?

1 Answers  

---

What is ado control?

1 Answers  

---

WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE

2 Answers  

---

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers  

---

What provider ado.net use by default? Explain the role of data provider in ado.net?

1 Answers  

---

Which type of database is used while processing dynamic database?

1 Answers   Microsoft,

---

Differentiate between Dataset and Recordset.

2 Answers  

---

What is full form of ado?

1 Answers  

---

What does sqldatareader return?

1 Answers  

---