private static void CreateBlog() { using (var context = new BlogContext()) { context.Blogs.Add(new Blog { BloggerName = "Mannod", Title = "Code First Awesome" , DateCreated = DateTime.Now }); context.SaveChanges(); } }
private static void AddFirstPost() { using (var context = new BlogContext()) { var blog = context.Blogs.Find(1); blog.Posts.Add(new Post { Title = "First Post", Content = "Hello, this is the first start." }); context.SaveChanges(); } }
private static void AddSecondPost() { using (var context = new BlogContext()) { var blog = context.Blogs.Find(1); blog.Posts.Add(new Post { Title = "Second Post", Content = "Nice to see you again." }); context.SaveChanges(); } }
static void CreateBlog () { using (var context = new BlogContext()) { var blog = new Blog() { BloggerName = "Benjamin", Title = "Accenture is awesome" }; context.Blogs.Add(blog); context.SaveChanges(); } }
static void AddPost () { using (var context = new BlogContext()) { var blog = context.Blogs.Find(1); var post = new Post { Content = "I worked in Accenture Cybergate Tower 3!", Title = "My First Post" }; blog.Posts.Add(post); context.SaveChanges(); } }
static void CreateBlogWithStoredProcedure () { var db = new BlogContext(); // add db.Blogs.Add(new Blog { Title = "First blog", BloggerName = "Benjamin" }); db.Blogs.Add(new Blog { Title = "Second blog", BloggerName = "Rache" }); db.SaveChanges(); // update var blogToUpdate = db.Blogs.FirstOrDefault(e => e.BloggerName == "Benjamin"); blogToUpdate.BloggerName = "Benj"; db.Entry(blogToUpdate).State = EntityState.Modified; db.SaveChanges(); // delete var blogToDelete = db.Blogs.FirstOrDefault(e => e.BloggerName == "Rache"); db.Blogs.Remove(blogToDelete); db.SaveChanges(); // select var blogs = db.Blogs.ToList(); foreach (var b in blogs) { Console.WriteLine("{0} blogged by {1} at {2}", b.Title, b.BloggerName, DateTime.Now.ToString()); } db.Dispose(); Console.WriteLine("Press any key to continue..."); Console.ReadLine(); }