ADO.NET Interview questions

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

Explain differences between Dataset and Datareader?


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 4 interview question(s)

What is the use of SqlParameter.Direction?
What is the full-form of ADO?
Is it possible to update the database by using SqlDataReader?
How can a user determine which SQL commands are part of a transaction?