Brief about an overview of ADO.NET architecture.
List out difference between Dataset and ADO Recordset.
List out difference between classic ADO and ADO.NET.
Explain connection object in ADO.NET.
Explain the methods of command objects.
What is dataadapter? What are its methods?
What is Dataset object? What are the various objects in Dataset ?
How can we connect to Microsoft Access , Foxpro , Oracle etc ?
Explain how to check for changes made to dataset.
Provide namespace to connect to SQL Server.
Explain the steps to use stored proceduce in ADO.NET.
How can we force the connection object to close?
Is is possible to force datareader to return only schema.
How can we optimize command object when there is only one row?
What is basic use of “DataView” ?
Describe how to fill a dataset.
What are the methods provided by the dataset for XML?
Explain how to save all data from dataset.
How can we add/remove row’s in “DataTable” object of “DataSet” ?
What is difference between “DataSet” and “DataReader” ?
How can we load multiple tables in a DataSet ?
Explain how to add relation’s between table in a DataSet ?
What is the use of CommandBuilder?
List out difference between “Optimistic” and “Pessimistic” locking.
Describe the way to implement locking in ADO.NET.
Describe how to use transactions in .NET.
List out difference between dataset and datareader.
What’s difference between Dataset. clone and Dataset. copy ?
Which is the best place to store connectionstring?