SqlTableDependency NuGet Package

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

This class allows you to detect changes on a database table. Every change will send 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 change happens, SqlTableDependency's event subscribers are notified.

Got any SqlTableDependency Question?


Version: 8.5.8
Author(s): Christian Del Bianco
Last Update: Monday, January 20, 2020
.NET Fiddle: Create the first Fiddle
Project Url: https://github.com/christiandelbianco/monitor-table-change-with-sqltabledependency
NuGet Url: https://www.nuget.org/packages/SqlTableDependency

Install-Package SqlTableDependency
dotnet add package SqlTableDependency
paket add SqlTableDependency
SqlTableDependency Download (Unzip the "nupkg" after downloading)

.NETStandard 2.0 net451 netcoreapp2.0 7 packages depend on this package.