Skip to content

How to set additional SqlTableDependency settings

Tomas Fabian edited this page Mar 22, 2020 · 1 revision

You can set the following additional settings by overriding SqlTableDependencyProvider.OnCreateSettings:

    protected override SqlTableDependencySettings<TEntity> OnCreateSettings()
    {
      var settings =  base.OnCreateSettings();

      settings.SchemaName = "dbo";
      settings.UpdateOf = null;
      settings.Filter = null;
      settings.NotifyOn = DmlTriggerType.All;
      settings.ExecuteUserPermissionCheck = true;
      settings.IncludeOldValues = false;

      return settings;
    }