Detect Changes In Database And Send Changed Row Information To .NET Core 3.1 For Push Notification

Question

I have a database containing employee attendance information. The changes in DB is triggered by fingerprint machine not my software, That's Why I can't track SaveChanges() function. Does SQL Dependency works in my case if yes then how to implement it in .NET Core 3.1. If Database Changes is happening outside of my software scope how to detect that change and send that specific changed row id to .NET Core Application for displaying notification.

Hedgybeats · Accepted Answer · 2022-03-09 07:28:06Z

1

Perhaps you could use SqlTableDependency?

I found this article which seems to be implementing what you desire. It is quite an old article, but maybe you could use the same concept?

answered Mar 9, 2022 at 7:28

Hedgybeats

3561 gold badge4 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Detect Changes In Database And Send Changed Row Information To .NET Core 3.1 For Push Notification

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