| Name | Description | |
|---|---|---|
![]()  | SqlServerCacheProvider Constructor | Constructor which takes a connection string | 
The following tables list the members exposed by SqlServerCacheProvider.
| Name | Description | |
|---|---|---|
![]()  | SqlServerCacheProvider Constructor | Constructor which takes a connection string | 
| Name | Description | |
|---|---|---|
![]()  | BytesForCacheItemInfo | The bytes for cache item information (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
| Name | Description | |
|---|---|---|
![]()  | CacheTableName | The name of the cache table. The default is SmartCache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | DefaultCacheCapabilities | Get a list of the cache capabilities (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | DefaultExpirationInMinutes | Gets or sets the maximum minutes for a cache item to expire. It must be greater than zero. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider) | 
![]()  | EncryptionKey | The Encryption Key (password) to use when encrypting data (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider) | 
![]()  | IsAsyncSetAndRemove | If true, cache items will be saved and removed asynchronously (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | IsBusy | Gets a value indicating whether this instance is busy scavenging. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | IsCompressed | If true, the data is compressed before it is saved and decompressed upon load. The default is false. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider) | 
![]()  | IsDisposed | Gets or sets a value indicating whether this instance is disposed. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | IsEncrypted | If true, the data is encrypted before it is saved and decrypted upon load. The default is false. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider) | 
![]()  | MaxCacheItems | The maximum number of cache items to store in the cache. The default is Int32.MaxValue. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | MaxMegabytes | The maximum number of megabytes for the cache. The default is 50 Megabytes. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Name | Overridden. Gets the name of a specific cache instance. | 
![]()  | ScavengingIntervalMilliseconds | How often to check to remove expired items. The default is 60000 milliseconds (1 minute). (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | ScavengingTypeOption | Determines what priority to scavenge items from the cache. The default is Oldest. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider) | 
![]()  | ThreadName | The name of the thread that is used when scavenging (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
| Name | Description | |
|---|---|---|
![]()  | ConnectionString | The connection string for the database provider (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | DatabaseProvider | Overridden. Provider of basic CRUD operations | 
![]()  | TableCreationSql | Overridden. The SQL to create the caching table | 
| Name | Description | |
|---|---|---|
![]()  | Add | Overloaded. Inserts a cache entry into the cache without overwriting any existing cache entry. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider) | 
![]()  | AddOrGetExisting | Overloaded. Inserts a cache entry into the cache, by using a key, an object for the cache entry, an absolute expiration value, and an optional region to add the cache into. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider) | 
![]()  | ClearAll | Clear all items in the cache. If the database can be packed, it will be packed. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | ClearRegion | Clear all items in the specified region. If the database can be packed, it will be packed. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Contains | Returns true if the cache item exists in the specified region (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | CreateCacheEntryChangeMonitor | The database cache provider does not support Creating Entry Change Monitors (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Delete | Deletes the specified cache item by key. Used internally by the AsyncProcessor (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Dispose | Dispose the cache provider. Do not allow anything else to be loaded or saved in the cache. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Flush | Wait until the passed seconds until the items are saved and removed from the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Get<T> | Get an item from the cache. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | GetCacheItem<T> | Gets the specified cache entry from the cache as a System.Runtime.Caching.CacheItem instance. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider) | 
![]()  | GetCount | Get the number of items in the passed region. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | GetKeys | Get the cache keys for the specified region. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | GetRegions | Get a list of regions in the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | GetTotalCount | Get the total number of items in the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Remove<T> | Remove an item from the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Save<T> | Insert or Add a cache item internally used by the AsyncProcessor (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Scavenge | Perform an immediate removal of expired items from the cache without waiting on the scavenge timer. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) | 
![]()  | Set | Overloaded. Insert or update an item in the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider) |