private static void CascadingInsert() { BlogDBContext db = new BlogDBContext(); Post post = new Post() { Title = "New Post Title", Date = DateTime.Now, Body = "This post has comments and tags", User = db.Users.First(), Comments = new Comment[] { 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 TestDbContext() { BlogDBContext db = new BlogDBContext(); foreach (User user in db.Users) { Console.WriteLine(user.Username); } }
private static void UpdateExistingData() { BlogDBContext db = new BlogDBContext(); User 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); }
private static void DeleteExistingData() { BlogDBContext db = new BlogDBContext(); Post 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() { BlogDBContext db = new BlogDBContext(); Post 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 QueryData() { BlogDBContext db = new BlogDBContext(); var postsQuery = db.Posts.Select(p => new { p.ID, p.Title, Comments = p.Comments.Count(), Tags = p.Tags.Count() }); Console.WriteLine("SQL query:\n{0}\n", postsQuery); foreach (var p in postsQuery) { Console.WriteLine($"{p.ID} {p.Title} ({p.Comments} comments, {p.Tags} tags)"); } }
private static void ExecuteNativeSQL() { BlogDBContext db = new BlogDBContext(); DateTime startDate = new DateTime(2016, 05, 19); DateTime endDate = new DateTime(2016, 06, 14); var posts = db.Database.SqlQuery <PostData>( @"SELECT ID, Title, Date FROM Posts WHERE CONVERT(date, Date) BETWEEN {0} AND {1} ORDER BY Date", startDate, endDate); foreach (PostData p in posts) { Console.WriteLine($"#{p.ID}: {p.Title} ({p.Date})"); } }