Ado.net Interview Question

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

·         What are the benefits of ADO.NET?

·         What is the use of connection object in ado.net?

·         What are major difference between classic ADO and ADO.NET?

·         What are the two fundamental objects in ADO.NET?

·         Which namespaces are required to enable the use of databases in ASP.NET pages?

·         Explain the Differences between OLEDB SQL SERVER, OLEDBDOTNET PROVIDER?

·         Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?

·         what is difference between ADO.NET vs ADO

·         What is T-SQL ?

·         What are basic methods of Data adapter?

·         What is the namespace in which .NET has the data functionality class?

·         what are the various objects in dataset?

·         Eexplain the difference between an ADO.NET Dataset and an ADO Recordset?

·         What happens when you apply AcceptChanges() method on a DataSet?

·         What are internal tables?

·         What namespace used in ado.net?

·         What is a pre-requisite for connection pooling?

·         Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?

·         What is Data Binding?

·         What is the role of data provider?

·         What is DataViewManager?

·         Components of data providers in ADO.NET?

·         Define connected and disconnected data access in ADO.NET?

·         Describe Command Type property of a SQLCommand in ADO.NET?

·         How to convert a DataSet to a DataReader?

·         What is a DataSet?

·         What are the differences between ADO and ADO.NET?

·         What are the advantage of ADO.Net?

·         Difference between Data Grid and Repeater

·         Difference between SqlCommand and SqlCommandBuilder

·         What is difference between dataset and data reader?

·         What is a database command?

·         What are the different DataAdapter Object properties present?

·         Give Expansions of ODBC,OLE,OLE DB,ADO?

·         How to create a column in the DataTable?

·         HOW MANY TYPES OF DATA TABLE ARE IN SQL.NET

·         What is a Linked Server?

·         Explain about Active X data object?

·         What is DataTable?

·         What is DataAdapter?