FeedBack Form

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

ADO.NET INTERVIEW QUESTION & ANSWERS

26. What are the data access namespaces in .NET?
  The most common data access namespaces :
  • System.Data
  • System.Data.OleDb
  • System.Data.SQLClient
  • System.Data.SQLTypes
  • System.Data.XML
Your Name Your Email-ID
Your Answer
 
27. What is the difference between Dataset and Data reader?
  Data Reader provides forward only and read only access to data, while the Data set objects can hold more than one table from the same data source as well as the relationships between them.
Dataset is a disconnected architecture while data reader is connected architecture.Dataset can persist contents while data reader cannot persist contents they are forward only.
Your Name Your Email-ID
Your Answer
 
28. What is the use of data adapter?
  This object act as a bridge between data store and dataset.
Your Name Your Email-ID
Your Answer
 
29. What two classes are used to execute arbitrary SQL commands in a database using ADO.NET?
  The Sqlcommand and Oledb command classes are used to execute SQL Commands using ADO.NET.
Your Name Your Email-ID
Your Answer
 
30. What is the use of connection object in ado.net?
  The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database.
Your Name Your Email-ID
Your Answer