public static XmlReader ExecuteXmlReader(SqlTransaction transaction, string spName, params object[] parameterValues)
{
if (parameterValues != null && parameterValues.Length > 0)
{
SqlParameter[] spParameterSet = SqlHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName);
SqlHelper.AssignParameterValues(spParameterSet, parameterValues);
return(SqlHelper.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName, spParameterSet));
}
return(SqlHelper.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName));
}
public static object ExecuteScalar(string connectionString, string spName, params object[] parameterValues)
{
if (parameterValues != null && parameterValues.Length > 0)
{
SqlParameter[] spParameterSet = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName);
SqlHelper.AssignParameterValues(spParameterSet, parameterValues);
return(SqlHelper.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName, spParameterSet));
}
return(SqlHelper.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName));
}
public static int ExecuteNonQuery(string connectionString, string spName, Hashtable parameterValues)
{
if (parameterValues != null && parameterValues.Count > 0)
{
SqlParameter[] spParameterSet = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName);
SqlHelper.AssignParameterValues(spParameterSet, parameterValues);
return(SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, spParameterSet));
}
return(SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName));
}
public static void BeginExecuteNonQuery(string connectionString, string spName, params object[] parameterValues)
{
if (parameterValues != null && parameterValues.Length > 0)
{
SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName);
SqlHelper.AssignParameterValues(commandParameters, parameterValues);
SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, commandParameters);
}
else
{
SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName);
}
}
public static XmlReader ExecuteXmlReader(SqlConnection connection, string spName, params object[] parameterValues)
{
XmlReader result;
if (parameterValues != null && parameterValues.Length > 0)
{
SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connection.ConnectionString, spName);
SqlHelper.AssignParameterValues(commandParameters, parameterValues);
result = SqlHelper.ExecuteXmlReader(connection, CommandType.StoredProcedure, spName, commandParameters);
}
else
{
result = SqlHelper.ExecuteXmlReader(connection, CommandType.StoredProcedure, spName);
}
return(result);
}
public static DataSet ExecuteDataset(SqlTransaction transaction, string spName, params object[] parameterValues)
{
DataSet result;
if (parameterValues != null && parameterValues.Length > 0)
{
SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName);
SqlHelper.AssignParameterValues(commandParameters, parameterValues);
result = SqlHelper.ExecuteDataset(transaction, CommandType.StoredProcedure, spName, commandParameters);
}
else
{
result = SqlHelper.ExecuteDataset(transaction, CommandType.StoredProcedure, spName);
}
return(result);
}
public static int ExecuteNonQuery(string connectionString, string spName, Hashtable parameterValues)
{
int result;
if (parameterValues != null && parameterValues.Count > 0)
{
SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName);
SqlHelper.AssignParameterValues(commandParameters, parameterValues);
result = SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, commandParameters);
}
else
{
result = SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName);
}
return(result);
}
