NET Caching Library Help
SqlServerCacheProvider Class Members
Fields  Properties  Methods 


KellermanSoftware.NetCachingLibrary.CacheProviders Namespace : SqlServerCacheProvider Class

The following tables list the members exposed by SqlServerCacheProvider.

Public Constructors
 NameDescription
Public Constructor Constructor which takes a connection string  
Top
Protected Fields
 NameDescription
Protected Field The bytes for cache item information (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Top
Public Properties
 NameDescription
Public Property The name of the cache table. The default is SmartCache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Property Get a list of the cache capabilities (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Property Gets or sets the maximum minutes for a cache item to expire. It must be greater than zero. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Public Property The Encryption Key (password) to use when encrypting data (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Public Property If true, cache items will be saved and removed asynchronously (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Property Gets a value indicating whether this instance is busy scavenging. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Property If true, the data is compressed before it is saved and decompressed upon load. The default is false. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Public Property Gets or sets a value indicating whether this instance is disposed. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Property If true, the data is encrypted before it is saved and decrypted upon load. The default is false. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Public Property The maximum number of cache items to store in the cache. The default is Int32.MaxValue. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Property The maximum number of megabytes for the cache. The default is 50 Megabytes. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public PropertyOverridden.  Gets the name of a specific cache instance.  
Public Property How often to check to remove expired items. The default is 60000 milliseconds (1 minute). (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Property Determines what priority to scavenge items from the cache. The default is Oldest. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Public Property The name of the thread that is used when scavenging (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Top
Protected Properties
 NameDescription
Protected Property The connection string for the database provider (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Protected PropertyOverridden.  Provider of basic CRUD operations  
Protected PropertyOverridden.  The SQL to create the caching table  
Top
Public Methods
 NameDescription
Public MethodOverloaded.  Inserts a cache entry into the cache without overwriting any existing cache entry. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Public MethodOverloaded.  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)
Public Method Clear all items in the cache. If the database can be packed, it will be packed. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Clear all items in the specified region. If the database can be packed, it will be packed. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Returns true if the cache item exists in the specified region (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method The database cache provider does not support Creating Entry Change Monitors (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Deletes the specified cache item by key. Used internally by the AsyncProcessor (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Dispose the cache provider. Do not allow anything else to be loaded or saved in the cache. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Wait until the passed seconds until the items are saved and removed from the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Get an item from the cache. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public MethodGets the specified cache entry from the cache as a System.Runtime.Caching.CacheItem instance. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Public Method Get the number of items in the passed region. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Get the cache keys for the specified region. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Get a list of regions in the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Get the total number of items in the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Remove an item from the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Insert or Add a cache item internally used by the AsyncProcessor (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public Method Perform an immediate removal of expired items from the cache without waiting on the scavenge timer. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Public MethodOverloaded.  Insert or update an item in the cache (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Top
Protected Methods
 NameDescription
Protected Method Calculate the cache size (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Protected MethodOverridden.  The SQL Server database needs to exist for the cache to be used  
Protected Method Deserialize an object. Also decrypt and de-compress if turned on. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Protected Method Get the size of a cache item (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Protected Method Get the Default region if null is passed in (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Protected Method Create the database if needed. Create the cache table if it does not exist. Calculate the cache size. Start the scavenging timer. (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Protected MethodOverridden.  No pack is possible for SQL Server  
Protected Method Pause any asynchronous operations (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Protected Method Resume asynchronous operation (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseDatabaseCacheProvider)
Protected Method Serialize an object. Also compress and encrypt if it is turned on (Inherited from KellermanSoftware.NetCachingLibrary.CacheProviders.BaseCacheProvider)
Top
See Also

Reference

SqlServerCacheProvider Class
KellermanSoftware.NetCachingLibrary.CacheProviders Namespace
BaseDatabaseCacheProvider Class