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