Audit table change infrastructure setup

NuGet Package to get alerts on record table changes

Project site

SqlTableDependency is a high-level implementation component to monitor record table change. It receive notifications containing modified record table values from SQL Server when the content of a specified table change.

If you want to use SQL Server notifications to audit your table change without paying attention to the underlying Service Broker infrastructure, the SqlTableDependency is your choice.

A full documentation can be found on Hit Hub site at SqlTableDependency.

Nuget package content

SqlTableDependency nuget package contains two dll:

  • TableDependency.dll
  • SqlTableDependency.dll

TableDependency.dll contains abstractions and base class, as well as common funtionality. This because initially there was an implementation for Oracle too.

SqlTableDependency.dll contains concrete implementation for monitor table change on SQL Server.

Installation

You can download and install SqlTableDependency from Visual Studio Package Manager Console using the following command:

install audit table change dll nuget package

You can also search and download SqlTableDependency from Manage Nuget Package:

install audit table change dll from Visual Studio

System requirements

SqlTableDependency is open source C# projects built with:

  • C#
  • .NET Framework 4.5.1
  • Microsoft SQL Server 2012

Detect record table changes: Last edit on 10 November 2016 by Christian Del Bianco

Web hosting by Somee.com