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.v23.2.dll

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

NuGet Package: DevExpress.Xpo

Declaration

C#

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

VB.NET

Public Shared Function CreateProviderFromString_WithCache(
    connectionString As String,
    autoCreateOption As AutoCreateOption,
    ByRef objectsToDisposeOnDisconnect As IDisposable()
) As IDataStore

Parameters

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.

Returns

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

Remarks

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.