SignalR and Sql Dependency in asp.net core 1.1

Question

User665712185 posted

Im working on a project whereby i want to push notifications to the client whenever the database changes. Is it possible in asp.netCore 1.1

Answer 1

User765422875 posted

SignalR is available for .NET core https://github.com/aspnet/SignalR

However, SqlDependency is not available with .NET core.

You will have to poll the database using another mechanism. Another option is to write a CLR stored procedure that calls a Web API method, in-which you can hook up to your SignalR Hub method to notify clients.