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.v18.1.dll

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 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.

Related GitHub Examples

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.

C#

XPO_how-to-create-a-data-caching-service-that-helps-improve-performance-in-distributed-e4932/CS/WcfService2/Service1.svc.cs#L21

IDisposable[] objectsToDispose;
MainDataStore = (ICachedDataStore)MSSql2005SqlDependencyCacheRoot.CreateSqlDependencyCacheRoot(
           dataStore,

VB.NET

XPO_how-to-create-a-data-caching-service-that-helps-improve-performance-in-distributed-e4932/VB/WcfService2/Service1.svc.vb#L15

    Dim objectsToDispose() As IDisposable
    MainDataStore = CType(MSSql2005SqlDependencyCacheRoot.CreateSqlDependencyCacheRoot(dataStore, New DataCacheConfiguration(DataCacheConfigurationCaching.InList, "Customer"), objectsToDispose), ICachedDataStore)
End Sub

Inheritance

Object

MSSql2005SqlDependencyCacheRoot