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; }