SignalR with Sql Table Dependency in Asp.Net Core
This tutorials is about pushing database changes to the UI dashboard using Signal R with Sql Table Dependency.
SqlTableDependency is a high-level C# component used to audit, monitor and receive notifications on SQL Server’s record table changes. For any record table change, as insert, update or delete operation, a notification containing values for the record changed is delivered to SqlTableDependency.
Database scripts are placed inside the project solution. You can find the source code in following link.
00:00 Preview
01:32 Introduction
01:52 Setup Asp.Net Core Web App and Configure Signal R
04:55 Display Product Details on the Dashboard
12:40 Sql Table Dependency (Enable Service Broker and Get data from database)
18:40 Custom Middleware
23:37 Sql Table Dependency for another table
42:32 Dashboard with Signal R using Chart.js
48:37 Final output
53:04 Source Code
Source Code
https://github.com/Skynet-Demos/SignalR-SqlTableDependency
Buy me a Coffee!
https://www.buymeacoffee.com/skynetechs
SignalR Basics in Asp.Net Core
https://youtu.be/_RepoZyMtL4
Asp .NET MVC Core
https://www.youtube.com/playlist?list=PLo-ZNwEHZHqbP28HuOW-qNT_K-pU7Hj5O
Comments are closed.