public override void AddToCache <T>(string key, T value, DateTime expiration)
{
using (var eFactory = new jcDCEFModel()) {
var isNew = true;
var cacheItem = eFactory.Caches.FirstOrDefault(a => a.Key == key);
if (cacheItem == null)
{
cacheItem = eFactory.Caches.Create();
cacheItem.Key = key;
}
else
{
isNew = false;
}
cacheItem.Expiration = expiration;
cacheItem.KeyValue = JsonConvert.SerializeObject(value);
if (isNew)
{
eFactory.Caches.Add(cacheItem);
}
eFactory.SaveChanges();
}
}
public override void RemoveDependencies(string[] dependencies)
{
using (var eFactory = new jcDCEFModel()) {
foreach (var item in dependencies)
{
eFactory.Database.ExecuteSqlCommand($"DELETE FROM dbo.Cache WHERE [Key] = '{item}'");
}
}
}
public override jcCACHEItem GetFromCache(string key)
{
using (var eFactory = new jcDCEFModel()) {
var cacheItem = eFactory.Caches.FirstOrDefault(a => a.Key == key);
if (cacheItem == null)
{
return(null);
}
var item = JsonConvert.DeserializeObject <jcCACHEItem>(cacheItem.KeyValue);
item.Expiration = cacheItem.Expiration;
return(item);
}
}
public override void RemoveFromCache(string key)
{
using (var eFactory = new jcDCEFModel()) {
eFactory.Database.ExecuteSqlCommand($"DELETE FROM dbo.Cache WHERE [Key] = '{key}'");
}
}
