Chartjs-How to categorise resultset from Stored Procedure in Asp.Net Core Razor pages for rendering graphs using chartjs

We can try to use the SqlDependency’s OnChange event to detect the database updated and use SignalR to update the Chartjs graph.

You can check thread first, and we can change the commandText as we needed. If the data changed, you can query the database views.

And for front end, we can check this official doc to update the graph.