ADO.NET Interview questions


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

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

In order to access the database, a user needs to follow certain steps, commands and database connection. These things are explained clearly in step by step,

1. Declare a AppSettings key for creating a connection in Web.config
2. Declare the namespace System.Data.SqlClient to access SQL related commands
3. Create a connection to the database by using SqlConnection
4. Open the connection
5. Use a DataSet object in code to display data or to change items in the database
6. Invoke a command to create a DataSet object using an adapter object.
7. Close the connection



Next 5 interview question(s)

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

Comments