Query Notifications
- Hi,
I am new to Query notifications. Studying the literature, I can not figure out the connection between
ContactChangeMessages and ContactChangeNotifications on the one hand in
ms-help://MS.VSCC.v90/MS.MSDNQTR.v90.en/wd_adonet/html/a5333e19-8e55-4aa9-82dc-ca8745e516ed.htm
AND
Example in
ms-help://MS.VSCC.v90/MS.MSDNQTR.v90.en/wd_adonet/html/88bf9b56-5769-4595-98c4-80285d812a5e.htm
Nowhere in the example are the service broker queue and / or service broker service from the top of this page mentioned.
Where is the connection?
Thanks in advance!- Moved byDan BenediktsonMSFTFriday, November 06, 2009 5:50 PMSSB is the intended replacement for Query Notifications (From:SQL Server Data Access)
Answers
- PMBT,
The first link is talking about Query Notifications, which is a low level concept and requires some manual work to configure and set up (such as creating messages). The second link is about SqlDependency, which is an abstraction layer built on top of Query Notifications. When using SqlDependency, you don't need to worry about creating database objects - they will be created for you when you call SqlDependency.Start() in your application.
Thanks,
Pawel- Marked As Answer byNai-dong Jin - MSFTMSFT, ModeratorTuesday, November 10, 2009 4:19 AM
All Replies
- PMBT,
The first link is talking about Query Notifications, which is a low level concept and requires some manual work to configure and set up (such as creating messages). The second link is about SqlDependency, which is an abstraction layer built on top of Query Notifications. When using SqlDependency, you don't need to worry about creating database objects - they will be created for you when you call SqlDependency.Start() in your application.
Thanks,
Pawel- Marked As Answer byNai-dong Jin - MSFTMSFT, ModeratorTuesday, November 10, 2009 4:19 AM
