MSSql2005SqlDependencyCacheRoot Class

The Root element that is used to connect Node elements to a data store being cached, tracking data store changes via SqlDependency notifications.

Namespace: DevExpress.Xpo.DB.Helpers

Assembly: DevExpress.Xpo.v24.1.dll

NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo

NuGet Package: DevExpress.Xpo

Declaration

C#

public class MSSql2005SqlDependencyCacheRoot :
    ICachedDataStore,
    ICacheToCacheCommunicationCore,
    IDataStore,
    IDataStoreSchemaExplorer,
    ICommandChannel,
    IDisposable

VB.NET

Public Class MSSql2005SqlDependencyCacheRoot
    Implements ICachedDataStore,
               ICacheToCacheCommunicationCore,
               IDataStore,
               IDataStoreSchemaExplorer,
               ICommandChannel,
               IDisposable

Remarks

As with the standard Root element (DataCacheRoot), the MSSql2005SqlDependencyCacheRoot provides centralized access to a cached Microsoft SQL Server database and promotes data cache updates across Node elements (DataCacheNode and DataCacheNodeLocal) connected to it. In addition, the MSSql2005SqlDependencyCacheRoot subscribes to SqlDependency notifications to be automatically notified about any table updates, including those made outside the cache hierarchy.

You can specify cache configuration settings and designate tables to be cached via the corresponding MSSql2005SqlDependencyCacheRoot.CreateSqlDependencyCacheRoot overloaded method.

Note

Only one Root element (MSSql2005SqlDependencyCacheRoot or DataCacheRoot) can be connected to a data store at one time.

Inheritance

Object

MSSql2005SqlDependencyCacheRoot