public Article Get(int id) { using (var ctx = new TOFELDBContext()) { return(ctx.Articles.Find(id)); } }
public Article Add(Article article) { using (var ctx = new TOFELDBContext()) { var result = ctx.Articles.Add(article); ctx.SaveChanges(); return(result); } }
public IEnumerable <Article> AddRange(IEnumerable <Article> articles) { using (var ctx = new TOFELDBContext()) { var result = ctx.Articles.AddRange(articles); ctx.SaveChanges(); return(result); } }
public bool Delete(int id) { using (var ctx = new TOFELDBContext()) { try { var deleteCandidate = ctx.Articles.Find(id); if (deleteCandidate != null) { ctx.Articles.Remove(deleteCandidate); } ctx.SaveChanges(); return(true); } catch (Exception exc) { return(false); } } }
public Article Update(Article item) { using (var ctx = new TOFELDBContext()) { var updateCandidate = ctx.Articles.Find(item.ArticleId); if (updateCandidate != null) { try { ctx.Articles.Attach(item); ctx.Entry(item).State = EntityState.Modified; ctx.SaveChanges(); } catch (Exception ex) { throw; } } return(updateCandidate); } }