Here you can find ADO.NET Interview Questions and Answers.
In this ADO.NET Interview Questions and Answers section you can learn and practice ADO.NET Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any ADO.NET interview.
AllIndiaExams provides you lots ADO.NET Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download ADO.NET Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of ADO.NET Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the ADO.NET technical interview.
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.
What are the two fundamental objects in ADO.NET?
There are two fundamental objects in ADO.NET. Datareader - connected architecture and Dataset - disconnected architecture.
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.
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
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.
What are the benefits of ADO.NET?
Scalability Data Source Independence Interoperability Strongly Typed Fields Performance
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.
Whate are different types of Commands available with DataAdapter ?
The SqlDataAdapter has SelectCommand InsertCommand DeleteCommand UpdateCommand
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.
What are the parameters that control most of connection pooling behaviors?
Connect Timeout Max Pool Size Min Pool Size Pooling