ADO.NET Interview questions

Total available count: 25
Subject - Microsoft Technologies
Subsubject - ADO.NET

What is Diffgram in ADO.NET? When do we use Diffgram?

A DiffGram is an XML format. It is used to identify current and original versions of data elements. A DataSet may use a DiffGram format to load and persist the contents, and further to serialize its contents for porting across a network connection.
Whenever a DataSet is written as a DiffGram, the DataSet populates the DiffGram with all the important information to accurately recreate the contents. Note that schema of the DataSet is not recreated. This includes column values from both the Current and the Original row versions, row error information and row order.

Next 5 interview question(s)

What is the importance of ExecuteNonQuery, ExecuteReader and ExecuteScalar methods in SqlCommand?
What is the purpose of database transactions?
Explain differences between Dataset and Datareader?
What is the use of SqlParameter.Direction?
What is the full-form of ADO?