Query Notifications and LINQ to SQL - Well I'll be, you *can* do it (with caveats)
Posted by: Julia Lerman Blog - Dont Be Iffy...,
on 15 Sep 2007 |
View original | Bookmarked: 0 time(s)
I'm ashamed that this is STILL on my to-do list as I have probably written and presented
more about Query
Notification than most people. But I see via Roger
Jennings blog that Ryan
Dunn has the key of the implementation posted on his blog (by way of a hot tip
from Mike Pizzo on the DP* team).
To activate Query Notification, you need to get a query "registered" in SQL Server's
Service Broker then listen for a notification.
ADO.NET 2.0's SqlDependency class does all the dirty work then all you need...