it will be good if i need to show change data in db through sql dependency and signalr. suppose my transaction table often changed by many people. suppose in few second data is change many time then i like to know how notification will go to sql dependency class ?
change data will be queued before sql dependency class ? sql dependency class can handle data change when huge no of traffic will do the changes ?
here i was reading a article on SqlDependency & SignalR. the link is http://techbrij.com/database-change-notifications-asp-net-signalr-sqldependency
few things was not clear to me.
- how to give subscribe query notification permission to IIS ?
- please see the line in this article.
.
private void dependency_OnChange(object sender, SqlNotificationEventArgs e) {
JobHub.Show();
}
when data will change then dependency_OnChange event will fire and JobHub.Show();
is calling
JobHub is name of class and not static class so i like to know how anyone can call `JobHub.Show();` from out side ??
- what is GlobalHost class and when it is used ?
- the article code related issue. just go to this link
http://techbrij.com/database-change-notifications-asp-net-signalr-sqldependency
see the jquery code in view which fetch data and populate table. first time when page load suppose there is 5 records exist in table so 5 records will be passed to jquery code and it will just display those 5 records but when any existing data will be change in table then what will happen ??
the only changed rows will come to client side or all data including changed data will come to client side ?
if you say only changed data will code then just see the video in that link. it is shown in the video data is changed one by one and change is reflecting at client end but if you see the jquery code it just empty the table first and build the table again. so my question is if data change and only change data will come then one row should display at client side.... am i right. but in video the change is showing as well as other data is too.
so please for good sake read the link article once and then answer my question. thanks
please guide me. thanks
See Question&Answers more detail:os