public async Task <QuestionDetailDto> QueryQuestionDetail(QuestionDetailQueryParam param)
{
return(await _dbAdapter.QueryFirstOrDefault <QuestionDetailDto>(@"SELECT qs.Id
, qs.Title
, qs.Slug
, us.UserName AS Author
, ct.TEXT AS Content
, qs.CreatedAtUtc
, qs.UpdatedAtUtc
, ct.Id AS ContentId
FROM Questions AS qs
JOIN Contents AS ct ON qs.ContentId = ct.Id
JOIN AspNetUsers AS us ON qs.CreatedBy = us.Id
WHERE qs.Slug = @Slug
AND us.UserName = @UserName", param));
}
public async Task <QuestionDetailDto> QueryQuestionDetail(QuestionDetailQueryParam param)
{
return(await _questionRepository.QueryQuestionDetail(param));
}
