SqlTableDependency is a high-level implementation to access table record change notifications from SQL Server.

This class allows you to create a dependency to detect changes on a database table. Every change will trigger a notification messages contains values for the updated, inserted or deleted record, avoid you to execute a further select to update your application data.

If you want to use record change notifications without paying attention to the underlying Service Broker infrastructure, the SqlTableDependency class is your choice.

The SqlTableDependency class represents a notification dependency between an application and a SQL Server Table. When you use SqlTableDependency to get notifications, this componenet provides the low-level implementation creating the Queue and Service Broker.

In this way SqlTableDependency class provides access to notifications without knowing anything about the underlying Service Broker infrastructure. Once a record changed happens, SqlTableDependency's event subscribers are notified.

To install SqlTableDependency, run the following command in the Package Manager Console

Owners

• christian.delbianco

Copyright

2015-2017

Tags

• SQL
• Server
• dependency
• notifications
• service
• broker
• queue
• alerts
• messages

Dependencies

• .NETFramework 4.5.1

  • No dependencies.

Version History

Version	Downloads	Last updated
SqlTableDependency 6.1.0 (this version)	598	Friday, May 26, 2017
SqlTableDependency 6.0.0	215	Monday, May 22, 2017