[Sample Of Oct. 13] How to Execute the SqlCommand with a SqlNotificationRequest

Oct.

13

Sample : https://code.msdn.microsoft.com//How-to-Execute-the-1e7c35d5

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 https://1code.codeplex.com/.