What is openrowset?
Explain the difference between an ado.net dataset and an ado recordset?
What is ambient transaction?
What is Serialization in .NET? what are the types of Serialization?
What is isolation?
What is method to get XML and schema from Dataset? getXML() and get Schema ()
What is XML serialization
How to find the given query is optimised one or not?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What are the important features of ado.net 2.0?
What does sqldatareader return?
What is difference between connected and disconnected architecture in ado.net?
Explain the difference between sqlcommand object and command behavior object?
What is fill method in ado.net?
How to connect and retrieve data from database using dataset