2015-05-26-developing-real-time-applications-with-signalr-and-sqldependency-in-asp-net-mvc-and-c_001.cs

string connectionString = Settings.Default.ConnString;
string listenQuery = @ & quot;
SELECT[Name] FROM[dbo].[Insurers] & quot;;

// Create instance of the DB Listener
DatabaseChangeListener changeListener = new DatabaseChangeListener(connectionString);

// Define what to do when changes were detected
changeListener.OnChange += () => 
{
 ChatHub.SendMessages();

 // Reattach listener event - DO NOT TOUCH!
 changeListener.Start(listenQuery);
};

// Start listening for changes
changeListener.Start(listenQuery);