After executing a command on database to get data, the data may be changed the other clients. If the application need the latest data, it need a notification from the server. In this application, we will demonstrate how to execute the SqlCommand with a SqlNotificationRequest:
1. Set and execute the SqlCommand with a SqlNotificationRequest;
2. Begin to monitor the queue in SqlServer;
3. Refresh the data.
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/.