/// <summary>Executes and returns the number of rows affected.<para>When done dispose connection.</para></summary>
/// <param name="connection">Database connection.</param>
/// <param name="query">SQL code.</param>
/// <param name="parameter">PropertyName parameterized to PropertyName. if null then no use parameter.</param>
/// <param name="commandType">Command Type.</param>
/// <returns>Rows affected.</returns>
public static int ExecuteNonQuery(IDbConnection connection, string query,
object parameter = null, CommandType commandType = CommandType.Text)
{
using (var exec = new DbExecutor(connection))
{
return(exec.ExecuteNonQuery(query, parameter, commandType));
}
}
/// <summary>Executes and returns the number of rows affected.<para>When done dispose connection.</para></summary>
/// <param name="connection">Database connection.</param>
/// <param name="query">SQL code.</param>
/// <param name="parameter">PropertyName parameterized to PropertyName. if null then no use parameter.</param>
/// <param name="commandType">Command Type.</param>
/// <returns>Rows affected.</returns>
public static int ExecuteNonQuery(IDbConnection connection, string query,
object parameter = null, CommandType commandType = CommandType.Text)
{
Contract.Requires <ArgumentNullException>(connection != null);
Contract.Requires <ArgumentException>(!String.IsNullOrEmpty(query));
using (var exec = new DbExecutor(connection))
{
return(exec.ExecuteNonQuery(query, parameter, commandType));
}
}
