Explain how to call the sql commands asynchronously in ado.net version 2.0?
Describe the command object and its method.
what are the differences between dataset and datareader?
What is ole used for?
What is a sqldataadapter?
Explain acid properties?
What is isolation?
What is a data control clerk?
Differentiate between Dataset and Recordset.
Which object needs to be closed?
what is different between SqlCommand object and Command Behaviour Object
What are the steps you will take to improve performance? Will you use dataset or datareader?
what is a dataview?why is it used for?