C# Класс SqlHelperParameterCache, Orchard.Crawler

SqlHelperParameterCache provides functions to leverage a static cache of procedure parameters, and the ability to discover parameters for stored procedures at run-time.

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
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 ( SqlConnection cn, string spName ) : System.Data.SqlClient.SqlParameter[]
GetSpParameterSet ( SqlConnection cn, string spName, bool includeReturnValueParameter ) : System.Data.SqlClient.SqlParameter[]
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.

Приватные методы

Метод	Описание
CloneParameters ( SqlParameter originalParameters ) : System.Data.SqlClient.SqlParameter[]
DiscoverSpParameterSet ( SqlConnection cn, string spName, bool includeReturnValueParameter ) : System.Data.SqlClient.SqlParameter[]	resolve at run time the appropriate set of SqlParameters for a stored procedure
DiscoverSpParameterSet ( string connectionString, string spName, bool includeReturnValueParameter ) : System.Data.SqlClient.SqlParameter[]	resolve at run time the appropriate set of SqlParameters for a stored procedure
SqlHelperParameterCache ( ) : System

Описание методов

CacheParameterSet() публичный статический Метод

add parameter array to the cache

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
Результат	void

GetCachedParameterSet() публичный статический Метод

retrieve a parameter array from the cache

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
Результат	System.Data.SqlClient.SqlParameter[]

GetSpParameterSet() публичный статический Метод

public static GetSpParameterSet ( SqlConnection cn, string spName ) : System.Data.SqlClient.SqlParameter[]
cn	SqlConnection
spName	string
Результат	System.Data.SqlClient.SqlParameter[]

GetSpParameterSet() публичный статический Метод

public static GetSpParameterSet ( SqlConnection cn, string spName, bool includeReturnValueParameter ) : System.Data.SqlClient.SqlParameter[]
cn	SqlConnection
spName	string
includeReturnValueParameter	bool
Результат	System.Data.SqlClient.SqlParameter[]

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.

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
Результат	System.Data.SqlClient.SqlParameter[]

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.

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
Результат	System.Data.SqlClient.SqlParameter[]