how to get notify when someone change db manually through sqldependency?

Question

I want to make a method which call automatically when someone make changes in DB in MSSQL Server. where I have to call this? now it's in the childHub Hub class. here are my functions but not working.

This is code snippet

I want to notify when changes made to db.

It looks like you want to use Signalr to update a page with changes, is that correct? I suggest you first look at the documentation learn.microsoft.com/en-us/aspnet/core/tutorials/… and update your answer with what you tried. For example, where do you call your SQLDependencyMessage()? — Rule
– Rule, Commented May 24, 2022 at 9:35

buymeacoffee · Accepted Answer · 2022-05-25 01:46:46Z

3

We can't get more info from your code. When the data in the database is modified, you can get a message notification.

And Rule's comment is also useful, if you want get notification in time, you should use SignalR.

I found a good github repo for you, when the data was modified, it will send message to Dashboard.

SignalR with SqlTableDependency in Asp.Net Core

answered May 25, 2022 at 1:46

buymeacoffee

22.6k2 gold badges23 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to get notify when someone change db manually through sqldependency?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related