The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
The page you are viewing does not exist in the .NET Standard 2.0+ platform documentation. This link will take you to the parent topic of the current section.

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

Declaration

public class MSSql2005SqlDependencyCacheRoot :
    ICachedDataStore,
    ICacheToCacheCommunicationCore,
    IDataStore,
    IDataStoreSchemaExplorer,
    ICommandChannel,
    IDisposable
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 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.

Inheritance

Object
MSSql2005SqlDependencyCacheRoot
See Also