Dela via

SqlCommand.NotificationAutoEnlist Property

  • Reference

Definition

Namespace:
Microsoft.Data.SqlClient
Assembly:
Microsoft.Data.SqlClient.dll
Package:
Microsoft.Data.SqlClient v1.0.19269.1
Package:
Microsoft.Data.SqlClient v1.1.4
Package:
Microsoft.Data.SqlClient v2.0.1
Package:
Microsoft.Data.SqlClient v2.1.4
Package:
Microsoft.Data.SqlClient v3.0.1
Package:
Microsoft.Data.SqlClient v3.1.0
Package:
Microsoft.Data.SqlClient v4.0.1
Package:
Microsoft.Data.SqlClient v4.1.0
Package:
Microsoft.Data.SqlClient v5.1.0
Package:
Microsoft.Data.SqlClient v5.2.0

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

public:
 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

Boolean

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

Remarks

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