private static void DeleteCommentData(BlogDBContext db, int index)
{
var commentInfo = db.Comments.Single(c => c.Id == index);
db.Comments.Remove(commentInfo);
db.SaveChanges();
Console.WriteLine($@"Comment #{commentInfo.Id} deleted");
}
private static void UpdateData(BlogDBContext db)
{
var userInfo = db.Users.Single(u => u.UserName == "GBotev");
var oldName = userInfo.FullName;
userInfo.FullName = "Georgi Botev";
db.SaveChanges();
Console.WriteLine($@"User {oldName} has been renamed to '{userInfo.FullName}'");
}
private static void DeletePostData(BlogDBContext db, int index)
{
var postInfo = db.Posts.Single(p => p.Id == index);
db.Comments.RemoveRange(postInfo.Comments);
postInfo.Tags.Clear();
db.Posts.Remove(postInfo);
db.SaveChanges();
Console.WriteLine($@"Post #{postInfo.Id} deleted");
}
private static void CreatePost(BlogDBContext db)
{
var post = new Post()
{
AuthorId = 2, Title = "Random Title", Body = "Random Content", Date = DateTime.Now
};
db.Posts.Add(post);
db.SaveChanges();
Console.WriteLine($"Post #{post.Id} Created!");
}
