Is SqlDependency
supported in SqlLocalDb
? If yes how to enable it?
Answering the question about Service Broker in your subject.
Service Broker should work fine in LocalDB, but only local queues are available. Remote queues won't work, in either direction (in fact Service Broker queues are bi-directional, so there's no incoming/outgoing queue distinction).