Skip to main content
.NET 8.0+

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

Creates an MSSql2005SqlDependencyCacheRoot instance associated with a specified Microsoft SQL Server provider, which is used to access a database to be cached, based on specified settings.

Namespace: DevExpress.Xpo.DB.Helpers

Assembly: DevExpress.Xpo.v24.2.dll

NuGet Package: DevExpress.Xpo

#Declaration

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

#Parameters

Name Type Description
nonCachedProvider MSSqlConnectionProvider

An MSSqlConnectionProvider providing access to the database.

originalConnectionString String

A connection string for an Microsoft SQL Server database that supports Query Notifications.

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.

See Also