ADO.NET Interview questions

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

Types of DataSet in ADO.NET?

There are two types of DataSets available in ADO.NET. They are,

1. Typed DataSet

2. Untyped DataSet

1. Typed DataSet:
Typed DataSet is derived from the base DataSet class and it can be created directly through Visual studio by selecting an option called DataSet. It will be created as XML schema (.xsd file). Information from the schema (tables, columns, and so on) is generated and compiled into this new DataSet class as a set of first-class objects and properties.
2. Untyped DataSet:
Untyped DataSet is not defined by a schema. User has to add tables, columns and other elements to it. Properties can be set at design time or by adding them at run time.

Next 5 interview question(s)

Explain about Row States and Row Versions?
Explain the steps to access the database in ADO.NET?
Why will an ASP.NET user account be created in the database for an ASP.NET web application?
Can you inherit from SqlConnection class?
Explain about asynchronous execution of commands?