public object ExecuteScalar(string query) { object result = null; OracleCommand cmd = null; try { if (ConnectionOpen()) { cmd = _Connection.CreateCommand(); cmd.CommandText = query; result = cmd.ExecuteScalar(); if (result == null) { result = ""; } } } catch (Exception ex) { LogIslemleri.LogYaz(ex.Message); result = ""; } finally { if (cmd != null) { cmd.Dispose(); } CloseConnection(); } return(result); }
public int StartDBListening(string query, OnChangeEventHandler func) { int result = -1; OracleCommand cmd = null; try { if (ConnectionOpen()) { cmd = new OracleCommand(query, _Connection); cmd.AddRowid = true; //OracleDependency dep = new OracleDependency(cmd); dep.AddCommandDependency(cmd); cmd.Notification.IsNotifiedOnce = false; bool buldu = false; foreach (var item in dep.RegisteredResources) { if (item.ToString() == query) { buldu = true; } } if (buldu == false) { dep.OnChange += new OnChangeEventHandler(func); } cmd.ExecuteNonQuery(); } } catch (OracleException oex) { } catch (Exception ex) { LogIslemleri.LogYaz(ex.Message); result = -1; } finally { if (cmd != null) { cmd.Dispose(); } CloseConnection(); } return(result); }