Advantage of ADO.Net?

QualSoft, TCS,

How would u connect to database using .NET?

TCS, Tesco,

What are relation objects in dataset and how & where to use them?

Difference between OLEDB Provider and SqlClient ?

What are the different namespaces used in the project to connect the database?

Difference between DataReader and DataAdapter / DataSet and DataAdapter?

TCS,

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

Explain different methods and Properties of DataReader which you have used in your project?

What happens when we issue Dataset.ReadXml command?

How to find the count of records in a dataset?

How to check if a datareader is closed or opened?

What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?

TCS,

What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?

Differences between dataset.clone and dataset.copy?

Ksb, TCS,

What is the use of parameter object?

CDC, Ksb,