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();
}
