I need to build app with real-time SQL Server notifications (DB will be updated from external app). I use ASP.NET 5 (MVC 6). I want to use SqlDependency but it is unavailable in DNX Core 5.0 and I get an error:
CS0246 The type or namespace name 'SqlDependency' could not be found (are you
missing a using directive or an assembly reference?)
What can I do to use SqlDependency in MVC 6.