How to setup SqlDependency to monitor multiple tables

Question

I am trying to figure out how to monitor more than one table with a SqlDependency. All the examples I have found are for one table.

I have multiple classes that represent a monitor for a specific table. Each time a change event is raised I stop the dependency and start a new one but that unhooks the other monitors. How do I get it to keep monitoring for multiple tables? Do I need to re-hookup all the monitors each time an event is caught?

DixonD · Accepted Answer · 2010-11-02 07:34:03Z

1

Use AggregateCacheDependency class to setup dependency on multiple tables.

answered Nov 2, 2010 at 7:34

DixonD

6,6785 gold badges35 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to setup SqlDependency to monitor multiple tables

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related