Method | Description | |
---|---|---|
CacheParameterSet ( string connectionString, string commandText ) : void |
Add parameter array to the cache
|
|
GetCachedParameterSet ( string connectionString, string commandText ) : System.Data.SqlClient.SqlParameter[] |
Retrieve a parameter array from the cache
|
|
GetSpParameterSet ( string connectionString, string spName ) : System.Data.SqlClient.SqlParameter[] |
Retrieves the set of SqlParameters appropriate for the stored procedure This method will query the database for this information, and then store it in a cache for future requests. |
|
GetSpParameterSet ( string connectionString, string spName, bool includeReturnValueParameter ) : System.Data.SqlClient.SqlParameter[] |
Retrieves the set of SqlParameters appropriate for the stored procedure This method will query the database for this information, and then store it in a cache for future requests. |
Method | Description | |
---|---|---|
CloneParameters ( |
Deep copy of cached SqlParameter array
|
|
DiscoverSpParameterSet ( |
Resolve at run time the appropriate set of SqlParameters for a stored procedure
|
|
GetSpParameterSet ( |
Retrieves the set of SqlParameters appropriate for the stored procedure This method will query the database for this information, and then store it in a cache for future requests. |
|
GetSpParameterSet ( |
Retrieves the set of SqlParameters appropriate for the stored procedure This method will query the database for this information, and then store it in a cache for future requests. |
|
GetSpParameterSetInternal ( |
Retrieves the set of SqlParameters appropriate for the stored procedure
|
|
SqlHelperParameterCache ( ) : System |
public static CacheParameterSet ( string connectionString, string commandText ) : void | ||
connectionString | string | A valid connection string for a SqlConnection |
commandText | string | The stored procedure name or T-SQL command |
return | void |
public static GetCachedParameterSet ( string connectionString, string commandText ) : System.Data.SqlClient.SqlParameter[] | ||
connectionString | string | A valid connection string for a SqlConnection |
commandText | string | The stored procedure name or T-SQL command |
return | System.Data.SqlClient.SqlParameter[] |
public static GetSpParameterSet ( string connectionString, string spName ) : System.Data.SqlClient.SqlParameter[] | ||
connectionString | string | A valid connection string for a SqlConnection |
spName | string | The name of the stored procedure |
return | System.Data.SqlClient.SqlParameter[] |
public static GetSpParameterSet ( string connectionString, string spName, bool includeReturnValueParameter ) : System.Data.SqlClient.SqlParameter[] | ||
connectionString | string | A valid connection string for a SqlConnection |
spName | string | The name of the stored procedure |
includeReturnValueParameter | bool | A bool value indicating whether the return value parameter should be included in the results |
return | System.Data.SqlClient.SqlParameter[] |