public IDbCommand GetCommand(string commandText, DbParameterCollection parameterCollection, IDbTransaction transaction)
{
return(GetCommand(commandText, parameterCollection, transaction, CommandType.Text));
}
public IDbCommand GetCommand(string commandText, IDbConnection connection, CommandType commandType, DbParameterCollection parameterCollection)
{
var command = GetCommand();
command.CommandText = commandText;
command.Connection = connection;
command.CommandType = commandType;
if (parameterCollection != null)
{
var paramArray = _paramBuilder.GetParameterCollection(parameterCollection);
foreach (var param in paramArray)
{
command.Parameters.Add(param);
}
}
return(command);
}
/// <summary>
/// Prepares command for the passed SQL Command or Stored Procedure.
/// Command is prepared for SQL Command only not for the stored procedures.
/// Use DisposeCommand method after use of the command.
/// </summary>
/// <param name="commandText">SQL Command or Stored Procedure name</param>
/// <param name="parameterCollection">Database parameter collection</param>
/// <param name="commandType">Type of Command i.e. Text or Stored Procedure</param>
/// <returns>Command ready for execute</returns>
public IDbCommand GetCommand(string commandText, DbParameterCollection parameterCollection, CommandType commandType)
{
return(GetCommand(commandText, parameterCollection, null, commandType));
}
/// <summary>
/// Executes the Sql Command and returns the DataReader.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="connection">Database Connection object (DBHelper.GetConnObject() may be used)</param>
/// <param name="paramCollection">Parameter to be associated with the Sql Command or Stored Procedure.</param>
/// <returns>DataReader</returns>
public IDataReader ExecuteDataReader(string commandText, IDbConnection connection, DbParameterCollection paramCollection)
{
return(ExecuteDataReader(commandText, connection, paramCollection, CommandType.Text));
}
/// <summary>
/// Executes the Sql Command and returns result.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="paramCollection">Parameter collection to be associated.</param>
/// <returns>A single value. (First row's first cell value, if more than one row and column is returned.)</returns>
public object ExecuteScalar(string commandText, DbParameterCollection paramCollection)
{
return(ExecuteScalar(commandText, paramCollection, null));
}
/// <summary>
/// Executes the Sql Command and returns result.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="paramCollection">Database Parameter Collection</param>
/// <param name="transaction">Database Transaction (Use DBHelper.Transaction property.)</param>
/// <returns></returns>
public object ExecuteScalar(string commandText, DbParameterCollection paramCollection, IDbTransaction transaction)
{
return(ExecuteScalar(commandText, paramCollection, transaction, CommandType.Text));
}
/// <summary>
/// Executes Sql Command and returns number of rows affected.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="paramCollection">Parameter Collection to be associated with the command</param>
/// <param name="transaction">Current Database Transaction (Use Helper.Transaction to get transaction)</param>
/// <returns>Number of rows affected.</returns>
public int ExecuteNonQuery(string commandText, DbParameterCollection paramCollection, IDbTransaction transaction)
{
return(ExecuteNonQuery(commandText, paramCollection, transaction, CommandType.Text));
}
/// <summary>
/// Executes Sql Command and returns number of rows effected.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="paramCollection">Parameter Collection to be associated with the command</param>
/// <returns>Number of rows effected.</returns>
public int ExecuteNonQuery(string commandText, DbParameterCollection paramCollection)
{
return(ExecuteNonQuery(commandText, paramCollection, null));
}
/// <summary>
/// Executes the Sql Command and return result set in the form of DataTable.
/// </summary>
/// <param name="commandText">Sql Command</param>
/// <param name="paramCollection">Parameter collection to be associated with the Command.</param>
/// <returns>Result in the form of DataTable</returns>
public DataTable ExecuteDataTable(string commandText, DbParameterCollection paramCollection)
{
return(ExecuteDataTable(commandText, string.Empty, paramCollection, CommandType.Text));
}
/// <summary>
/// Executes the Sql Command and return result set in the form of DataSet.
/// </summary>
/// <param name="commandText">Sql Command </param>
/// <param name="paramCollection">Parameter collection to be associated with the command</param>
/// <returns>Result in the form of DataSet</returns>
public DataSet ExecuteDataSet(string commandText, DbParameterCollection paramCollection)
{
return(ExecuteDataSet(commandText, paramCollection, CommandType.Text));
}
/// <summary>
/// Executes the Sql Command and returns the IDataReader. Do remember to Commit or Rollback the transaction
/// </summary>
/// <param name="commandText">Sql Command </param>
/// <param name="paramCollection">Database Parameter Collection</param>
/// <param name="transaction">Database Transaction (Use DBHelper.Transaction property for getting the transaction.)</param>
/// <returns>IDataReader</returns>
public IDataReader ExecuteDataReader(string commandText, DbParameterCollection paramCollection, IDbTransaction transaction)
{
return(ExecuteDataReader(commandText, paramCollection, transaction, CommandType.Text));
}
