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


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.


Asked by:- LuneAgile
0
: 69 At:- 11/5/2018 3:37:57 PM
ASP.NET SQL-server adding-row-notification






2 Answers
profileImage Answered by:- vikas_jk

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

1
At:- 11/6/2018 7:04:32 AM


profileImage Answered by:- LuneAgile

 

Thanks Vikas_jk .

0
At:- 11/6/2018 11:50:12 AM





Login/Register to answer
Or
Register directly by posting answer/details

Full Name *

Email *




By posting your answer you agree on privacy policy & terms of use