Skip to main content
.NET Framework 4.5.2+

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

Creates an MSSql2005SqlDependencyCacheRoot instance associated with an MSSqlConnectionProvider, which is created to provide 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(
    string sqlConnectionConnectionString,
    AutoCreateOption autoCreateOption,
    DataCacheConfiguration cacheConfiguration,
    out IDisposable[] objectsToDisposeOnDisconnect
)

Parameters

Name Type Description
sqlConnectionConnectionString String

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

autoCreateOption AutoCreateOption

An AutoCreateOption value that specifies which operations should be performed when a data store is accessed for the first time.

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