ADO.NET INTERVIEW QUESTION & ANSWERS
| 71. |
What is difference between Optimistic and Pessimistic locking? |
| |
- Optimistic locking multiple users can open the same record for updating, thus increase maximum concurrency.
- Record is only locked when updating the record.
- Pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other user's can only view the data when there is pessimistic locking
|
| 72. |
Does an OleDbCommand object need to be closed? |
| |
No, only the OleDbDataReader and OleDbConnection object need to be closed explicitly. |
| 73. |
What is method to get XML and schema from Dataset? |
| |
getXML () and get Schema () |
| 74. |
What method is used to populate a dataset using an XML file? |
| |
Use the ReadXml method from the DataSet class. |
| 75. |
What is basic use of DataView? |
| |
DataViewrepresents a complete table or can be small section of rows depending on
some criteria. It is best used for sorting and finding data with in datatable.Dataview has the following methods - Find
- FindRow
- AddNew
- Delete
|
