Is it possible to have a WinForm/WPF app that waits on a new record to be inserted to SQL database and have event thrown when inserted? Meaning, I would like to have an app wait for a new record. Once inserted, an event is thrown which will then update my UI with info from new record to textboxes, etc. I don't want to have to repeatly poll database to see if there are new records. Would be nice to fire an event. Does anyone have examples and/or links on how to do so. Eventually would like to move to a service to wait and react to new records, but an app will do for now. TIA.
