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.ExecuteSqlCommand(
@"CREATE VIEW View_BlogPostCounts AS
SELECT Name, Count(p.PostId) as PostCount from Blogs b
JOIN Posts p on p.BlogId = b.BlogId
GROUP BY b.Name");
#endregion
}
}
}
private static void SetupDatabase()
{
using (var db = new BloggingContext("diego"))
{
if (db.Database.EnsureCreated())
{
db.Blogs.Add(
new 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
{
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.SaveChanges();
using (var andrewDb = new BloggingContext("andrew"))
{
andrewDb.Blogs.Add(
new 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"
}
}
});
andrewDb.SaveChanges();
}
db.Posts
.Where(
p => p.Title == "Caring for tropical fish" ||
p.Title == "Cat care 101")
.ToList()
.ForEach(p => db.Posts.Remove(p));
db.SaveChanges();
}
}
}
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.ExecuteSqlCommand(
@"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");
//db.Database.ExecuteSqlCommand(
// @"CREATE procedure BlogPostsCountTest AS
// SELECT b.Name, Count(p.PostId) as PostCount
// FROM Blogs b
// JOIN Posts p on p.BlogId = b.BlogId
// GROUP BY b.Name");
//db.Database.ExecuteSqlCommand(
// @"CREATE procedure BlogPostsCountTest3 AS
// SELECT b.Name as BlogName
// FROM Blogs b
// ");
//db.Database.ExecuteSqlCommand(
// @"CREATE procedure BlogPostsCountTest2 AS
// SELECT b.Name, Count(p.PostId) as PostCount
// FROM Blogs b
// JOIN Posts p on p.BlogId = b.BlogId
// GROUP BY b.Name");
//db.Database.ExecuteSqlCommand(
// @"CREATE procedure BlogPostsCountTest5 AS
// SELECT b.Name as BlogName, b.Url
// FROM Blogs b
// ");
db.Database.ExecuteSqlCommand(
@"CREATE procedure BlogPostsCountTest6
@FirstName varchar(50)
AS
SELECT b.Name, Count(p.PostId) as PostCount,@FirstName as FirstName
FROM Blogs b
JOIN Posts p on p.BlogId = b.BlogId
GROUP BY b.Name");
#endregion
Console.WriteLine("test");
}
}
}