static Author GetAuthorById(int id) { using (var db = new ArticleContext()) { return(db.Authors .Include("Articles") .SingleOrDefault(a => a.Id == id)); } }
static void UpdateArticle(Article article) { using (var db = new ArticleContext()) { db.Articles.Attach(article); db.Entry(article).State = EntityState.Modified; db.SaveChanges(); } }
static void CreateArticle(Article article) { using (var db = new ArticleContext()) { db.Articles.Add(article); db.SaveChanges(); } }
static Author GetAuthorById(int id) { using (var db = new ArticleContext()) { return db.Authors .Include("Articles") .SingleOrDefault(a => a.Id == id); } }
static void DeleteArticle(Article article) { using (var db = new ArticleContext()) { db.Articles.Attach(article); db.Articles.Remove(article); //db.Entry(article).State = EntityState.Deleted; db.SaveChanges(); } }