C# 클래스 yycms.service.SqlHelperParameterCache

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

파일 보기 프로젝트 열기: seven1276/yycms

공개 메소드들

메소드	설명
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.

비공개 메소드들

메소드	설명
CloneParameters ( SqlParameter originalParameters ) : System.Data.SqlClient.SqlParameter[]	Deep copy of cached SqlParameter array
DiscoverSpParameterSet ( SqlConnection connection, string spName, bool includeReturnValueParameter ) : System.Data.SqlClient.SqlParameter[]	Resolve at run time the appropriate set of SqlParameters for a stored procedure
GetSpParameterSet ( SqlConnection connection, 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 ( SqlConnection connection, 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.
GetSpParameterSetInternal ( SqlConnection connection, string spName, bool includeReturnValueParameter ) : System.Data.SqlClient.SqlParameter[]	Retrieves the set of SqlParameters appropriate for the 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() 공개 정적인 메소드

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[]