private static void SetupDatabase()
{
using (var db = new BloggingContext())
{
if (db.Database.EnsureCreated())
{
db.Blogs.Add(
new Blog
{
Name = "Fish Blog",
Url = "http://sample.com/blogs/fish",
Posts = new List <Post>
{
new Post {
Title = "Fish care 101"
},
new Post {
Title = "Caring for tropical fish"
},
new Post {
Title = "Types of ornamental fish"
}
}
});
db.Blogs.Add(
new Blog
{
Name = "Cats Blog",
Url = "http://sample.com/blogs/cats",
Posts = new List <Post>
{
new Post {
Title = "Cat care 101"
},
new Post {
Title = "Caring for tropical cats"
},
new Post {
Title = "Types of ornamental cats"
}
}
});
db.Blogs.Add(
new Blog
{
Name = "Catfish Blog",
Url = "http://sample.com/blogs/catfish",
Posts = new List <Post>
{
new Post {
Title = "Catfish care 101"
},
new Post {
Title = "History of the catfish name"
}
}
});
db.SaveChanges();
#region View
db.Database.ExecuteSqlRaw(
@"CREATE VIEW View_BlogPostCounts AS
SELECT b.Name, Count(p.PostId) as PostCount
FROM Blogs b
JOIN Posts p on p.BlogId = b.BlogId
GROUP BY b.Name");
#endregion
}
}
}
