Microsoft Technologies, ADO.Net Interview Questions - SlightBook

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

1

Explain about ADO.NET support namespaces?

2

What are the differences between ADO and ADO.NET?

3

How to convert a DataSet into a DataReader?

4

Explain about ADO.NET namespaces which are required to connect database?

5

How to fill a DataSet?

6

How to connect a database through SqlConnection?

7

Explain the methods of DataAdapter.Update() and DataSetAcceptChanges()?

8

What is the meaning of object pooling?

9

What is the difference between DataSet.Copy() and DataSet.Clone()?

10

Types of DataSet in ADO.NET?

11

Explain about Row States and Row Versions?

12

Explain the steps to access the database in ADO.NET?

13

Why will an ASP.NET user account be created in the database for an ASP.NET web application?

14

Can you inherit from SqlConnection class?

15

Explain about asynchronous execution of commands?

16

Explain about SqlCommand.CommandTimeout property?

17

What are the two fundamental objects in ADO.NET?

18

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

19

What is the importance of ExecuteNonQuery, ExecuteReader and ExecuteScalar methods in SqlCommand?

20

What is the purpose of database transactions?

21

Explain differences between Dataset and Datareader?

22

What is the use of SqlParameter.Direction?

23

What is the full-form of ADO?

24

Is it possible to update the database by using SqlDataReader?

25

How can a user determine which SQL commands are part of a transaction?