ASP. SignalR and database real-time synchronization display

ASP. SignalR and database real-time synchronization display

Error: SQL Server Service Broker for the current database is not enabled, so query notifications are not supported. If you want to use notifications, enable Service Broker for this database

The workarounds are:

C # does not enable SQL Server Service Broker for the current database so query notifications are not supported if you want to use notifications, enable Service broker for this database

ALTER DATABASE Blogdemos SET new_broker with ROLLBACK IMMEDIATE;
ALTER DATABASE Blogdemos SET enable_broker;

SELECT is_broker_enabled from sys.databases WHERE name = ' Blogdemos '

The result is a status of: 1.

ASP. SignalR and database real-time synchronization display