How to get notified when a row is added in SQL Server database using asp.net core 2?

Question

Hi, how can I get notification when a new row is added in the database using asp.net core 2. For example, I have table Posts and have 4 posts, and when the table contains the new post ( post 5) I will get a notification to my view in asp.net core2 says that the new post added. Thanks.

vikas_jk · Accepted Answer

I believe you will be adding new rows using C# in asp.net core 2, once you do that push notification to user using SignalR

https://docs.microsoft.com/en-us/aspnet/core/signalr/introduction?view=aspnetcore-2.1

https://docs.microsoft.com/en-us/aspnet/core/tutorials/signalr?view=aspnetcore-2.1&tabs=visual-studio

https://www.codemag.com/article/1210071/The-Simplest-Thing-Possible-Creating-Push-Notifications-with-SignalR

The above links should help you to understand SignalR and using it in .net core

How to get notified when a row is added in SQL Server database using asp.net core 2?

Related Articles

Subscribe Now

Related Questions