What are some of the commonly used commands in SQLCommand in ADO.net?

Some of the commonly used commands in SQL command in ADO.net framework include:

• Cancel: used when the user wants to cancel a request
• ExecuteScalar: used to execute and return a set of single values
• ResetCommandTimeout: used in order to reset any timeout property
• ExecuteReader: used for execution and returning data back into the DataReader
• ExecuteNotQuery: this command is used by the user in order to execute and does not require any result set in return
• ExecuteXMLReader: used when the user requires the execution and requires the resultant data in the XMLDataReader object