Engage.Survey.Entities.SurveyRepository.LoadReadOnlySurveys C# (CSharp) Method

        private IQueryable<ReadonlySurvey> LoadReadOnlySurveys()
        {
            return (from response in this.Context.Responses
                    join responseHeader in this.Context.ResponseHeaders on response.ResponseHeaderId equals responseHeader.ResponseHeaderId
                    select new ReadonlySurvey
                               {
                                       SurveyId = response.SurveyId,
                                       Text = response.SurveyText,
                                       ShowText = response.ShowSurveyText,
                                       TitleOption = response.TitleOption,
                                       QuestionFormatOption = response.QuestionFormatOption,
                                       SectionFormatOption = response.SectionFormatOption,
                                       ResponseHeaderId = responseHeader.ResponseHeaderId,
                                       CreationDate = responseHeader.CreationDate,
                                       UserId = responseHeader.UserId
                               }).Distinct();
        }