Command object in ADO DOT NET

Question

List the usages of Command object in ADO.NET?

Answer 1

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

i. The ExecuteReader() method: It returns the result set by using a DataReader object.

ii. The ExecuteNonQuery() method: It executes a commands and does not return any value,

iii. The Command objects in the AD0.NET performs a command against a database and regain a DataReader or a DataSet object.

iv. It performs DELETE, INSERT, or UPDATE, command against a database.

v. Command object is represented by the two classes: OleDbCommand and SqlCommand.

vi. Command object gives three methods to perform commands on a database

vii. The ExecuteScalar() method returns single value from the database query.

viii. Each command objects are derived from the DbCommand class.