Answer Posted / vivek

using Connection object
SqlConnectin cn=new SqlConnection();
from .net we can connect to any backend with middlleware
and direct connections.
middleware means ODBC,OleDb,ISAM etc.
we can directly connect to Sqlserver and Oracle
we can connect to sql server in 4 ways
1)direct connection
2)ODBC way
3)OleDb way
4)Express way
for oracle we can connect in 3 ways.
1)direct connection
2)ODBC way
3)OleDb way

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

955

---

What is microsoft ado.net?

1076

---

What are two important objects of ADO.Net?

978

---

What is ado data control?

948

---

Which property is used to check whether a DataReader is closed or opened?

1000

---

What is bubbled event can you please explain?

973

---

How do you connect to sql server database without using sqlclient?

1053

---

What is the DataTableCollection?

1008

---

What are the types of databinding?

938

---

Name which operations can you not perform on an ado.net dataset?

932

---

How do you merge 2 datasets into the third dataset in a simple manner?

948

---

What is execute scalar in ado.net?

909

---

Does sqlclient and oledb class share the same functionality?

880

---

Why do we need ado.net?

914

---

What is an ado connection?

924

---