public void Seed(EFTokenCacheDataContext Context)
{
#if DEBUG
// Create default objects here
//Context.CacheItems.Add(new CacheItem { });
#endif
// Normal seeding goes here
Context.SaveChanges();
}
public void Remove(string key)
{
using (var db = new EFTokenCacheDataContext())
{
var items = db.Set <TokenCacheItem>();
var item = items.Find(key);
if (item == null)
{
return;
}
items.Remove(item);
db.SaveChanges();
}
}
private static void RemoveAllBefore(DateTime date)
{
using (var db = new EFTokenCacheDataContext())
{
var items = db.Set <TokenCacheItem>();
var query =
from item in items
where item.Expires <= date
select item;
foreach (var item in query)
{
items.Remove(item);
}
db.SaveChanges();
}
}
public void AddOrUpdate(TokenCacheItem item)
{
using (var db = new EFTokenCacheDataContext())
{
var items = db.Set <TokenCacheItem>();
var dbItem = items.Find(item.Key);
if (dbItem == null)
{
dbItem = new TokenCacheItem {
Key = item.Key
};
items.Add(dbItem);
}
dbItem.Token = item.Token;
dbItem.Expires = item.Expires;
db.SaveChanges();
}
}