Component which receives SQL Server table changes to your .net code.

You can test it by yourself: http://sbl.azurewebsites.net

1. Copy the SqlDependecyEx class from the ServiceBrokerListener.Domain project to your solution.

2. Make sure that the Service Broker feature is enabled for your database.

   ALTER DATABASE test SET ENABLE_BROKER
   
   -- For SQL Express
   ALTER AUTHORIZATION ON DATABASE::test TO userTest
   

3. Use the class as in example below:

   // See constructor optional parameters to configure it according to your needs
   var listener = new SqlDependencyEx(connectionString, "YourDatabase", "YourTable");
   
   // e.Data contains actual changed data in the XML format
   listener.TableChanged += (o, e) => Console.WriteLine("Your table was changed!");
   
   // After you call the Start method you will receive table notifications with 
   // the actual changed data in the XML format
   listener.Start();
   
   // ... Your code is here 
   
   // Don't forget to stop the listener somewhere!
   listener.Stop();
   

4. Enjoy!

All you need to do is to create multiple listeners with different identities as shown below:

var listener1 = new SqlDependencyEx(connectionString, "YourDatabase", "YourTable1", identity: 1);
var listener2 = new SqlDependencyEx(connectionString, "YourDatabase", "YourTable2", identity: 2);

The listenerType constructor parameter configures SqlDependencyEx to fire an event for different notification types (can fire on INSERT, UPDATE, DELETE separately or together)

var listener = new SqlDependencyEx(connectionString, "YourDatabase",
             "YourTable1", listenerType: SqlDependencyEx.NotificationTypes.Update);

MIT