We are trying to understand how we should setup our SQL tables with SQL Broker and Signalr.
Background: We have a website displaying "people and their statuses" and "signed in users relevant activities". We want to keep this information updated on change in the SQL database, i.e. if a user changes status.
Currently our data tables can contain multiple companies. I.e., Company 1, Company 2... When table and company 1 becomes updated with "changes" we only want to alert every client connected to company 1.
Currently our understanding is that SQL broker does not know what got updated, it just informs web server "hey something changed here, let every client connected to THIS TABLE" (or group?) know about it so they can refresh...
If we understand this correctly, we would probably need to create one table for each "group" or company in this case. Right?
OR, is there a way to have the webserver figure out WHO is affected by the table-change, and only let those people know about it?
Picture for possibly some understanding :) Sketch 1
Tried to read up on signalr hubs and filters, do not quite understand how it should work with SQL broker.