private static void DeleteCommentById()
{
BlogDbContext blogDbContext = new BlogDbContext();
Comment commentInfo = blogDbContext.Comments.Single(comment => comment.Id == 1);
blogDbContext.Comments.Remove(commentInfo);
blogDbContext.SaveChanges();
Console.WriteLine(@"Comment #{0} deleted", commentInfo.Id);
}
private static void DeleteCommentById()
{
BlogDbContext blogDbContext = new BlogDbContext();
Comment commentInfo = blogDbContext.Comments.Single(comment => comment.Id == 1);
blogDbContext.Comments.Remove(commentInfo);
blogDbContext.SaveChanges();
Console.WriteLine(@"Comment #{0} deleted", commentInfo.Id);
}
private static void DeletePostById()
{
BlogDbContext blogDbContext = new BlogDbContext();
Post postInfo = blogDbContext.Posts.Single(post => post.Id == 33);
blogDbContext.Comments.RemoveRange(postInfo.Comments);
postInfo.Tags.Clear();
blogDbContext.Posts.Remove(postInfo);
blogDbContext.SaveChanges();
Console.WriteLine("Post #{0} deleted successfully", postInfo.Id);
}
private static void UpdateData()
{
BlogDbContext blogDbContext = new BlogDbContext();
User userInfo = blogDbContext.Users.Single(user => user.UserName == "GBotev");
string oldName = userInfo.FullName;
userInfo.FullName = "Georgi Botev";
blogDbContext.SaveChanges();
Console.WriteLine(@"User '{0}' has been renamed to '{1}'", oldName, userInfo.FullName);
}
private static void DeletePostById()
{
BlogDbContext blogDbContext = new BlogDbContext();
Post postInfo = blogDbContext.Posts.Single(post => post.Id == 33);
blogDbContext.Comments.RemoveRange(postInfo.Comments);
postInfo.Tags.Clear();
blogDbContext.Posts.Remove(postInfo);
blogDbContext.SaveChanges();
Console.WriteLine("Post #{0} deleted successfully", postInfo.Id);
}
private static void CreateData()
{
BlogDbContext blogDbContext = new BlogDbContext();
Post post = new Post()
{
AuthorId = 2,
Title = "Random title",
Body = "Random content",
Date = DateTime.Now
};
blogDbContext.Posts.Add(post);
blogDbContext.SaveChanges();
Console.WriteLine("Post #{0} Created!", post.Id);
}
private static void CreateData()
{
BlogDbContext blogDbContext = new BlogDbContext();
Post post = new Post()
{
AuthorId = 2,
Title = "Random title",
Body = "Random content",
Date = DateTime.Now
};
blogDbContext.Posts.Add(post);
blogDbContext.SaveChanges();
Console.WriteLine("Post #{0} Created!", post.Id);
}
private static void UpdateData()
{
BlogDbContext blogDbContext = new BlogDbContext();
User userInfo = blogDbContext.Users.Single(user => user.UserName == "GBotev");
string oldName = userInfo.FullName;
userInfo.FullName = "Georgi Botev";
blogDbContext.SaveChanges();
Console.WriteLine(@"User '{0}' has been renamed to '{1}'", oldName, userInfo.FullName);
}
