ADO.NET INTERVIEW QUESTION & ANSWERS
| 46. |
What are good ADO.NET objects to replace the ADO Recordset object? |
| |
DataSet |
| 47. |
Why two interfaces can be used to abstract the SQL and OLE DB data providers? |
| |
You can use the IDataReader, IDbCommand, and IDataAdapter classes to abstract the data provider. |
| 48. |
What is the difference between "Optimistic" and "Pessimistic" locking? |
| |
In Pessimistic locking when user wants to update data it locks the record and till then no one can update data.
In Optimistic locking multiple users can open the same record for updating, thus increase maximum concurrency.
|
| 49. |
What is the DataTableCollection? |
| |
An ADO.NET DataSet contains a collection of zero or more tables represented by DataTable objects. The DataTableCollection contains all the DataTable objects in a DataSet. |
| 50. |
What providers does Ado.net uses? |
| |
The .NET Framework provides mainly three data providers, they are- Microsoft SQL Server
- OLEDB
- ODBC
|
