Hello,
Here's what I want to achieve:
Have a wpf system tray application or a vista gadget that will show me live data from a database view. I need to use a WCF service to retrieve the data. The data in the underlying tables will be changing frequently but I can do without upto the second updates in the client (if I have to).
How do you think I should design this?
I'm planning to write a duplex wcf service so that it can call back to the client application and notify that the view is updated. Some questions come to my mind
How will the wcf service know that the view has been updated (because of change in the underlying table data)
What kind of instance management should I use - per call or per session?
How should I bind the wpf controls to the wcf service so that the data looks like it is live?
Looking forward to your sueggestions.
Thank you