/// <summary>
/// The execute scalar.
/// </summary>
/// <param name="cmd">
/// The cmd.
/// </param>
/// <param name="unitOfWork">
/// The unit of work.
/// </param>
/// <returns>
/// The execute scalar.
/// </returns>
public virtual object ExecuteScalar([NotNull] DbCommand cmd, [CanBeNull] IDbUnitOfWork unitOfWork = null)
{
CodeContracts.ArgumentNotNull(cmd, "cmd");
using (var qc = new QueryCounter(cmd.CommandText))
{
object results = null;
if (unitOfWork == null)
{
using (var connection = this.CreateConnectionOpen())
{
// get an open connection
cmd.Connection = connection;
results = cmd.ExecuteScalar();
}
}
else
{
unitOfWork.Setup(cmd);
results = cmd.ExecuteScalar();
}
return results == DBNull.Value ? null : results;
}
}
public virtual DataSet GetDataset([NotNull] DbCommand cmd, [CanBeNull] IDbUnitOfWork unitOfWork = null)
{
CodeContracts.ArgumentNotNull(cmd, "cmd");
using (var qc = new QueryCounter(cmd.CommandText))
{
return this.GetDatasetBasic(cmd, unitOfWork);
}
}
/// <summary>
/// The execute non query.
/// </summary>
/// <param name="cmd">
/// The cmd.
/// </param>
/// <param name="unitOfWork">
/// The unit of work.
/// </param>
public virtual void ExecuteNonQuery([NotNull] DbCommand cmd, [CanBeNull] IDbUnitOfWork unitOfWork = null)
{
CodeContracts.ArgumentNotNull(cmd, "cmd");
using (var qc = new QueryCounter(cmd.CommandText))
{
if (unitOfWork == null)
{
using (var connection = this.CreateConnectionOpen())
{
// get an open connection
cmd.Connection = connection;
cmd.ExecuteNonQuery();
}
}
else
{
unitOfWork.Setup(cmd);
cmd.ExecuteNonQuery();
}
}
}
