ADO.Net Interview Question and Answers
| 11. |
What is a DataSet? |
| |
A DataSet is an in memory representation of data loaded from any data source. |
| |
|
| 12. |
What is a DataTable? |
| |
A DataTable is a class in .NET Framework and in simple words a DataTable object represents a table from a database. |
| |
|
| 13. |
What is the data provider name to connect to Access database? |
| |
Microsoft.Access |
| |
|
| 14. |
Which namespaces are used for data access? |
| |
- System.Data
- System.Data.OleDB
- System.Data.SQLClient
|
| |
|
| 15. |
What is difference between dataset and datareader? |
| |
- DataReader provides forward-only and read-only access to data, while the DataSet object can hold more than one table (in other words more than one rowset) from the same data source as well as the relationships between them.
- Dataset is a disconnected architecture while datareader is connected architecture.
- Dataset can persist contents while datareader can not persist contents, they are forward only.
|
| |
|
Gk Questions with Answers