Private Sub dependency_OnChange(sender As Object, e As SqlNotificationEventArgs) Dim nHub As New NotificationHub() nHub.SendNotifications() End Sub This works but fires multiple multiple times for any single record operation. I then tried: Private Sub dependency_OnChange(sender As Object, e As SqlNotificationEventArgs) If e.Type = SqlNotificationType.Change Then Dim nHub As New NotificationHub() nHub.SendNotifications() End If End Sub
If e.Info = SqlNotificationInfo.Insert _ Or e.Info = SqlNotificationInfo.Delete _ Or e.Info = SqlNotificationInfo.Update Then Dim nHub As New NotificationHub() nHub.SendNotifications() End If
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)