ADO.NET Interview questions


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

What is the use of SqlParameter.Direction?

SqlParameter.Direction is used to specify the Sql Paramter type. Below are the various direction types available in ADO.NET,

1. Input-only
2. Output-only
3. Bidirectional
 
Default value is input-only.



Next 5 interview question(s)

1
Explain differences between Dataset and Datareader?
2
What is the purpose of database transactions?
3
What is the importance of ExecuteNonQuery, ExecuteReader and ExecuteScalar methods in SqlCommand?
4
What is Diffgram in ADO.NET? When do we use Diffgram?
5
What are the two fundamental objects in ADO.NET?