Notification from SQL Server to my App
Posted on 2013-01-14
I've been using timers to check some object status from a database (SQL Server 2008 Express). It was all ok, until the data retrieved was big enought that the timers routine to check got inefficient.
I read something about SQLDependency, which triggers an event when a table is changed and notifies my app. That seems to be great, since i have to treat the data only when I really have to...
The problem is I'm kind of a rookie in database structuring and the examples I found were rather complex for me...
Could someone post here a very simple example that i can understand how to use this? Or if there is a better way that would be welcome too.
Thanks in advance.