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
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)

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