ADO.NET Interview questions


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

What are the differences between ADO and ADO.NET?

ADO (Active Data Objects):
1. ADO models are Connection-oriented Models
2. Disconnected Access provided by Record set
3. XML Support Limited
4. Clients work under Connected architecture
5. ADO objects communicate in binary mode
 
ADO.NET:
1. ADO.NET models are Disconnected models
2. Disconnected Access provided by Data Adapter and Data set
3. Full XML Support
4. Client disconnected as soon as the data is processed. DataSet is disconnected at all times
5. ADO.NET uses XML for passing the data



Next 5 interview question(s)

1
How to convert a DataSet into a DataReader?
2
Explain about ADO.NET namespaces which are required to connect database?
3
How to fill a DataSet?
4
How to connect a database through SqlConnection?
5
Explain the methods of DataAdapter.Update() and DataSetAcceptChanges()?

Comments