ADO.NET Interview questions


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

Explain differences between Dataset and Datareader?

Dataset:

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
 

Datareader:

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)

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

Comments