Skip to main content
BuyLog In
XPO (.NET ORM Library)
Search in…
Docs > API Reference > DevExpress.Xpo.DB.Helpers > MSSql2005SqlDependencyCacheRoot > Members
All docs
V24.2
.NET 8.0+
.NET ORM Library (XPO)
.NET Support
Getting Started
Product Information
Connect to a Data Store
Create a Data Model
Create-Read-Update-Delete (CRUD)
Query and Shape Data
Best Practices and Troubleshooting
Design-Time Features
Examples
Member Tables
API Reference
DevExpress.Xpo
DevExpress.Xpo.DB
DevExpress.Xpo.DB.Helpers
MSSql2005SqlDependencyCacheRoot
Members
Fields
Properties
Methods
MSSqlLocalDBApi
DevExpress.Xpo.Exceptions
DevExpress.Xpo.Helpers
DevExpress.Xpo.Metadata
Microsoft.Extensions.DependencyInjection
Download CHM

MSSql2005SqlDependencyCacheRoot Members

The Root element that is used to connect Node elements to a data store being cached, tracking data store changes via SqlDependency notifications.

Fields

Name Description
XpoProviderTypeString_CacheRoot static Gets the name of a cached data store provider that is created via the MSSql2005SqlDependencyCacheRoot.CreateProviderFromString_CacheRoot method. This name is used internally when generating a connection string via the MSSqlConnectionProvider.GetConnectionString2005CacheRoot method.
XpoProviderTypeString_WithCache static Gets the name of a cached data store provider that is created via the MSSql2005SqlDependencyCacheRoot.CreateProviderFromString_WithCache method. This name is used internally when generating a connection string via the MSSqlConnectionProvider.GetConnectionString2005WithCache method.

Properties

Name Description
AutoCreateOption Returns which operations are performed when a session connects a cached data store for the first time.

Methods

Name Description
CreateProviderFromString_CacheRoot(String, AutoCreateOption, out IDisposable[]) static Returns a cached data store provider, created based on specified settings.
CreateProviderFromString_WithCache(String, AutoCreateOption, out IDisposable[]) static Returns a cached data store provider, created based on specified settings.
CreateSqlDependencyCacheRoot(IDataStore, SqlConnection, ISqlGeneratorFormatter, DataCacheConfiguration, out IDisposable[]) static Obsolete. This method is obsolete (use CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, ISqlGeneratorFormatter, DataCacheConfiguration, out IDisposable[]) instead).
CreateSqlDependencyCacheRoot(IDataStore, SqlConnection, ISqlGeneratorFormatter, out IDisposable[]) static Obsolete. This method is obsolete (use CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, ISqlGeneratorFormatter, out IDisposable[]) instead).
CreateSqlDependencyCacheRoot(IDataStore, SqlConnection, String, ISqlGeneratorFormatter, DataCacheConfiguration, out IDisposable[]) static Obsolete. This method is obsolete (use CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, String, ISqlGeneratorFormatter, DataCacheConfiguration, out IDisposable[]) instead).
CreateSqlDependencyCacheRoot(IDataStore, SqlConnection, String, ISqlGeneratorFormatter, out IDisposable[]) static Obsolete. This method is obsolete (use CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, String, ISqlGeneratorFormatter, out IDisposable[]) instead).
CreateSqlDependencyCacheRoot(MSSqlConnectionProvider, DataCacheConfiguration, out IDisposable[]) static Creates an MSSql2005SqlDependencyCacheRoot instance associated with a specified MSSqlConnectionProvider, providing access to a database to be cached, based on specified settings.
CreateSqlDependencyCacheRoot(MSSqlConnectionProvider, out IDisposable[]) static Creates an MSSql2005SqlDependencyCacheRoot instance associated with a specified MSSqlConnectionProvider providing access to a database to be cached.
CreateSqlDependencyCacheRoot(MSSqlConnectionProvider, String, DataCacheConfiguration, out IDisposable[]) static 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.
CreateSqlDependencyCacheRoot(MSSqlConnectionProvider, String, out IDisposable[]) static 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.
CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, ISqlGeneratorFormatter, DataCacheConfiguration, out IDisposable[]) static 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.
CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, ISqlGeneratorFormatter, out IDisposable[]) static 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.
CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, String, ISqlGeneratorFormatter, DataCacheConfiguration, out IDisposable[]) static 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.
CreateSqlDependencyCacheRoot(IDbConnection, IDataStore, String, ISqlGeneratorFormatter, out IDisposable[]) static 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.
CreateSqlDependencyCacheRoot(String, AutoCreateOption, DataCacheConfiguration, out IDisposable[]) static Creates an MSSql2005SqlDependencyCacheRoot instance associated with an MSSqlConnectionProvider, which is created to provide access to a database to be cached, based on specified settings.
CreateSqlDependencyCacheRoot(String, AutoCreateOption, out IDisposable[]) static Creates an MSSql2005SqlDependencyCacheRoot instance associated with an MSSqlConnectionProvider, which is created to provide access to a database to be cached, based on specified settings.
Do(String, Object) Executes a specified command via the current Root element with specific parameters and returns the operation result.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ModifyData(DataCacheCookie, ModificationStatement[]) Updates data in a cached data store using specified settings and returns the operation result.
ModifyData(ModificationStatement[]) Updates data in a cached data store using specified modification statements and returns the operation result.
NotifyDirtyTables(DataCacheCookie, String[]) Informs a cached data store‘s Root element about specific modified tables.
ProcessCookie(DataCacheCookie) Synchronizes table update information with a cached data store‘s Root element.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
Register() static Registers MSSql2005SqlDependencyCacheRoot as a data store provider for use with XPO.
SelectData(DataCacheCookie, SelectStatement[]) Fetches data from a cached data store using specified query statements and returns the operation result.
SelectData(SelectStatement[]) Fetches data from a cached data store using specified query statements.
ToString() Returns a string that represents the current object. Inherited from Object.
UpdateSchema(DataCacheCookie, DBTable[], Boolean) Updates a cached data store‘s schema according to specified settings.
UpdateSchema(Boolean, DBTable[]) Updates a cached data store‘s schema according to specified settings.
See Also