Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var completedSurveys = (from s in db.SurveyResponses
- join d in db.Demographics on s.SurveyID equals d.SurveyID into grpjoin
- from d in grpjoin.DefaultIfEmpty()
- select new
- {
- Survey_ID = s.SurveyID,
- Survey_Date = s.Survey.SurveyDate,
- Question = s.Questions.QuestionTxt,
- Response = s.Responses.ResponseTxt,
- Zip_Code = d.ZipCode,
- Department = d.CityDepartments.Department,
- Ace_Score = s.Survey.AceScore,
- }).ToList();
- var completedSurveys = (from s in db.SurveyResponses
- join d in db.Demographics on s.SurveyID equals d.SurveyID into grpjoin
- from d in grpjoin.DefaultIfEmpty()
- group new {s.Questions.QuestionTxt, s.Survey.SurveyDate } by new { s.SurveyID, s.Responses.ResponseTxt, d.ZipCode, d.CityDepartments.Department, s.Survey.AceScore } into g
- orderby g.Key.SurveyID ascending
- select new
- {
- Survey_ID = g.Key.SurveyID,
- Survey_Date = g.Select(s => s.SurveyDate),
- Response = g.Key.ResponseTxt,
- Zip = g.Key.ZipCode,
- Department = g.Key.Department,
- Ace_Score = g.Key.AceScore
- }).ToList();
Add Comment
Please, Sign In to add comment