The best way to get it implemented by using the SignalR. It is completely free to download. We have used this for similar scenarios.
Here is the url:
http://signalr.net/[
^]
It is having a wrapped Web Socket functionality to meet these kind of cases. Or you can directly go for Web Sockets:
http://msdn.microsoft.com/en-in/library/ie/hh673567(v=vs.85).aspx[
^]
The above are the direct ways for it but still there are alternatives as below.
If you are using the 4.5 version, then you can try the following way.
. From code need to use the Async and Await which need to contact to the DB and wait for a response. If it has got a response that an update happened in DB then can show the popup
. It should be a recursive call. I mean it need to keep open the communiction alive with the async call. Once the wait time is over another one request should go to the db.
. The samething can be done using Thread or .Net's Background_Worker class
. The key thing is that we need to have the Thread or Background_Worker to run recursive.
Here you can see how to use Async:
http://msdn.microsoft.com/en-us/library/vstudio/hh191443.aspx[
^]
Hope this helps.
Thank You,
Siju Thomas.