Using Azure Sql Server, and in C# if that's relevant, is there a way to get an event when data in specific table changes?
In one table we need an event if any column changes in a row.
In a 2nd table we need an event only when either of 2 columns change (although any change would be ok).
And we need to know which row.
Is it possible to do this? If so, how?
Update: We need a call into our C# code for this event. A database trigger where the database can do something doesn't help, our program needs to take action on a change.
thanks - dave