Skip to main content
.NET 6.0+

MSSql2005SqlDependencyCacheRoot.CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, String, ISqlGeneratorFormatter, 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.1.dll

NuGet Package: DevExpress.Xpo

Declaration

public static ICacheToCacheCommunicationCore CreateSqlDependencyCacheRoot(
    IDbConnection connection,
    IDataStore nonCachedProvider,
    string originalConnectionString,
    ISqlGeneratorFormatter formatter,
    out IDisposable[] objectsToDisposeOnDisconnect
)

Parameters

Name Type Description
connection IDbConnection

An IDbConnection object providing access to a database to be cached.

nonCachedProvider IDataStore

An Microsoft SQL Server provider (an object implementing the IDataStore). Normally, you can pass a MSSqlConnectionProvider object or its descendant as the parameter.

originalConnectionString String

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

formatter DevExpress.Xpo.DB.Helpers.ISqlGeneratorFormatter

A SQL query formatter (an object implementing the ISqlGeneratorFormatter). Normally, you can pass a MSSqlConnectionProvider object or its descendant as the parameter.

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