Skip to main content

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

Returns a cached data store provider, created based on specified settings.

Namespace: DevExpress.Xpo.DB.Helpers

Assembly: DevExpress.Xpo.v24.1.dll


public static IDataStore CreateProviderFromString_WithCache(
    string connectionString,
    AutoCreateOption autoCreateOption,
    out IDisposable[] objectsToDisposeOnDisconnect


Name Type Description
connectionString 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 disconnecting from the database.


Type Description

A DataCacheNode instance (an IDataStore implementation) which is connected to a MSSql2005SqlDependencyCacheRoot associated with a MSSqlConnectionProvider, that is created based on specified settings.


Do not pass the connection string created via the MSSqlConnectionProvider.GetConnectionString method. The CreateProviderFromString_WithCache method accepts generic connection strings only, without the XPO-specific “XpoProvider=XXX“ part.

See Also