Here is what I want to do:
- Have a windows service that hosts a WCF service. This service also will get notifications from SQL Server via SQLDependency.
- When the windows service gets notified by SQL Server that something has changed, I want it to initiate a callback to all the clients via the WCF service it is hosting.
Here's what I have so far:
- A WCF service that has the callback etc. It works and the clients receive the call back (but so far only if the client sends a message first!).
- The windows service hosting the WCF service, and getting the SQLDependency notifications
Here's where I have fallen on my face:
- How do I get the windows service to notify the WCF service that it should send the message to the clients?