SignalR - getting new data from sql DB
Posted on 2016-10-25
Im looking at SignalR, however i'm a little confused about how it will update based on new data
I have a sql server 2014 enterprise table called tblAssets
On this table is a column called LatestRecordId
This contains the latest ID from a table called tblAssetLogs
Currently, every 30 seconds I use long polling to get the latest asset log data.
What i want to do:
1. every time tblAssets.LatestRecordId is changed, then push the new data to the client
Does anyone know if this is possible? and how i would achieve this?
I'm using .net framework 4.5 and iis7 on windows 2008 r2