ADO.NET Interview questions

Total available count: 25
Subject - Microsoft Technologies
Subsubject - ADO.NET

What are the two fundamental objects in ADO.NET?

DataSet and DataReader are two fundamental objects in ADO.NET.

1. Dataset is a in-memory representation of database
2. DataSet is a disconnected orient architecture that means there is no need of active connections during work with datasets and it is a collection of DataTables and relations between tables
3. Dataset is readable and writable
4. Its possible to write and read XML data
1. Datareader is connected mode, and read and forward-only Data
2. DataReader will fetch the data very fast when compared with Dataset
3. Datareader is readonly

Next 5 interview question(s)

What is Diffgram in ADO.NET? When do we use Diffgram?
What is the importance of ExecuteNonQuery, ExecuteReader and ExecuteScalar methods in SqlCommand?
What is the purpose of database transactions?
Explain differences between Dataset and Datareader?
What is the use of SqlParameter.Direction?