How to receive a notification of a data change in c# from SQL Server 2005?
Posted on 2009-04-02
I have a .NET (v1.1) c# console application that accesses data in an SQL Server 2005 database, via SQL.
I want to have a mechanism to receive a notification (event? trigger?) when something changes in a given table so I can reload it. Whats the easiest way to code that? Obviously I could just poll or something like that - but I'm sure there will be a nice solution supported by my combination of .NET 1.1 SQLConnection classes and SQL Server 2005 backend.
Whats the best/easiest way to achieve that?
thanks - reddal