MSSql2005SqlDependencyCacheRoot.CreateSqlDependencyCacheRoot(IDataStore, SqlConnection, ISqlGeneratorFormatter, DataCacheConfiguration, out IDisposable[]) Method

OBSOLETE

Use CreateSqlDependencyCacheRoot instead.

This method is obsolete (use CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, ISqlGeneratorFormatter, DataCacheConfiguration, out IDisposable[]) instead).

Namespace: DevExpress.Xpo.DB.Helpers

Assembly: DevExpress.Xpo.v23.2.dll

NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo

NuGet Package: DevExpress.Xpo

Declaration

C#

[Obsolete("Use CreateSqlDependencyCacheRoot(IDbConnection connection, IDataStore nonCachedProvider, ISqlGeneratorFormatter formatter, DataCacheConfiguration cacheConfiguration, out IDisposable[] objectsToDisposeOnDisconnect) instead.", false)]
public static ICacheToCacheCommunicationCore CreateSqlDependencyCacheRoot(
    IDataStore nonCachedProvider,
    SqlConnection connection,
    ISqlGeneratorFormatter formatter,
    DataCacheConfiguration cacheConfiguration,
    out IDisposable[] objectsToDisposeOnDisconnect
)

VB.NET

<Obsolete("Use CreateSqlDependencyCacheRoot(IDbConnection connection, IDataStore nonCachedProvider, ISqlGeneratorFormatter formatter, DataCacheConfiguration cacheConfiguration, out IDisposable[] objectsToDisposeOnDisconnect) instead.", False)>
Public Shared Function CreateSqlDependencyCacheRoot(
    nonCachedProvider As IDataStore,
    connection As SqlConnection,
    formatter As ISqlGeneratorFormatter,
    cacheConfiguration As DataCacheConfiguration,
    ByRef objectsToDisposeOnDisconnect As IDisposable()
) As ICacheToCacheCommunicationCore

Parameters

Name	Type	Description
nonCachedProvider	IDataStore	An Microsoft SQL Server provider (an object implementing the IDataStore). Normally, you can pass an MSSqlConnectionProvider object as the parameter.
connection	SqlConnection	An SqlConnection object providing access to a database to be cached.
formatter	DevExpress.Xpo.DB.Helpers.ISqlGeneratorFormatter	A SQL query formatter (an object implementing the ISqlGeneratorFormatter). Normally, you can pass an MSSqlConnectionProvider object as the parameter.
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.