ADO.NET INTERVIEW QUESTION & ANSWERS
| 31. |
What is the difference between ADO.Net Dataset and ADO Record set? |
| |
ADO.Net Dataset you can retrieve data from two databases like oracle and sql server and merge them in one dataset with record set this is not possible.All representation of dataset is using XML while record set uses com.
ADO.Net Record set cannot be transmitted on HTTP while dataset can be.
|
| 32. |
How arc Rowstates used in ADO.NET? |
| |
The DataAdapter class uses Rowstates to extract modified, added, or deleted
records. |
| 33. |
What is dataset object? |
| |
The dataset provides the basic for disconnected storage and manipulation of relational data.
We fill it from a data store, work with it while disconnected from that data store, then reconnect and flush changes back to the data store if required. |
| 34. |
What is the use of System.Data namespace in ADO.Net? |
| |
System.Data : This contains the basic objects used for accessing and storing relational data such as dataset,datatable and data relation. |
| 35. |
What is the use of Sytem.Data.OLEDB namespace in ADO.Net? |
| |
Sytem.Data.OLEDB : It contains the object that we use to connect to a data source. These objects inherit the common base classes and to have the same properties, methods and events as the SqlClient equivalents. |
