Jun 01, 2017 09:11 AM|EvenMa|LINK
Hi emrul kayes,
According to your description, you could use SqlDependency to receive the notification from SQL Server when tables changed and then send notify to client by SignalR.
You could refer to the following link, might it help you.
If you have any other questions, please feel free to contact me any time.