Answer Posted / tejas mer

ADO.Net provides the base classes to access the or deal with DataBase.

The classes or namespaces depends on the type of provider we are using (like Sytem.Data.SqlClient for SQL Sever or System.Data.Oracleclient) for Oracle...

It also contains few common classes like
DBConnection
DBCommand to establish connection and execute commands respectively..

Below are the list of the classes widly used from ADO.NEt

DataSet
SQLConnection
SQLCommand
SQLDataAdapter
DataTable
DataView
SQLDataReader


Few methods widly used

DataSet.AcceptChanges();
Dataset.RejectChanges();

DataReader.ExecuteNonQuery();
DataReader.ExecuteScalar();
DataReader.ExecuteReader();


DataAdapter.Fill(DataSet);

Do you use stored procedure in ado.net?

990

---

How would you connect to database using .NET?

977

---

What are all features of ADO.Net?

924

---

Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

1083

---

What is the use of Dataview?

1060

---

What is ole word?

889

---

What is Data view?

1002

---

What providers does Ado.net uses?

943

---

Is entity framework better than ado.net?

920

---

What is dataset object? Explain the various objects in dataset.

978

---

What are the methods of XML dataset object?

983

---

What is ado rdo dao in visual basic?

1094

---

Explain all the classes those are used for database connections between sql server and asp.net?

949

---

What is the advantage of ado.net?

949

---

Which object is used to add relationship between two Datatables?

975

---