/// <summary>
/// Выполняет запрос без результатов
/// </summary>
/// <param name="connection"></param>
/// <param name="command"></param>
/// <param name="parameters"></param>
/// <param name="timeout"></param>
/// <param name="close"></param>
/// <param name="showCommandTextWithParams">показать в Debug</param>
/// <exception cref="Exception"></exception>
public static int ExecuteNonQuery(this IDbConnection connection, object command,
object parameters = null, int timeout = 30, bool close = false, bool showCommandTextWithParams = false)
{
connection.WellOpen();
IDbCommand cmd = connection.CreateCommand(command, parameters, timeout);
cmd.CommandTimeout = timeout;
int r;
try{
if (showCommandTextWithParams)
{
Log.Debug("Sql command: [\r\n" + cmd.CommandAsSql() + "\r\n]");
}
r = cmd.ExecuteNonQuery();
}
catch (Exception ex) {
throw new Exception("error in query:" + cmd.CommandText, ex);
}
finally{
if (close)
{
connection.Close();
}
}
return(r);
}
