d) Parameters:

This property contains the list of parameters (argument values), that are to be sent to backend, while you are calling a stored procedure / function. It is of ―collection‖ type, so that you can add any no. of parameters.

e) ExecuteNonQuery():

This method is used to execute any SQL statement (insertion statement / deletion statement / updation statement / select statement) or a stored procedure / function also. In other words, this method moves the execution flow to backend database, execute the command there and then come back with some result. This method returns no. of rows affected‖, which represents the count of the rows, which are affected by executing this command. Suppose, after executing a delete statement, 2 rows are deleted. So it returns the integer value "2"

f) ExecuteReader():

This method is used to execute ―select‖ statement only. In other words, it is used to retrieve some data from the database, based on the given select statement. In other words, this method moves the execution flow to backend database, execute the command there and then come back with some

result data. This method returns the table data, based on the given select statement.