About caching the data

Satish

first i need to check whether key is present in database table or not,

If it is not thr means i need to insert one key in table and after that i need to retrive data.

I need to compare datime which is present in table and present time ,if it is lessthan means i need to retrive from table else i need to reinsert data to table and retrive from it

Plz send sample code

Thanks.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Catcher Wong9y ago
Hello nageshwar ,

I don't know the type of your application ,a web app or a client app ,so I use the Redis to show you the code.
//connection
var conn = ConnectionMultiplexer.Connect("127.0.0.1");
//database
var db = conn.GetDatabase(0);

var key = "your key";
var value = string.Empty;
var result = string.Empty;

if (db.KeyExists(key) && !string.IsNullOrWhiteSpace(db.StringGet(key)))
{
    //get things from cache
    result = db.StringGet(key);
}
else
{
    //set things to the cache
    value = "your value";
    db.StringSet(key, value,TimeSpan.FromMinutes(5));
    result = value;
}
return result;
Hope this code can help you!!
Ramesh Palanivel9y ago
Hi Nageswar, Ur question is not that much clear.. Have u asked two questions here or entirely it's a single question