C# Класс CustomerService.DBUtility.SqlHelper

The SqlHelper class is intended to encapsulate high performance, scalable best practices for common uses of SqlClient.

Открытые свойства

Свойство	Тип	Описание
ConnectionStringInventoryDistributedTransaction	string
ConnectionStringLocalTransaction	string
ConnectionStringOrderDistributedTransaction	string
ConnectionStringProfile	string

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

Метод	Описание
CacheParameters ( string cacheKey ) : void	add parameter array to the cache
ExecuteNonQuery ( SqlConnection connection, CommandType cmdType, string cmdText ) : int	Execute a SqlCommand (that returns no resultset) against an existing database connection using the provided parameters. e.g.: int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));
ExecuteNonQuery ( SqlTransaction trans, CommandType cmdType, string cmdText ) : int	Execute a SqlCommand (that returns no resultset) using an existing SQL Transaction using the provided parameters. e.g.: int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));
ExecuteNonQuery ( string connectionString, CommandType cmdType, string cmdText ) : int	Execute a SqlCommand (that returns no resultset) against the database specified in the connection string using the provided parameters. e.g.: int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));
ExecuteReader ( string connectionString, CommandType cmdType, string cmdText ) : System.Data.SqlClient.SqlDataReader	Execute a SqlCommand that returns a resultset against the database specified in the connection string using the provided parameters. e.g.: SqlDataReader r = ExecuteReader(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));
ExecuteScalar ( SqlConnection connection, CommandType cmdType, string cmdText ) : object	Execute a SqlCommand that returns the first column of the first record against an existing database connection using the provided parameters. e.g.: Object obj = ExecuteScalar(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));
ExecuteScalar ( string connectionString, CommandType cmdType, string cmdText ) : object	Execute a SqlCommand that returns the first column of the first record against the database specified in the connection string using the provided parameters. e.g.: Object obj = ExecuteScalar(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));
GetCachedParameters ( string cacheKey ) : System.Data.SqlClient.SqlParameter[]	Retrieve cached parameters

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

Метод	Описание
PrepareCommand ( SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter cmdParms ) : void	Prepare a command for execution

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

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

add parameter array to the cache

public static CacheParameters ( string cacheKey ) : void
cacheKey	string	Key to the parameter cache
Результат	void

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

Execute a SqlCommand (that returns no resultset) against an existing database connection using the provided parameters.

e.g.: int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));

public static ExecuteNonQuery ( SqlConnection connection, CommandType cmdType, string cmdText ) : int
connection	System.Data.SqlClient.SqlConnection
cmdType	CommandType
cmdText	string
Результат	int

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

Execute a SqlCommand (that returns no resultset) using an existing SQL Transaction using the provided parameters.

e.g.: int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));

public static ExecuteNonQuery ( SqlTransaction trans, CommandType cmdType, string cmdText ) : int
trans	System.Data.SqlClient.SqlTransaction	an existing sql transaction
cmdType	CommandType
cmdText	string
Результат	int

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

Execute a SqlCommand (that returns no resultset) against the database specified in the connection string using the provided parameters.

e.g.: int result = ExecuteNonQuery(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));

public static ExecuteNonQuery ( string connectionString, CommandType cmdType, string cmdText ) : int
connectionString	string	a valid connection string for a SqlConnection
cmdType	CommandType
cmdText	string
Результат	int

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

Execute a SqlCommand that returns a resultset against the database specified in the connection string using the provided parameters.

e.g.: SqlDataReader r = ExecuteReader(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));

public static ExecuteReader ( string connectionString, CommandType cmdType, string cmdText ) : System.Data.SqlClient.SqlDataReader
connectionString	string	a valid connection string for a SqlConnection
cmdType	CommandType
cmdText	string
Результат	System.Data.SqlClient.SqlDataReader

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

Execute a SqlCommand that returns the first column of the first record against an existing database connection using the provided parameters.

e.g.: Object obj = ExecuteScalar(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));

public static ExecuteScalar ( SqlConnection connection, CommandType cmdType, string cmdText ) : object
connection	System.Data.SqlClient.SqlConnection
cmdType	CommandType
cmdText	string
Результат	object

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

Execute a SqlCommand that returns the first column of the first record against the database specified in the connection string using the provided parameters.

e.g.: Object obj = ExecuteScalar(connString, CommandType.StoredProcedure, "PublishOrders", new SqlParameter("@prodid", 24));

public static ExecuteScalar ( string connectionString, CommandType cmdType, string cmdText ) : object
connectionString	string	a valid connection string for a SqlConnection
cmdType	CommandType
cmdText	string
Результат	object

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

Retrieve cached parameters

public static GetCachedParameters ( string cacheKey ) : System.Data.SqlClient.SqlParameter[]
cacheKey	string	key used to lookup parameters
Результат	System.Data.SqlClient.SqlParameter[]

Описание свойств

ConnectionStringInventoryDistributedTransaction публичное статическое свойство

public static string ConnectionStringInventoryDistributedTransaction
Результат	string

ConnectionStringLocalTransaction публичное статическое свойство

public static string ConnectionStringLocalTransaction
Результат	string

ConnectionStringOrderDistributedTransaction публичное статическое свойство

public static string ConnectionStringOrderDistributedTransaction
Результат	string

ConnectionStringProfile публичное статическое свойство

public static string ConnectionStringProfile
Результат	string