public void InsertPost(Post post)
{
using (var context = new SsnDbContext())
{
context.Posts.Add(post);
context.SaveChanges();
}
}
public void InsertComment(int postId, Comment comment)
{
using (var context = new SsnDbContext())
{
using (var transaction = context.Database.BeginTransaction())
{
var query = from p in context.Posts
where p.Id == postId
select p;
Post post = query.FirstOrDefault();
if (post != null)
{
post.Comments.Add(comment);
context.SaveChanges();
}
transaction.Commit();
}
}
}
public void UpdatePost(int postId, string content)
{
using (var context = new SsnDbContext())
{
using (var transaction = context.Database.BeginTransaction())
{
var query = from p in context.Posts
where p.Id == postId
select p;
Post foundPost = query.FirstOrDefault();
if (foundPost != null)
{
foundPost.Content = content;
context.SaveChanges();
transaction.Commit();
}
}
}
}