public IEnumerable <T> List(Func <T, bool> expression) { using (var db = new EntityFrameworkCoreContext()) { return(db.Set <T>().Where(expression)); } }
public IEnumerable <T> List() { using (var db = new EntityFrameworkCoreContext()) { return(db.Set <T>().ToList()); } }
public T Find(object id) { using (var db = new EntityFrameworkCoreContext()) { return(db.Set <T>().Find(id)); } }
public void Add(T item) { using (var db = new EntityFrameworkCoreContext()) { db.Set <T>().Add(item); db.SaveChanges(); } }
public void Truncate() { using (var db = new EntityFrameworkCoreContext()) { var list = db.Set <T>().Select(x => x).ToList(); foreach (var item in list) { db.Remove(item); } db.SaveChanges(); } }
public IEnumerable <T> ListIncludeMembers(params string[] expressions) { IQueryable <T> data = null; using (var db = new EntityFrameworkCoreContext()) { foreach (var expression in expressions) { if (data == null) { data = db.Set <T>().Include(expression); } else { data = data.Include(expression); } } return(data.ToList()); } }