2015-04-28-c-firing-code-after-database-changes-with-sqldependency-it_001.cs

class Program 
{
 static void Main(string[] args) 
 {
  string connectionString = Settings.Default.ConnString;
  var changeListener = new DatabaseChangeListener(connectionString);
  changeListener.OnChange += () => {
   Console.WriteLine("There was a change");
   changeListener.Start(@ "SELECT [Name] FROM [dbo].[Cars]");
  };
  changeListener.Start(@ "SELECT [Name] FROM [dbo].[Cars]");

  Console.ReadLine();
 }

 static void dependency_OnChange(object sender, SqlNotificationEventArgs e) 
 {
  Console.WriteLine("Hi!");
 }
}