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.

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

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

Comments