MSSql2005SqlDependencyCacheRoot.CreateSqlDependencyCacheRoot(MSSqlConnectionProvider, DataCacheConfiguration, out IDisposable[]) Method

Creates an MSSql2005SqlDependencyCacheRoot instance associated with a specified MSSqlConnectionProvider, providing access to a database to be cached, based on specified settings.

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 static ICacheToCacheCommunicationCore CreateSqlDependencyCacheRoot(
    MSSqlConnectionProvider nonCachedProvider,
    DataCacheConfiguration cacheConfiguration,
    out IDisposable[] objectsToDisposeOnDisconnect
)

VB.NET

Public Shared Function CreateSqlDependencyCacheRoot(
    nonCachedProvider As MSSqlConnectionProvider,
    cacheConfiguration As DataCacheConfiguration,
    ByRef objectsToDisposeOnDisconnect As IDisposable()
) As ICacheToCacheCommunicationCore

Parameters

Name	Type	Description
nonCachedProvider	MSSqlConnectionProvider	An MSSqlConnectionProvider providing access to the database.
cacheConfiguration	DataCacheConfiguration	A DataCacheConfiguration object providing cache configuration settings.
objectsToDisposeOnDisconnect	IDisposable[]	An array of IDisposable objects that must be disposed on disconnect from the database.

Returns

Type	Description
ICacheToCacheCommunicationCore	An MSSql2005SqlDependencyCacheRoot instance (an ICacheToCacheCommunicationCore implementation) ready to be used as the Root element in a cached hierarchy.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the CreateSqlDependencyCacheRoot(MSSqlConnectionProvider, DataCacheConfiguration, out IDisposable[]) method.

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