/// <summary>
/// Executes the specified <paramref name="query"/> with the specified <paramref name="parameters"/>
/// </summary>
/// <param name="query">
/// The SQL query to execute
/// </param>
/// <param name="transaction">
/// The transaction.
/// </param>
/// <param name="parameters">
/// The parameters. Can be null.
/// </param>
/// <returns>
/// The return value of <paramref name="query"/>
/// </returns>
public object ExecuteScalarFormat(string query, DbTransaction transaction, params DbParameter[] parameters)
{
try
{
IDatabaseInternal databaseInternal = new DatabaseTransactional(transaction);
using (var command = this.GetSqlStringCommandFormat(query, parameters))
{
databaseInternal.SetupCommand(command);
return(databaseInternal.ExecuteScalar(command));
}
}
catch (Exception e)
{
_log.Error("While ExecuteNonQuery", e);
throw;
}
}
/// <summary>
/// Executes the specified <paramref name="sqlStatement"/> with the specified <paramref name="parameters"/>
/// </summary>
/// <param name="sqlStatement">
/// The SQL statement to execute
/// </param>
/// <param name="transaction">
/// The transaction.
/// </param>
/// <param name="parameters">
/// The parameters. Can be null.
/// </param>
/// <returns>
/// The return value of <paramref name="sqlStatement"/>
/// </returns>
public int ExecuteNonQuery(string sqlStatement, DbTransaction transaction, IList <DbParameter> parameters)
{
try
{
IDatabaseInternal databaseInternal = new DatabaseTransactional(transaction);
using (var command = this.GetSqlStringCommand(sqlStatement, parameters))
{
databaseInternal.SetupCommand(command);
return(databaseInternal.ExecuteNonQuery(command));
}
}
catch (Exception e)
{
_log.Error("While ExecuteNonQuery", e);
throw;
}
}
/// <summary>
/// Executes the specified <paramref name="query"/> with the specified <paramref name="parameters"/>
/// </summary>
/// <param name="query">
/// The SQL query to execute
/// </param>
/// <param name="transaction">
/// The transaction.
/// </param>
/// <param name="parameters">
/// The parameters. Can be null.
/// </param>
/// <returns>
/// The return value of <paramref name="query"/>
/// </returns>
public object ExecuteScalarFormat(string query, DbTransaction transaction, params DbParameter[] parameters)
{
try
{
IDatabaseInternal databaseInternal = new DatabaseTransactional(transaction);
using (var command = this.GetSqlStringCommandFormat(query, parameters))
{
databaseInternal.SetupCommand(command);
return databaseInternal.ExecuteScalar(command);
}
}
catch (Exception e)
{
_log.Error("While ExecuteNonQuery", e);
throw;
}
}
/// <summary>
/// Executes the specified <paramref name="sqlStatement"/> with the specified <paramref name="parameters"/>
/// </summary>
/// <param name="sqlStatement">
/// The SQL statement to execute
/// </param>
/// <param name="transaction">
/// The transaction.
/// </param>
/// <param name="parameters">
/// The parameters. Can be null.
/// </param>
/// <returns>
/// The return value of <paramref name="sqlStatement"/>
/// </returns>
public int ExecuteNonQuery(string sqlStatement, DbTransaction transaction, IList<DbParameter> parameters)
{
try
{
IDatabaseInternal databaseInternal = new DatabaseTransactional(transaction);
using (var command = this.GetSqlStringCommand(sqlStatement, parameters))
{
databaseInternal.SetupCommand(command);
return databaseInternal.ExecuteNonQuery(command);
}
}
catch (Exception e)
{
_log.Error("While ExecuteNonQuery", e);
throw;
}
}
