start two SqlDependency on same sqlconnection but different sql commands

Question

I build some service that on start open two threads, each one start SqlDependency with same sql connection but the command its different.

Its possible? its seems to working, but after some will when the on change event need wake up its doesnt.

Thanks.

Connection sharing between threads should *not* be done - unless it is *explicitly* stated as being safe/valid, and under what conditions. (That is, the burden of proof is on the consumer - you - to find such documentation.) — , Mar 10 '13 at 10:54

score 2 · Accepted Answer · answered Mar 11 '13 at 14:03

2

Yes. You can submit any number of SqlCommands to be notified, with same or different SQL text (query), on one more many SqlConnection objects.

answered Mar 11 '13 at 14:03

Remus Rusanu

1 Answers1