SqlCacheDependencyAdmin::DisableTableForNotifications Method (String^, array<String^>^)

 

Disables SqlCacheDependency change notifications on an array of SQL Server database tables.

Namespace:   System.Web.Caching
Assembly:  System.Web (in System.Web.dll)

public:
static void DisableTableForNotifications(
	String^ connectionString,
	array<String^>^ tables
)

Parameters

connectionString
Type: System::String^

A connection string used to connect to the SQL Server database.

tables
Type: array<System::String^>^

The array of SQL Server database tables on which to disable change notifications.

Exception Condition
DatabaseNotEnabledForNotificationException

The database is not enabled for change notifications.

ArgumentException

One of the values in the tables parameter is null.

-or-

One of the values in the tables parameter is an empty string ("").

ArgumentNullException

tables is null.

HttpException

A connection to the database could not be established.

-or-

The security context of the ASP.NET application does not have permission to connect to the database.

-or-

The security context of the ASP.NET application does not have permission to disable notifications for the database.

The DisableTableForNotifications method removes change notifications from the tables specified in the tables parameter. These tables must be in the database specified in the connectionString parameter.

Once you have used the DisableTableForNotifications method to disable change notifications for a list of tables, you must use one of the EnableTableForNotifications overloads if you wish to re-enable change notifications.

.NET Framework
Available since 2.0
Return to top
Show: