Info
| 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
Install-Package SqlTableDependency
dotnet add package SqlTableDependency
paket add SqlTableDependency
SqlTableDependency Download (Unzip the "nupkg" after downloading)
Dependencies
.NETStandard 2.0
- System.ComponentModel.Annotations(>= 4.4.0)
- System.Data.SqlClient(>= 4.3.0)
- System.ComponentModel.Annotations(>= 4.4.0)
- System.Data.SqlClient(>= 4.3.0)
- System.ComponentModel.Annotations(>= 4.4.0)
- System.Data.SqlClient(>= 4.3.0)
Tags
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.