FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

ADO.NET INTERVIEW QUESTION & ANSWERS

Follow Us
 
46. What are good ADO.NET objects to replace the ADO Recordset object?
  DataSet
Your Name Your Email-ID
Your Answer
 
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.
Your Name Your Email-ID
Your Answer
 
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.
Your Name Your Email-ID
Your Answer
 
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.
Your Name Your Email-ID
Your Answer
 
50. What providers does Ado.net uses?
  The .NET Framework provides mainly three data providers, they are
  • Microsoft SQL Server
  • OLEDB
  • ODBC
Your Name Your Email-ID
Your Answer