ADO.NET INTERVIEW QUESTION & ANSWERS
26. |
What are the data access namespaces in .NET? |
|
The most common data access namespaces :
- System.Data
- System.Data.OleDb
- System.Data.SQLClient
- System.Data.SQLTypes
- System.Data.XML
|
27. |
What is the difference between Dataset and Data reader? |
|
Data Reader provides forward only and read only access to data, while the Data set objects can hold more than one table from the same data source as well as the relationships between them. Dataset is a disconnected architecture while data reader is connected architecture.Dataset can persist contents while data reader cannot persist contents they are forward only.
|
28. |
What is the use of data adapter? |
|
This object act as a bridge between data store and dataset. |
29. |
What two classes are used to execute arbitrary SQL commands in a database using ADO.NET? |
|
The Sqlcommand and Oledb command classes are used to execute SQL Commands using ADO.NET. |
30. |
What is the use of connection object in ado.net? |
|
The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database. |