Issue with SQLDependency to fire Notifications for Multiple Tables.

%3CLINGO-SUB%20id%3D%22lingo-sub-712714%22%20slang%3D%22en-US%22%3EIssue%20with%20SQLDependency%20to%20fire%20Notifications%20for%20Multiple%20Tables.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712714%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20am%20using%20SQL%20Dependency%20to%20register%20notification%20with%20SQL%20server.%20I%20have%20multiple%20tables%20for%20firing%20notifications%20after%20update.%20I%20got%20fired%20notification%20by%20SQL%20server%20after%20update%2C%20but%2C%20i%20could%20not%20identify%20which%20table%20is%20updated%20after%20got%20notification%20from%20SQL%20server.%26nbsp%3B%3C%2FP%3E%3CP%3EActually%20%2C%20SQL%20dependency%20have%20OnChangeEventHandler%20to%20handle%20single%20event%20at%20one%20time.%20How%20can%20i%20use%20this%20event%20handler%20for%20register%20notification%20for%20updating%20multiple%20tables%20and%20fire%20different%20notifications%20for%20different%20table.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

Hi

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.