ADO.Net Interview Question and Answers

1. What is Ado.NET?
  • ADO.NET is an object-oriented set of libraries that allows you to interact with data sources.
  • ADO.NET is a set of classes that expose data access services to the .NET programmer.
  • ADO.NET is also a part of the .NET Framework.
  • ADO.NET is used to handle data access.
  • ADO.NET is entirely based on XML.
Pramod, said Apr 23,2014
ADO.NET is a set of computer software components that programmers can use to access data and data services based on disconnected DataSets and XML. It is a part of the base class library that is included with the Microsoft .NET Framework.
Your Name Your Email-ID
Your Answer
2. What are the two fundamental objects in ADO.NET?
  There are two fundamental objects in ADO.NET.
Datareader - connected architecture and
Dataset - disconnected architecture.
Your Name Your Email-ID
Your Answer
3. 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
  • System.Data.LINQ
Your Name Your Email-ID
Your Answer
4. What are major difference between classic ADO and ADO.NET?
  In ADO the in-memory representation of data is the recordset.A Recordset object is used to hold a set of records from a database table.
In ADO.NET we have dataset.A DataSet is an in memory representation of data loaded from any data source.
Your Name Your Email-ID
Your Answer
5. What is the use of connection object in
  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

13141516 Page 1 of 16