C# Class CustomerService.DBUtility.SqlHelper

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

Public Properties

Property	Type	Description
ConnectionStringInventoryDistributedTransaction	string
ConnectionStringLocalTransaction	string
ConnectionStringOrderDistributedTransaction	string
ConnectionStringProfile	string

Public Methods

Method	Description
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

Private Methods

Method	Description
PrepareCommand ( SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, string cmdText, SqlParameter cmdParms ) : void	Prepare a command for execution

Method Details

CacheParameters() public static method

add parameter array to the cache

public static CacheParameters ( string cacheKey ) : void
cacheKey	string	Key to the parameter cache
return	void

ExecuteNonQuery() public static method

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
return	int

ExecuteNonQuery() public static method

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
return	int

ExecuteNonQuery() public static method

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
return	int

ExecuteReader() public static method

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
return	System.Data.SqlClient.SqlDataReader

ExecuteScalar() public static method

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
return	object

ExecuteScalar() public static method

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
return	object

GetCachedParameters() public static method

Retrieve cached parameters

public static GetCachedParameters ( string cacheKey ) : System.Data.SqlClient.SqlParameter[]
cacheKey	string	key used to lookup parameters
return	System.Data.SqlClient.SqlParameter[]

Property Details

ConnectionStringInventoryDistributedTransaction public static property

public static string ConnectionStringInventoryDistributedTransaction
return	string

ConnectionStringLocalTransaction public static property

public static string ConnectionStringLocalTransaction
return	string

ConnectionStringOrderDistributedTransaction public static property

public static string ConnectionStringOrderDistributedTransaction
return	string

ConnectionStringProfile public static property

public static string ConnectionStringProfile
return	string