public void DeleteBlogPost(int id)
{
using (BlogPostContext context = new BlogPostContext(_connectionName, _schemaName))
{
Data.Model.BlogPost post = context.BlogPosts.Find(id);
context.Entry(post).State = System.Data.EntityState.Deleted;
context.SaveChanges();
}
}
public void UpdateBlogPost(Domain.Model.BlogPost post)
{
using (BlogPostContext context = new BlogPostContext(_connectionName, _schemaName))
{
context.Entry(new Data.Model.BlogPost {
Id = post.Id, Post = post.Post, Title = post.Title
}).State = System.Data.EntityState.Modified;
context.SaveChanges();
}
}
public IEnumerable<Domain.Model.BlogPost> GetAllBlogPosts()
{
using (BlogPostContext context = new BlogPostContext(_connectionName, _schemaName))
{
IList<Data.Model.BlogPost> blogposts = context.BlogPosts.ToList<Data.Model.BlogPost>();
var posts = from post in blogposts
select post.ToDomainBlogPost();
return posts.ToList<Domain.Model.BlogPost>();
}
}
public Domain.Model.BlogPost ReadBlogPost(int id)
{
using (BlogPostContext context = new BlogPostContext(_connectionName, _schemaName))
{
var post = context.BlogPosts.Find(id);
if (post != null)
{
return post.ToDomainBlogPost();
}
return null;
}
}
