Issue with SQLDependency to fire Notifications for Multiple Tables.

Copper Contributor


I am using SQL Dependency to register notification with SQL server. I have multiple tables for firing notifications after update. I got fired notification by SQL server after update, but, i could not identify which table is updated after got notification from SQL server. 

Actually , SQL dependency have OnChangeEventHandler to handle single event at one time. How can i use this event handler for register notification for updating multiple tables and fire different notifications for different table. 

Thanks in advance.

0 Replies