uses of Command object in ADO.NET

Question

List the usages of the Command object in ADO.NET?

Answer 1

The usages of the Command object in AD0.NET are:

a) Command object in the AD0.NET executes a command against the database and retrieves a DataReader or DataSet object.
b) It also executes commands such as, UPDATE, INSERT or DELETE command against the database.
c) All the command objects are derived from the DbCommand class.
d) The command object is characterized by the two classes: and OleDbComm and SqlCommand.

The Command object offers three methods in order to execute commands in the database:

a) The ExecuteNonQuery() method, which executes commands and also does not return any value.
b) The ExecuteReader() method, which returns a result set by using the DataReader object.
c) The ExecuteScalar() method, which returns single value from the database query.