More on SQL Server Query Notifications
I found this post by Rushi Desai on Invalidating cached result sets using SQL Server Query Notification. It's from March so it's a bit out of date, but it has some working ASP.NET sample code (well, working in Beta 2, I presume, but pretty close for RTM).