OracleCacheDependency Class

The OracleCacheDependency object enables ASP.NET applications to invalidate cached items based on changes made in an Oracle database.

Class Inheritance

System.Object

  System.Web.Caching.CacheDependency

    Oracle.Web.Caching.OracleCacheDependency

Declaration

// C#
public sealed class OracleCacheDependency : CacheDependency

Thread Safety

All public static methods are thread-safe, although instance members are not guaranteed to be thread-safe.

Remarks

This class invalidates data that is cached by ASP.NET applications, based on changes in the Oracle database.

This feature uses the Oracle Database Change Notification feature and requires Oracle Database release 10.2 or later.

The user must have the CHANGE NOTIFICATION privilege, which can be granted with the following SQL statement:

GRANT change notification TO username;

Requirements

Namespace: Oracle.Web.Caching

Assembly: Oracle.Web.dll

Oracle Providers for ASP.NET Version: Oracle Providers for ASP.NET 2.0 and Oracle Providers for ASP.NET 4

---

OracleCacheDependency Members

OracleCacheDependency members are listed in the following tables.

OracleCacheDependency Constructors

The OracleCacheDependency constructor is listed in Table 9-1.

OracleCacheDependency Properties

OracleCacheDependency properties are listed in Table 9-2.

OracleCacheDependency Methods

OracleCacheDependency methods are listed in Table 9-3.

---

OracleCacheDependency Constructors

This constructor instantiates a new instance of the OracleCacheDependency class.

Overload List:

• OracleCacheDependency(OracleCommand)

  This constructor creates an instance of the OracleCacheDependency class.

OracleCacheDependency(OracleCommand)

This constructor instantiates a new instance of the OracleCacheDependency class.

Declaration

// C#
public OracleCacheDependency(OracleCommand cmd);

Parameters

• cmd

  The OracleCommand object has the command text on which the change notification is based.

Remarks

When this constructor is invoked, the OracleCacheDependency object is instantiated and the OracleCommand object is configured for change notification. When the supplied OracleCommand object is executed by the application, the change notification is registered and the OracleCacheDependency instance is notified when changes are detected on the server side.

---

OracleCacheDependency Properties

OracleCacheDependency properties are listed in Table 9-4.

---

OracleCacheDependency Methods

OracleCacheDependency methods are listed in Table 9-5.

GetUniqueID

This method returns a string that uniquely identifies the OracleCacheDependency object.

Declaration

// C#
public override string GetUniqueID()