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