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.v21.2.dll

Declaration

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

Remarks

As with the standard Root element (DataCacheRoot), the MSSql2005SqlDependencyCacheRoot provides centralized access to a cached MS 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.

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the MSSql2005SqlDependencyCacheRoot class.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

Inheritance

Object
MSSql2005SqlDependencyCacheRoot
See Also