In this article, Ricardo Peres shows how to detect database changes and notify interested parties through SignalR.
Purpose is to:
- Have a generic class that, given a database connection and SQL string that illustrates the changes I would like to detect, starts monitoring them, and raises an event whenever it sees changes;
- I also want a SignalR hub that I can call from the outside – in this case, the changes event – and broadcasts a message about these changes.
Hope this will help !!!