/// <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); }
public bool IsMatch(IPEndPoint remote, IPEndPoint local, string origin) { var result = InternalMatch(remote, local, origin); if (logg.IsForDebug()) { var loggm = new { lan = LocalAddressName, ran = RemoteAddressName, lp = LocalPort, o = Origin, n = Name, rm = remote.ToString(), lc = local.ToString(), or = origin, rs = result }; logg.Debug(loggm.stringify()); } return(result); }