/// <summary>
/// Executes a stored procedure and returns the scalar result
/// </summary>
/// <param name="storedProcedureName">Name of the of the stored procedure being executed</param>
/// <param name="parameter">Single parameter to pass to the stored procedure</param>
/// <param name="conn">Open connection to the database</param>
/// <returns>The scalar result of executing the stored procedure</returns>
public static object ExecuteScalar(String storedProcedureName, sp.Parameter parameter, SqlConnection conn)
{
return(ExecuteScalar(storedProcedureName, new sp.Parameter[1] {
parameter
}, conn));
}
/// <summary>
/// Executes a stored procedure and returns the scalar result
/// </summary>
/// <param name="storedProcedureName">Name of the of the stored procedure being executed</param>
/// <param name="parameter">Single parameter to pass to the stored procedure</param>
/// <returns>The scalar result of executing the stored procedure</returns>
public static object ExecuteScalar(String storedProcedureName, sp.Parameter parameter)
{
return(ExecuteScalar(storedProcedureName, new sp.Parameter[1] {
parameter
}));
}
/// <summary>
/// Executes a stored procedure and returns the selected data
/// </summary>
/// <param name="storedProcedureName">Name of the of the stored procedure being executed</param>
/// <param name="parameter">Single parameter to pass to the stored procedure</param>
/// <param name="conn">Open connection to the database</param>
/// <returns>The data selected by the stored procedure</returns>
public static sp.DataTable ExecuteReader(String storedProcedureName, sp.Parameter parameter, SqlConnection conn)
{
return(ExecuteReader(storedProcedureName, new sp.Parameter[1] {
parameter
}, conn));
}
/// <summary>
/// Executes a stored procedure and returns the selected data
/// </summary>
/// <param name="storedProcedureName">Name of the of the stored procedure being executed</param>
/// <param name="parameter">Single parameter to pass to the stored procedure</param>
/// <returns>The data selected by the stored procedure</returns>
public static sp.DataTable ExecuteReader(String storedProcedureName, sp.Parameter parameter)
{
return(ExecuteReader(storedProcedureName, new sp.Parameter[1] {
parameter
}));
}
/// <summary>
/// Executes a stored procedure
/// </summary>
/// <param name="storedProcedureName">Name of the of the stored procedure being executed</param>
/// <param name="parameter">Single parameter to pass to the stored procedure</param>
/// <param name="conn">Open connection to the database</param>
public static void ExecuteNonQuery(String storedProcedureName, sp.Parameter parameter, SqlConnection conn)
{
ExecuteNonQuery(storedProcedureName, new sp.Parameter[1] {
parameter
}, conn);
}
/// <summary>
/// Executes a stored procedure
/// </summary>
/// <param name="storedProcedureName">Name of the of the stored procedure being executed</param>
/// <param name="parameter">Single parameter to pass to the stored procedure</param>
public static void ExecuteNonQuery(String storedProcedureName, sp.Parameter parameter)
{
ExecuteNonQuery(storedProcedureName, new sp.Parameter[1] {
parameter
});
}