public BlobStreamReader(SqlConnection connection, string schemaName, CacheItemMetaData item)
{
_command = new SqlCommand($"SELECT TOP 1 i.Content FROM {schemaName}.[CacheItem] i WHERE i.[InternalId] = @internalId", connection);
_command.Parameters.AddWithValue("internalId", item.InternalId);
_reader = _command.ExecuteReader(CommandBehavior.SequentialAccess);
_reader.Read();
}
public BlobStreamWriter(
SqlConnection connection,
string schemaName,
CacheItemMetaData item)
{
_appendChunkCommand = new SqlCommand($@"UPDATE [{schemaName}].[CacheItem] SET [Content].WRITE(@chunk, @index, @len) WHERE [InternalId] = @internalId", connection);
_appendChunkCommand.Parameters.AddWithValue("@internalId", item.InternalId);
_lengthParameter = _appendChunkCommand.Parameters.Add("len", SqlDbType.Int);
_indexParameter = _appendChunkCommand.Parameters.Add("index", SqlDbType.Int);
_dataParameter = new SqlParameter("@chunk", SqlDbType.VarBinary, -1);
_appendChunkCommand.Parameters.Add(_dataParameter);
}
public CacheSummary(CacheKey key, CacheItemMetaData metaData)
{
this.key = key;
this.metaData = metaData;
}
