Home

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
Vjay_KuMaR
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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies