Sample Download :
CS Version: http://code.msdn.microsoft.com/How-to-use-SqlDependency-5c0da0b3
VB Version: http://code.msdn.microsoft.com/How-to-use-SqlDependency-f4b8eb43
We can use the Sqldependency to get the notification when the data is changed in database, but EF doesn't have the same feature. In this sample, we will demonstrate how to automatically update by Sqldependency in Entity Framework.
In this sample, we will demonstrate two ways that use SqlDependency to get the change notification to auto update data:
1. Get the notification of changes immediately.
2. Get the notification of changes regularly.
You can find more code samples that demonstrate the most typical programming scenarios by using Microsoft All-In-One Code Framework Sample Browser or Sample Browser Visual Studio extension. They give you the flexibility to search samples, download samples on demand, manage the downloaded samples in a centralized place, and automatically be notified about sample updates. If it is the first time that you hear about Microsoft All-In-One Code Framework, please watch the introduction video on Microsoft Showcase, or read the introduction on our homepage http://1code.codeplex.com/.