SqlCommand.NotificationAutoEnlist Property


Gets or sets a value indicating whether the application should automatically receive query notifications from a common SqlDependency object.

 property bool NotificationAutoEnlist { bool get(); void set(bool value); };
public bool NotificationAutoEnlist { get; set; }
member this.NotificationAutoEnlist : bool with get, set
Public Property NotificationAutoEnlist As Boolean

Property Value


true if the application should automatically receive query notifications; otherwise false. The default value is true.


This feature is used in ASP.NET applications to receive notifications for all commands executed in an ASP page against SQL Server. This enables ASP.NET to cache the page until the queries used to render the page would produce a different result. Automatic enlistment.

This property applies only to versions of SQL Server that support query notifications. For earlier versions, setting this property to true has no effect on the application.

Applies to

See also