SQLDependency thread

Posted by user171523 on Stack Overflow See other posts from Stack Overflow or by user171523
Published on 2010-04-28T15:19:12Z Indexed on 2010/04/28 15:23 UTC
Read the original article Hit count: 453

Filed under:
|
|

i am in the process implementing SQLdepenency i would like to know in case of Dependency Handler exeuctues will it spun a different thred from main Process ? What will happen when the event handler triggers? Do i need to worry about any multithreds issues?

public void CreateSqlDependency() { try {

            using (SqlConnection connection = (SqlConnection)DBFactory.GetDBFactoryConnection(Constants.SQL_PROVIDER_NAME))
            {
                SqlCommand command = (SqlCommand)DBFactory.GetCommand(Constants.SQL_PROVIDER_NAME);
                command.CommandText = watchQuery;
                command.CommandType = CommandType.Text;
                SqlDependency dependency = new SqlDependency(command);
                //Create the callback object 
                dependency.OnChange += new OnChangeEventHandler(this.QueueChangeNotificationHandler); 
                SqlDependency.Start(connectionString);

                DataTable dataTable = DBFactory.ExecuteSPReDT(command);
            }

                       }
        catch (SqlException sqlExp)
        {
                           throw sqlExp;
        }
        catch (Exception ex)
        {
                           throw ex;
        }
    }

public void QueueChangeNotificationHandler(object caller, SqlNotificationEventArgs e) { if(e.Info == SqlNotificationInfo.Insert) Fire(); }

© Stack Overflow or respective owner

Related posts about sqldependency

Related posts about c#