public BlogDto GetById(int id)
{
BlogDto blog = null;
using (var command = _blogAppContext.CreateCommand())
{
command.CommandText = @"SELECT BlogId, Url
FROM Blogs
WHERE BlogId = @BlogId" ;
var param = command.CreateParameter();
param.ParameterName = "BlogId";
param.Value = id;
command.Parameters.Add(param);
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
blog = _mapper.Map <IDataReader, BlogDto>(reader);
//blog = CreateBlogFromReader(reader);
}
}
}
return(blog);
}
public PostDto GetById(int id)
{
PostDto post = null;
using (var command = _blogAppContext.CreateCommand())
{
command.CommandText = @"SELECT PostId, BlogId, Content, Title
FROM Posts
WHERE PostId = @PostId" ;
var param = command.CreateParameter();
param.ParameterName = "PostId";
param.Value = id;
command.Parameters.Add(param);
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
//post = CreatePostFromReader(reader);
post = _mapper.Map <IDataReader, PostDto>(reader);
}
}
}
return(post);
}
