public void DeleteItem <T>(int objectId) where T : class, Core.Interfaces.IObjectIdEntity { MyDbContext db = new MyDbContext(); T instance = db.Set <T>().First(a => a.ObjectId == objectId); db.Set <T>().Remove(instance); db.SaveChanges(); }
public void DeleteItem <T>(T item) where T : class { MyDbContext db = new MyDbContext(); db.Set <T>().Remove(item); db.SaveChanges(); }
public void SaveItem <T>(T item) where T : class { MyDbContext db = new MyDbContext(); db.Set <T>().AddOrUpdate(item); db.SaveChanges(); }
public void SaveList <T>(List <T> itemList) where T : class { MyDbContext db = new MyDbContext(); foreach (var item in itemList) { db.Set <T>().AddOrUpdate(item); } db.SaveChanges(); }
public void SaveOption(string optionKey, string optionValue) { MyDbContext db = new MyDbContext(); Option option = db.Options.FirstOrDefault(o => o.OptionKey == optionKey) ?? new Option(); option.OptionKey = optionKey; option.OptionValue = optionValue; db.Set <Option>().AddOrUpdate(option); db.SaveChanges(); }
public bool DoesItemExist <T>(T item) where T : class, Core.Interfaces.IObjectIdEntity { MyDbContext db = new MyDbContext(); return(db.Set <T>().Any(i => i.ObjectId == item.ObjectId)); }
public bool DoesItemExist <T>(int objectId) where T : class, Core.Interfaces.IObjectIdEntity { MyDbContext db = new MyDbContext(); return(db.Set <T>().Any(a => a.ObjectId == objectId)); }
public T GetItem <T>(int objectId) where T : class, Core.Interfaces.IObjectIdEntity { MyDbContext db = new MyDbContext(); return(db.Set <T>().First(a => a.ObjectId == objectId)); }
public List <T> GetList <T>() where T : class { MyDbContext db = new MyDbContext(); return(db.Set <T>().ToList()); }