Hello,
I have enabled Sql service broker to monitor change notification for specific table. But RecordChangedEventArgs is not getting fired when i make update to the products table. Here is my code.
public void SubscribeTableDependency(string connectionString)
{
tableDependency = new SqlTableDependency<TIpwProjectCopyQueue>(connectionString, "tProducts");
tableDependency.OnChanged += TableDependency_OnChanged;
tableDependency.OnError += TableDependency_OnError;
tableDependency.Start();
}
public void TableDependency_OnChanged(object sender, RecordChangedEventArgs<tProducts> e)
{
if (e.ChangeType.ToString() == "Update")
{
// Message
}
}