Looking for push technology for data change broadcasting

Question

Hi,   suppose we may store our data in xml file or database. so we may need to notify our client when any data will be changed. so tell me what best possible way exist in .Net technology.   i know people refer to use sql dependency but  sql dependency is not good and not push technology rather it is long polling. so please guide me if any best push technology exist in .Net which automatically broadcast data change in sql server database.   Thanks

Nilesh Shah · Accepted Answer

I suggest you 2 options:

1)

Use SignalR. with dot net implementation of SignalR technology, a server can invoke a call on client so that when ever you change something you can send signal to your clients for the same

2)

Use Microsoft Office 365 or SharePoint online to store ur data, in sharepoint store or in sharepoint lists. Using MS Graph API webhooks, you can notify your clients when a change happens.

Tridip Bhattacharjee · Answer

HI Nilesh thanks for your answer.   i do not know sharepoint. i am just storing data in sql server db and want to detect data change at application level when data change will occur in db.   i got a very bad feedback for sql depenency. so i like to avoid it. so tell me anything better exist to notify data change in db to client. thanks

Gokhul Varman · Answer

Please refer the link for detailed explanation:https://forums.asp.net/t/2126637.aspx?Looking+for+push+technology+for+data+change+notification+to+client