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)

1
What are the two fundamental objects in ADO.NET?
2
Explain about SqlCommand.CommandTimeout property?
3
Explain about asynchronous execution of commands?
4
Can you inherit from SqlConnection class?
5
Why will an ASP.NET user account be created in the database for an ASP.NET web application?