public void LoadPosts()
{
var blogApplication = CompositeRoot as BlogApplicationCompositeRoot;
var repository = blogApplication.GetService <IMicrosoftSqlServerRepository>();
using (var connection = repository.OpenConnection(blogApplication.BlogDbConnectionString))
{
posts.AddRange(repository.Load <Post>(connection, null,
@"
SELECT *
FROM Post
WHERE BlogId = @BlogId
",
new SqlParameter[] { new SqlParameter("@BlogId", Blog.Id) })
.Select(p => new PostComposite(p, this)));
}
}
public void LoadBlog(CompositeRootHttpContext context, int id)
{
var blogApplication = CompositeRoot as BlogApplicationCompositeRoot;
var repository = blogApplication.GetService <IMicrosoftSqlServerRepository>();
using (var connection = repository.OpenConnection(blogApplication.BlogDbConnectionString))
{
blogs.AddRange(repository.Load <Blog>(connection, null,
@"SELECT *
FROM Blog
WHERE ID = @ID",
new SqlParameter[] { new SqlParameter("@ID", id) })
.Select(b => new BlogComposite(b, this)));
}
}