Interview question for Ado.Net in .NET

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.

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.

3. 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.

4. 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.

5. What are the benefits of ADO.NET?

Scalability Data Source Independence Interoperability Strongly Typed Fields Performance

6. What are the advantage of ADO.Net?

Database Interactions Are Performed Using Data Commands Data Can Be Cached in Datasets Datasets Are Independent of Data Sources Data Is Persisted as XML.

7. What is a Command Object?

The ADO Command object is used to execute a single query against a database. The query can perform actions like creating, adding, retrieving, deleting or updating records.

8. What is the use of Connection Object?

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.

9. What is the use of Parameter Object?

In ADO Parameter object provides information about a single parameter used in a stored procedure or query.

10. What does ADO mean?

ADO stands for ActiceX Data Objects.It was introduced few years ago as a solution to accessing data that can be found in various forms, not only over a LAN but over the internet. It replaced the data access technologies RDO(Remote Data Objects) and DAO (Data Access Objects).

11. Name some ADO.NET Objects?

Connection Object DataReader Object Command Object DataSet Object DataAdapter Object

12. Explain ADO.Net Architecture?

ADO.NET provides the efficient way to manipulate the database. It contains the following major components. 1. DataSet Object 2. Data Providers : Connection Object Command Object DataReader Object DataAdapter Object.

13. What is the role of the DataReader class in ADO.NET connections?

It returns a read-only, forward-only rowset from the data source. A DataReader provides fast access when a forward-only sequential read is needed.

14. What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. OLE-DB.NET is a .NET layer on top of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET.

15. What is the use of connection?

Establishes a connection to a specific data source.

16. What providers does uses?

The .NET Framework provides mainly three data providers, they are Microsoft SQL Server, OLEDB, ODBC.

17. What is the difference between an ADO.NET Dataset and an ADO Recordset?

A DataSet can represent an entire relational database in memory, complete with tables, relations, and views. A DataSet is designed to work without any continuing connection to the original data source. DataSets have no current record pointer You can use For Each loops to move through the data. Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources. Data in a DataSet is bulk-loaded, rather than being loaded on demand. You can store many edits in a DataSet, and write them to the original data source in a single operation.