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