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 serialization and de-serialization in .net? How can we serialize the dataset object?
What is ado connection?
What is defaultview in datatable?
Which object holds only data and does not interact with data source?
What is the difference between statement and preparedstatement interface?
What is meant by executenonquery?
Define bubbled event?
Explain executenonquery?
Which architecture does Datasets follow?
What is the default Timeout for SqlCommand.CommandTimeout property?
Which method in OLEDBAdapter is used to populate dataset with records?
What are the steps you will take to improve performance?
What is isolation?
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?
What is the default timeout specified for "sqlcommand.commandtimeout" property?