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);
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is connection pooling and what is the maximum pool size in ado.net connection string?
Can we do database operations without using any of the ado.net objects?
What is the difference between OLEDB Provider and SqlClient?
Is datareader faster than datatable?
What is difference between ado.net and asp net?
What are advantages of microsoft-provided data provider classes in ado.net?
How does ado.net work?
What is the role of the dataset object in ado.net?
How to retrieve the user id which is provided while windows authentication?
Which is the feature of ado.net?
What is partial class?
What is acid in ado.net?
How to connect and retrieve data from database using dataset
Explain the role of data provider in ado.net?
How can we perform transactions in .net?
