Inserting/Selecting/Updating an Object in Redis Cache

Question

I'm very much new to Redis Cache. The following is my Json string which contains the data.

Code

[
{
    "ResourceKey": "Members",
    "Language": 1,
    "ClientId": 1,
    "ResourceValue": "Members"
},
{
    "ResourceKey": "Members",
    "Language": 2,
    "ClientId": 1,
    "ResourceValue": "会员"
}
]

What I am trying to achieve is that using ResourceKey, LanguageId, ClientId should form a kind of composite key in Redis to retrieve the ResourceValue field.

I have tried to store Json string as it is but it's very difficult to retrieve 1 particular data as I need to deserialize the whole string then get the single value.

Code

resKeyValue = JsonConvert.DeserializeObject<List<ResourceViewModel>>(readTask.Result);
resKeyValue = resKeyValue.Where(x => x.language == iLanguageId && x.clientid == iClientId).ToList();

Code

var db = _redis.GetDatabase();
var addedItems = new List<KeyValuePair<RedisKey, RedisValue>>();
if (!await db.KeyExistsAsync("resourceList"))
{
   addedItems.Add(new KeyValuePair<RedisKey, RedisValue>("resourceList", JsonConvert.SerializeObject(resItem)));
   await db.StringSetAsync(addedItems.ToArray());
   return Ok("Resources Added Successfully.");
}

I was looking into Hash but NOT able to visualize how to store composite key into Redis. Please help to suggest.

can you share the code which saves the value to redis?

Chetan
– Chetan

2021-09-10 05:53:27 +00:00
Commented Sep 10, 2021 at 5:53 — Chetan
– Chetan, Commented Sep 10, 2021 at 5:53
@Chetan I updated my code

DonMax
– DonMax

2021-09-10 06:00:55 +00:00
Commented Sep 10, 2021 at 6:00 — DonMax
– DonMax, Commented Sep 10, 2021 at 6:00

usuario · Accepted Answer · 2021-09-10 06:01:45Z

0

Since you are only interested in ResourceValue you can try to concatenate all fields to create a composite key.

For instance

set myCompositeKey:Members:1:1 Members
set myCompositeKey:Members:1:2 会员

get myCompositeKey:Members:1:1
"Members"

get myCompositeKey:Members:1:2
"会员"

Prefix myCompositeKey can be used to group all keys for that use case or schema. But it is really up to you.

Using this approach we do not use hash data type

Just in case, you can read more about redis keys here

answered Sep 10, 2021 at 6:01

usuario

2,5771 gold badge13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inserting/Selecting/Updating an Object in Redis Cache

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related