MsSqlServerStorage
Definition
Namespace:Telerik.Reporting.Cache
Assembly:Telerik.Reporting.dll
Syntax:
public class MsSqlServerStorage : IStorage2, IStorageInheritance: objectMsSqlServerStorage
Implements:
Constructors
Initializes a new instance of the MsSqlServerStorage class.
public MsSqlServerStorage(string connectionString, int commandTimeout)The connection string to the backend storage. Connection Strings in ADO.NET
commandTimeoutintDetermines the CommandTimeout that will be used when executing database commands, in seconds. The default value is 30. SqlCommand.CommandTimeout
Initializes a new instance of the MsSqlServerStorage class.
public MsSqlServerStorage(string connectionString)The connection string to the backend storage. Connection Strings in ADO.NET
Methods
AcquireLock(string)
IDisposable
Acquires a lock on a named resource.
public IDisposable AcquireLock(string key)IDisposable
Implements:
AcquireReadLock(string)
IDisposable
Acquires a lock on a named resource for reading. Uses Transaction with lower isolation level.
public IDisposable AcquireReadLock(string key)IDisposable
Implements:
Adds a single string value to a set of values denoted from the given key.
public void AddInSet(string key, string value)Implements:
Utility method. Clears all data from the storage data tables.
public void ClearAllData()public void CreateObjects(string ddl)Utility method. Creates the data schema (tables and stored procedures) needed from the storage.
public void CreateSchema(bool createTables = true, bool createProcedures = true)Deletes a key with its value (string or byte array) from the storage.
public void Delete(string key)Implements:
Deletes a single string value from a set of values denoted from the given key.
public bool DeleteInSet(string key, string value)bool
Implements:
Deletes all keys starting with the key parameter along with their values (string or byte array) from the storage.
public void DeleteMasterKey(string key)The key that denotes the stored values that should be removed.
Implements:
Deletes a set of values denoted by the given key.
public void DeleteSet(string key)Implements:
public void EnsureDatabaseExists(bool createSchema)Exists(string)
bool
Retrieves a value indicating if a single value (string or byte array) exists in the storage.
public bool Exists(string key)bool
Implements:
Retrieves a value indicating if a set of values exists in the storage.
public bool ExistsInSet(string key, string value)bool
Implements:
GetAllMembersInSet(string)
IEnumerable<string>
Retrieves all members in a set of string values.
public IEnumerable<string> GetAllMembersInSet(string key)IEnumerable<string>
Implements:
GetBytes(string)
byte[]
Retrieves a byte array value stored under particular key.
public byte[] GetBytes(string key)byte[]
Implements:
Retrieves the count of the values in a set value stored in the storage.
public long GetCountInSet(string key)long
Implements:
GetInstancesByKey(string, byte[])
IEnumerable<string>
Gets all the instances having the specified value for their Key property.
public IEnumerable<string> GetInstancesByKey(string keyPropertyId, byte[] keyValue)The value for the Instance Id field, containing a wildcard or '%' (Like) operator.
keyValuebyte[]The value for the Key property.
Returns:IEnumerable<string>
Collection with the complete Id keys.
GetString(string)
string
Retrieves a string value stored under particular key.
public string GetString(string key)string
Implements:
Stores a byte array value under particular key.
public void SetBytes(string key, byte[] value)Implements:
Stores a string value under particular key.
public void SetString(string key, string value)Implements: