SqlCacheDependencyAdmin.DisableTableForNotifications Method (String, String[])

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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,
	string[] tables
)

Parameters

connectionString
Type: System.String

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

tables
Type: 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: