/// <summary> /// Creates a SqlCommand object with the relevant properties set /// </summary> /// <param name="conn">SqlConnection used to execute this command</param> /// <param name="commandText">Name of the stored procedure being executed</param> /// <param name="parameter">Parameter needed to be passed to the stored procedure</param> /// <returns>SqlCommand object with the relevant properties set</returns> internal static SqlCommand GetCommand(SqlConnection conn, String commandText, StoredProcedureParameter parameter) { return(GetCommand(conn, commandText, new StoredProcedureParameter[1] { parameter })); }
/// <summary> /// Executes a stored procedure /// </summary> /// <param name="commandText">Name of the stored procedure being executed</param> /// <param name="parameter">Parameter needed to be passed to the stored procedure</param> internal static void ExecuteNonQuery(String commandText, StoredProcedureParameter parameter) { ExecuteNonQuery(commandText, new StoredProcedureParameter[1] { parameter }); }
/// <summary> /// Executes a stored procedure and returns the single value it generates /// </summary> /// <param name="commandText">Name of the stored procedure being executed</param> /// <param name="parameter">Parameter needed to be passed to the stored procedure</param> /// <returns>Single value generated by the stored procedure</returns> internal static object ExecuteScalar(String commandText, StoredProcedureParameter parameter) { return(ExecuteScalar(commandText, new StoredProcedureParameter[1] { parameter })); }
/// <summary> /// Executes a stored procedure and returns the data it loads /// </summary> /// <param name="commandText">Name of the stored procedure being executed</param> /// <param name="parameter">Parameter needed to be passed to the stored procedure</param> /// <returns>DataTableReader object containing all the rows selected by the stored procedure</returns> internal static DataTableReader ExecuteReader(String commandText, StoredProcedureParameter parameter) { return(ExecuteReader(commandText, new StoredProcedureParameter[1] { parameter })); }