public IEnumerable<Post> Get() { var db = new BlogContext(); var posts = from p in db.Posts.Include(c => c.Category) select p; return posts; }
public IEnumerable<Post> Get([FromUri]int id) { var db = new BlogContext(); var posts = from p in db.Posts.Include(c => c.Category) where p.Category.Id == id select p; return posts; }
public void Post([FromBody]Post post) { var db = new BlogContext(); if (post.Category != null) { var category = (from c in db.Categories where c.Name == post.Category.Name select c).FirstOrDefault(); if (category != null) { post.Category = category; } } post.PostDate = DateTime.Now; db.Posts.Add(post); db.SaveChanges(); }
public void Post([FromBody]Category category) { var db = new BlogContext(); db.Categories.Add(category); db.SaveChanges(); }
public IEnumerable<Category> Get() { var db = new BlogContext(); return db.Categories.ToList(); }