Skip to main content
.NET 6.0+

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 Package: DevExpress.Xpo

Declaration

public static ICacheToCacheCommunicationCore CreateSqlDependencyCacheRoot(
    MSSqlConnectionProvider nonCachedProvider,
    DataCacheConfiguration cacheConfiguration,
    out IDisposable[] objectsToDisposeOnDisconnect
)

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.

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.

See Also