private static void CascadingInsert() { var db = new BlogDbContex(); var post = new Post { Title = "New Post Title Боби", Date = DateTime.Now, Body = "This post have comments and tags", User = db.Users.First(), Comments = new[] { new Comment { Text = "Comment 1", Date = DateTime.Now }, new Comment { Text = "Comment 2", Date = DateTime.Now, User = db.Users.First() } }, Tags = db.Tags.Take(3).ToList() }; db.Posts.Add(post); db.SaveChanges(); }
private static void DeleteExsistingData() { var db = new BlogDbContex(); var lastPost = db.Posts.OrderByDescending(p => p.Id).First(); db.Comments.RemoveRange(lastPost.Comments); lastPost.Tags.Clear(); db.Posts.Remove(lastPost); db.SaveChanges(); Console.WriteLine($"Deleted post #{lastPost.Id}"); }
private static void CreateNewData() { var db = new BlogDbContex(); var post = new Post { Title = "New Title", Body = "New Post Body", Date = DateTime.Now }; db.Posts.Add(post); db.SaveChanges(); Console.WriteLine("Post #{0} created.", post.Id); }
private static void UpdateExistingData() { var db = new BlogDbContex(); var user = db.Users.Where(u => u.UserName == "maria").First(); user.PasswordHash = Guid.NewGuid().ToByteArray(); db.SaveChanges(); Console.WriteLine("User #{0} ({1}) has a new random password.", user.Id, user.UserName); }