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
48:37 Final output
53:04 Source Code

Source Code

Buy me a Coffee!

SignalR Basics in Asp.Net Core

Asp .NET MVC Core

[Azm]

This is impressive!! I'd like to learn more about this! Again Thank you so much

[marzzuri]

Thank you very much for this video impressed by the attention to detail and easy to follow. Please do more. Be glad to participate in the Patreon.

[imboko]

One of the best videos I have used. Thank you!

[DguruZ]

What a beautiful work bro, you are the best!

[muratkecici]

Thank you so much. A big question mark about my project has been eliminated. Perfect solution!...

[SonicFox]

100k likes is still less than what you have teach us. Thanks for uploading. Keep sharing.

[waqasmumtaz]

I was so confused about signalR how it works properly for real time updates. But i will do it now thanks let me watch and practice

[ziadeltaher]

you are grate bro this is the second time that i watch it 💘

[stkuo]

Hi. It is a nice vedeio, thanks for the sharing of the information.

[nmarks]

Hi, just to say that I cloned your code from Github and after setting up the necessary SQL Database I got this to work perfectly. Many thanks indeed.

[ziadeltaher]

You are amazing my friend keep going MASHAALLAH 💘❤

[gkmnada]

First of all, thank you very much for the video. Thanks to you, I applied SignalR and SqlDependency in my project. Everything was working properly but then I changed my query method on the Hub side. The change I made on the table side was to use a relationship. Then it gave an error. This is the error in the console,
Error: Connection disconnected with error 'Error: Server returned an error on close: Connection closed with an error.'.
and
Error: Server returned an error on close: Connection closed with an error.

function InvokeTaskList() {
(error) {
console.log(error);
return
})
}
This is where he catches the error.

[waqasmumtaz]

Subscribed i wish u alos explain concepts by ur voice

[vypucme]

This is the best!
I also want to know how to apply it in the crud method.
insert, update. delete, etc
I'd appreciate it if you could at least give me a reference link.
Your video is very helpful for studying! Thank you!

[eventzaa]

thk, the best!

I have some problem.
When running project. Why data in query table on some column is null. But! When stop project data in column back to normal is not null

[nmarks]

Could I suggest for a future video:
.Net MAUI, Blazor, SignalR, API, Identity.

That would be truly awesome.

[brjdyxter]

i have a string variable in object but it has number behind, for example : public string price1;
when i use it in bindtogrid function in DashBoard.js i cant use object.price1, object.price without number 1 is usable.
is there any way to use object.price1.

[brilliantMotjiang]

Hi every time i am running an sqltabledependency and signalr project i get this error: System.DllNotFoundException: 'Unable to load DLL 'sni.dll' or one of its dependencies: The specified module could not be found

[ruwanc]

Thnak you very much,
I need to filter the products according to previous page selection, can you explain how to do this

[cinarsinan]

I really liked this this is absolutely good tutorial i faced some difficulties but i will solve and complete it. Can you show us to add these codes to free dashboard templates ( bootstrap templates) For example AdminLTE 3.