Skip to content

No events are fired when SQLTabledependency is stared in a task #255

@stevensrf11

Description

@stevensrf11

I am running the SQLTabledependency in a task
After the SQLTabledependency is started a manual reset event waits till it get signals.
No SQLTabledependency events get fired.
How come.
public virtual async Task SqlDependencyAsync(
// public virtual Task SqlDependencyAsync(
, ManualResetEvent taskEndEvent
, string connectionString
, string tableName
, string schemaName

   )
    {
        try
        {

            using (var tableDependency = new SqlTableDependency<PrintQueueSqlDependency>(connectionString
                       , tableName
                       , schemaName
                       , null
                       , null
                       , null
                       , DmlTriggerType.All
                       , false))
            {

                tableDependency.OnChanged += TableDependencyOnChange;
                tableDependency.OnError += TableDependencyOnError;
                tableDependency.OnStatusChanged += TableDependencyOnStatusChanged;
                await taskEndEvent.ManualResetAsyncExtension();
                // taskEvent.WaitOne();
            }
        }
        catch (TableDependency.SqlClient.Exceptions.ImpossibleOpenSqlConnectionException ex)
        {
            IsRunningError = "Failed to run SQLTable Dependency. Could not connect to database";
        );
        }
        catch (Exception ex)
        {
            IsRunningError =$"Failed to run SQLTable Dependency. { ex.Message}";
           
        }
        
    }

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions