public void StopService()
{
if (isRunning)
{
OracleDependency oraDep = OracleDependency.GetOracleDependency(oracleDependencyId);
if (oracleDependencyId == null)
{
throw new Exception("Unknown oracle dep");
}
using (OracleConnection conn = new OracleConnection(_connString))
{
conn.Open();
try
{
oraDep.RemoveRegistration(conn);
}
catch
{
throw;
}
finally
{
conn.Close();
}
}
isRunning = false;
}
}
public int StopDBListening()
{
try
{
if (ConnectionOpen())
{
if (dep.IsEnabled)
{
dep.RemoveRegistration(_Connection);
}
}
}
catch (Exception ex)
{
return(-1);
}
return(1);
}
/// <summary>
/// 移除监听
/// </summary>
public void RemoveDependency(string ListenID)
{
OracleDependency oraDep = dictDependency[ListenID];
if (oraDep != null)
{
OracleConnection oConn = dictConnection[ListenID];
oraDep.RemoveRegistration(oConn);
oraDep = null;
OracleCommand depCmd = dictCommand[ListenID];
depCmd.Dispose();
depCmd = null;
oConn.Close();
oConn.Dispose();
oConn = null;
dictConnection.Remove(ListenID);
dictCommand.Remove(ListenID);
dictDependency.Remove(ListenID);
}
}
public void RemoveRegistration(OracleConnection conn)
{
_dep.RemoveRegistration(conn);
}
public override Task StopAsync(CancellationToken cancellationToken)
{
_dependecy.RemoveRegistration(_connection);
_connection?.Dispose();
return(base.StopAsync(cancellationToken));
}
