/// <summary>
/// Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the database specified
/// </summary>
/// <param name="connSettings">A DataConnectionSettings object defining the connection parameters</param>
/// <param name="commandType">The CommandType (stored procedure, text, etc.)</param>
/// <param name="commandText">The stored procedure name or T-SQL command</param>
/// <returns>An object containing the value in the 1x1 resultset generated by the command</returns>
public static object ExecuteScalar(Config.Connection connSettings, CommandType commandType, string commandText)
{
return(ExecuteScalar(connSettings.ConnectionString, commandType, commandText));
}
/// <summary>
/// Execute a SqlCommand (that returns a 1x1 resultset) against the database specified
/// </summary>
/// <param name="connSettings">A DataConnectionSettings object defining the connection parameters</param>
/// <param name="commandType">The CommandType (stored procedure, text, etc.)</param>
/// <param name="commandText">The stored procedure name or T-SQL command</param>
/// <param name="commandParameters">A list of SqlParamters used to execute the command</param>
/// <returns>An object containing the value in the 1x1 resultset generated by the command</returns>
public static object ExecuteScalar(Config.Connection connSettings, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
return(ExecuteScalar(connSettings.ConnectionString, commandType, commandText, commandParameters));
}
/// <summary>
/// Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified
/// </summary>
/// <param name="connSettings"></param>
/// <param name="commandType">The CommandType (stored procedure, text, etc.)</param>
/// <param name="commandText">The stored procedure name or T-SQL command</param>
/// <returns>A dataset containing the resultset generated by the command</returns>
public static DataSet ExecuteDataset(Config.Connection connSettings, CommandType commandType, string commandText)
{
return(ExecuteDataset(connSettings.ConnectionString, commandType, commandText));
}
/// <summary>
/// Execute a SqlCommand (that returns a resultset) against the database specified in
/// the DataConnectionSettings object.
/// </summary>
/// <param name="connSettings"></param>
/// <param name="commandType">The CommandType (stored procedure, text, etc.)</param>
/// <param name="commandText">The stored procedure name or T-SQL command</param>
/// <param name="commandParameters">A list of SqlParamters used to execute the command</param>
/// <returns>A dataset containing the resultset generated by the command</returns>
public static DataSet ExecuteDataset(Config.Connection connSettings, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
return(ExecuteDataset(connSettings.ConnectionString, commandType, commandText, commandParameters));
}
/// <summary>
/// Create and prepare a SqlCommand, and call ExecuteReader with the appropriate CommandBehavior.
/// </summary>
/// <param name="connSettings">A DataConnectionSettings object defining the connection parameters</param>
/// <param name="commandType">The CommandType (stored procedure, text, etc.)</param>
/// <param name="commandText">The stored procedure name or T-SQL command</param>
/// <param name="commandParameters">An array of SqlParameters to be associated with the command or 'null' if no parameters are required</param>
/// <returns>SqlDataReader containing the results of the command</returns>
public static SqlDataReader ExecuteReader(Config.Connection connSettings, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
return(ExecuteReader(connSettings.ConnectionString, commandType, commandText, commandParameters));
}
/// <summary>
/// Create and prepare a SqlCommand, and call ExecuteReader with the appropriate CommandBehavior.
/// </summary>
/// <param name="connSettings">A DataConnectionSettings object defining the connection parameters</param>
/// <param name="commandType">The CommandType (stored procedure, text, etc.)</param>
/// <param name="commandText">The stored procedure name or T-SQL command</param>
/// <returns>SqlDataReader containing the results of the command</returns>
public static SqlDataReader ExecuteReader(Config.Connection connSettings, CommandType commandType, string commandText)
{
return(ExecuteReader(connSettings.ConnectionString, commandType, commandText));
}
/// <summary>
/// Execute a SqlCommand (that returns no resultset) against the specified database
/// </summary>
/// <param name="connSettings">A DataConnectionSetting object defining the db connection to use</param>
/// <param name="commandType">The CommandType (stored procedure, text, etc.)</param>
/// <param name="commandText">The stored procedure name or T-SQL command</param>
/// <param name="commandParameters">An array of SqlParamters used to execute the command</param>
/// <returns>An int representing the number of rows affected by the command</returns>
public static int ExecuteNonQuery(Config.Connection connSettings, CommandType commandType, string commandText, params SqlParameter[] commandParameters)
{
return(ExecuteNonQuery(connSettings.ConnectionString, commandType, commandText, commandParameters));
}
/// <summary>
/// Execute a SqlCommand (that returns no resultset and takes no parameters) against the specified database
/// </summary>
/// <param name="connSettings"></param>
/// <param name="commandType">The CommandType (stored procedure, text, etc.)</param>
/// <param name="commandText">The stored procedure name or T-SQL command</param>
/// <returns>An int representing the number of rows affected by the command</returns>
public static int ExecuteNonQuery(Config.Connection connSettings, CommandType commandType, string commandText)
{
return(ExecuteNonQuery(connSettings.ConnectionString, commandType, commandText));
}
/// <summary>
/// Begins a Transaction on a new connection to the specified database.
/// </summary>
/// <param name="connSettings">The database settings object to use</param>
/// <returns>A new open SqlTransaction</returns>
public static SqlTransaction GetNewTransaction(Config.Connection connSettings)
{
return(GetNewTransaction(connSettings.ConnectionString));
}