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