SqlDependency Only firing event once

[Guest]

Hey gang.

I am just learning the SqlDependency class for the first time. I am really
thankful for this class I believe. I thought I was going to have to do SQL
CLR Trigger that called my WebService.

Anyways, I am using the SqlDependency.OnChange event and its working great
except that it only fires once. If I make a 2nd change to a field in the
table, it doesn't fire a second time.

Is there any reason for this? What have I done wrong? The first response
comes back perfectly as expected.

Thanks and take care.

 

[Miha Markic [MVP C#]]

Hi,

If I remember properly, you have to re-link dependency after change.