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);

Which ado.net object is very fast in getting data from the database?

1101

---

What is the difference between ado.net and oledb?

941

---

What Is Difference Between Ado And Ado.net?

1031

---

What is an orm, and why would you use one instead of plain old ado.net?

1045

---

How to store data in memory?

947

---

What is a data control clerk?

1041

---

Why do we serialize data?

939

---

What are the ado.net components?

1017

---

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

974

---

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

999

---

What are the 3 major types of connection objects in ado.net?

998

---

What is the difference between statement and preparedstatement interface?

995

---

What are the essential features of ado.net?

949

---

differences between ADO and ADO.NET

1068

---

can we create synonymn in ms access,sql server,my sql if so explain me with example

2082

---