Here I have shown how to view real-time table data from the database as it is changed at the backend using SignalR and SQL Table Dependency package.
Please run this command in SQL before performing these operations
SELECT is_broker_enabled FROM sys.databases WHERE NAME='your_database_name'
ALTER DATABASE your_database_name SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE
Source Code file :
https://github.com/triple93r/SignalR_...
#dotnetcore #signalr #Sqltabledependency