ADO.NET INTERVIEW QUESTION & ANSWERS
| 66. |
What do managed providers do? |
| |
They provide the interface for communication between data stores and DataSets. The two managed providers for ADO.NET are :.
|
| 67. |
What is the use of parameter object? |
| |
Parameter object is used to pass the parameter value to a stored procedure. |
| 68. |
What is the difference between an ADO.NET Dataset and an ADO Recordset? |
| |
There are two main differences are : - Dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset.
- Recordset this is not possible
-
All representation of Dataset is using XML while recordset uses COM.
- Recordset can not be transmitted on HTTP while Dataset can be.
|
| 69. |
What are good ADO.NET object(s) to replace the ADO Recordset object?
|
| |
DataSet. |
| 70. |
What type of data model does an OleDbCommand object fill? |
| |
An ADODataReader object. |
