SqlHelperParameterCache..::..GetSpParameterSet Method (String, String, Boolean)

Retrieves the set of SqlParameters appropriate for the stored procedure

Namespace:  Core
Assembly:  Core (in Core.dll)

Syntax


public static SqlParameter[] GetSpParameterSet(
	string connectionString,
	string spName,
	bool includeReturnValueParameter
)

Parameters

connectionString
Type: String
A valid connection string for a SqlConnection
spName
Type: String
The name of the stored procedure
includeReturnValueParameter
Type: Boolean
A bool value indicating whether the return value parameter should be included in the results

Return Value

An array of SqlParameters

Exceptions


ExceptionCondition
ArgumentNullException connectionString or spName

Remarks


This method will query the database for this information, and then store it in a cache for future requests.