SqlTableDependency

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.

Info

Version: 8.5.2
Author(s): Christian Del Bianco
Last Update: Sunday, December 9, 2018
.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
Install-Package SqlTableDependency
dotnet add package Z.EntityFramework.Plus.EF6
paket add SqlTableDependency
SqlTableDependency Download (Unzip the "nupkg" after downloading)

.NETStandard 2.0 net451 netcoreapp2.0 1 package depend on this package.


Tags



STATS

must-have-score

8.8

avg-downloads-per-day

45

days-since-last-release

1