Guest User

Untitled

a guest
Nov 14th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.80 KB | None | 0 0
  1. var completedSurveys = (from s in db.SurveyResponses
  2. join d in db.Demographics on s.SurveyID equals d.SurveyID into grpjoin
  3. from d in grpjoin.DefaultIfEmpty()
  4. select new
  5. {
  6. Survey_ID = s.SurveyID,
  7. Survey_Date = s.Survey.SurveyDate,
  8. Question = s.Questions.QuestionTxt,
  9. Response = s.Responses.ResponseTxt,
  10. Zip_Code = d.ZipCode,
  11. Department = d.CityDepartments.Department,
  12. Ace_Score = s.Survey.AceScore,
  13.  
  14. }).ToList();
  15.  
  16. var completedSurveys = (from s in db.SurveyResponses
  17. join d in db.Demographics on s.SurveyID equals d.SurveyID into grpjoin
  18. from d in grpjoin.DefaultIfEmpty()
  19. 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
  20. orderby g.Key.SurveyID ascending
  21. select new
  22. {
  23. Survey_ID = g.Key.SurveyID,
  24. Survey_Date = g.Select(s => s.SurveyDate),
  25. Response = g.Key.ResponseTxt,
  26. Zip = g.Key.ZipCode,
  27. Department = g.Key.Department,
  28. Ace_Score = g.Key.AceScore
  29.  
  30. }).ToList();
Add Comment
Please, Sign In to add comment