Retrieves stored procedure parameters, and optionally includes return value.

Parameters

spName

The stored procedure to which the Parameter array relates.

includeReturnValueParameter

Boolean flag to determine whether or not the stored procedure’s return value is included in the SqlParameter array.

Return Value

Parameters of the stored procedure.

Remarks

• The connectionString and spName parameters are used as a key in the internal cache. Therefore, you cannot cache two sets of parameters for the same stored procedure using the same connection string.
• The first time this method is used to retrieve the parameters for a particular stored procedure, the parameter details are retrieved from the database and cached. All subsequent requests for the parameters of that stored procedure are satisfied from the cache.
• If the stored procedure includes output parameters, they are returned with a Direction property of ParameterDirection.InputOutput.
• When a value of true is specified for the includeReturnValueParameter parameter, the stored procedure’s return parameter is included in the SqlParameter array returned by the method. It is named "@Return_Value" and placed in position 0 of the array.

See Also

GenericDataHelper Class | DotnetProject.Data Namespace | GenericDataHelper.GetSpParameterSet Overload List

---