private void DeactivateListener(ISqlDependencyListener sqlListener)
{
sqlListener.DependecyIstance.Stop();
sqlListener.DependecyIstance.TableChanged -= sqlListener.ChangeHandler;
sqlListener.DependecyIstance.Dispose();
}
private async Task ActivateListener(ISqlDependencyListener sqlListener, int listenerCounter)
{
try
{
sqlListener.DependecyIstance = new SqlDependencyEx(_connectionFactory.GetConnectionString(), _connectionFactory.GetDbInitialCatalog(), sqlListener.DependencyTableName, "dbo", sqlListener.ListenerType, sqlListener.ReceiveDetails, listenerCounter);
sqlListener.DependecyIstance.TableChanged += sqlListener.ChangeHandler;
await sqlListener.DependecyIstance.Start();
}
catch (SqlException ex)
{
_logger.Error(ex);
}
catch (Exception ex)
{
_logger.Error(ex);
}
}
