Retrieves stored procedure parameters.

Parameters

spName

The stored procedure to which the Parameter array relates.

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.

See Also

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

---