Notifications : Service Broker, SqlDependency and NotifyIcon
Hi Guys, This time I made a small application to show notifications using Service Broker (Query Notifications), SqlDependency and NotifyIcon. Before you Start, 1) Sql Server (Any Version) 2) Visual Studio (Any Version) Step One : Enable Service Broker for the Database you work on. Step Two : Add the Following Code in a Console/Windows Application using System; using System.Collections.Generic; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Security.Permissions; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace TestApplication { class Program { static void Main(string[] args) { //Start the Dependency ...