Skip to main content
.NET Framework 4.5.2+

MSSql2005SqlDependencyCacheRoot.CreateSqlDependencyCacheRoot(String, AutoCreateOption, 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.v22.2.dll

NuGet Package: DevExpress.Xpo


public static ICacheToCacheCommunicationCore CreateSqlDependencyCacheRoot(
    string sqlConnectionConnectionString,
    AutoCreateOption autoCreateOption,
    out IDisposable[] objectsToDisposeOnDisconnect


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.

objectsToDisposeOnDisconnect IDisposable[]

An array of IDisposable objects that must be disposed on disconnect from the database.


Type Description

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

See Also