Receive SQL Server notifications on record table change with C#
Here are two examples of application getting notification on record table changes based on SqlTableDependency nuget package.
Source code available at https://github.com/christiandelbianco/Monitor-table-change-with-WPF-WCF-sqltabledependency.
This example show how to keep up to date a grid containing some stocks data.
That grid has been automatically updated whenever a record change using database notifications.
This notification contains new values for the modified table record.
Source code available at https://github.com/christiandelbianco/monitor-table-change-with-mvc-signalR-knockoutjs-sqltabledependency.
This example show how to refresh client web browsers used to book flight tickets.
Those terminals have to be update as soon as the availability change and the Web application must take the initiative of sending this information to clients instead of waiting for the client to request it.
Detect record table changes: Last edit on 10 November 2016 by Christian Del Bianco