public object ExecuteScalar(ICommand command)
{
if (command == null)
{
throw new ArgumentNullException("command");
}
if (command.Transaction == null)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
command.Transaction = transaction;
return(command.DbCommand.ExecuteScalar());
}
}
return(command.DbCommand.ExecuteScalar());
}
public DataSet GetDataSet(ICommand command, DataSet dataSet, string[] tables)
{
if (command == null)
{
throw new ArgumentNullException("command");
}
if (command.Transaction == null)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
command.Transaction = transaction;
return(GetDataSetInternal(command, dataSet, tables));
}
}
return(GetDataSetInternal(command, dataSet, tables));
}
public object ExecuteScalar(string spName)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(this.ExecuteScalar(spName, transaction));
}
}
public object ExecuteScalar(string spName, params IDataParameter[] parameters)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(this.ExecuteScalar(spName, transaction, parameters));
}
}
public object ExecuteScalar(string command, CommandType commandType, params IDataParameter[] parameters)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(ExecuteScalar(command, commandType, transaction, parameters));
}
}
public object ExecuteScalar(string command, CommandType commandType)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(ExecuteScalar(command, commandType, transaction));
}
}
public int ExecuteNonQuery(string spName)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(this.ExecuteNonQuery(spName, transaction));
}
}
public int ExecuteNonQuery(string spName, params IDataParameter[] parameters)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(this.ExecuteNonQuery(spName, transaction, parameters));
}
}
public int ExecuteNonQuery(string command, CommandType commandType)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(ExecuteNonQuery(command, commandType, transaction));
}
}
public DataSet ExecuteDataSet(string spName)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(this.ExecuteDataSet(spName, transaction));
}
}
public DataSet ExecuteDataSet(string command, CommandType commandType)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(ExecuteDataSet(command, commandType, transaction));
}
}
public int UpdateDataSet(DataSet dataSet, ICommand insertCommand, ICommand updateCommand, ICommand deleteCommand, string tableName)
{
using (ITransaction transaction = TransactionFactory.GetTransaction(this, false)) {
return(UpdateDataSet(dataSet, insertCommand, updateCommand, deleteCommand, tableName, transaction));
}
}