protected override void Dispose(bool disposing) { if (disposed) return; _postponingDispose = false; if (disposing) { NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, "Dispose"); Close(); if (_postponingClose) { _postponingDispose = true; return; } } base.Dispose(disposing); disposed = true; }
public static bool Connection_Test(ENTITE.Serveur bean) { if (bean.Control_()) { NpgsqlConnection con = new NpgsqlConnection(); try { string constr = "PORT=" + bean.getPort + ";TIMEOUT=15;POOLING=True;MINPOOLSIZE=1;MAXPOOLSIZE=20;COMMANDTIMEOUT=20;COMPATIBLE= 2.0.14.3;DATABASE=" + bean.getDatabase + ";HOST=" + bean.getAdresse + ";PASSWORD="******";USER ID=" + bean.getUser + ""; con = new NpgsqlConnection(constr); con.Open(); return true; } catch (NpgsqlException ex) { Messages.Exception(ex); return false; } finally { con.Close(); con.Dispose(); } } return false; }