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

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.

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

6.	What are the benefits of ADO.NET?
	Scalability Data Source Independence Interoperability Strongly Typed Fields Performance

7.	What is a Clustered Index?
	The data rows are stored in order based on the clustered index key. Data stored is in a sequence of the index. In a clustered index, the physical order of the rows in the table is the same as the logical (indexed) order of the key values. A table can contain only one clustered index. A clustered index usually provides faster access to data than does a non-clustered index.

8.	What is a Non-Clustered Index?
	The data rows are not stored in any particular order, and there is no particular order to the sequence of the data pages. In a clustered index, the physical order of the rows in the table is not same as the logical (indexed) order of the key values.

9.	Whate are different types of Commands available with DataAdapter ?
	The SqlDataAdapter has SelectCommand InsertCommand DeleteCommand UpdateCommand

10.

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.