ADO.Net Interview Question and Answers

6. What are the benefits of ADO.NET?
  • Scalability
  • Data Source Independence
  • Interoperability
  • Strongly Typed Fields
  • Performance
Your Name Your Email-ID
Your Answer
7. What are the parts of ADO.NET?
  ADO.NET is divided into the Dataset object for manipulating disconnected data and the .NET Data Providers for communicating with backend data stores and the Dataset.
Your Name Your Email-ID
Your Answer
8. Whate are different types of Commands available with DataAdapter ?
    The SqlDataAdapter has
  • SelectCommand
  • InsertCommand
  • DeleteCommand
  • UpdateCommand
Your Name Your Email-ID
Your Answer
9. What is the difference between an ADO.NET Dataset and an ADO Recordset?
  • Dataset can fetch source data from many tables at a time, for Recordset you can achieve the same only using the SQL joins.
  • A DataSet can represent an entire relational database in memory, complete with tables, relations, and views, A Recordset can not.
  • A DataSet is designed to work without any continues connection to the original data source; Recordset maintains continues connection with the original data source.
  • DataSets have no current record pointer, you can use For Each loops to move through the data. Recordsets have pointers to move through them.
Your Name Your Email-ID
Your Answer
10. What are the parameters that control most of connection pooling behaviors?
  • Connect Timeout
  • Max Pool Size
  • Min Pool Size
  • Pooling
Your Name Your Email-ID
Your Answer

13141516 Page 2 of 16