Guest User

Untitled

a guest
Nov 21st, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. The nested query is not supported. Operation1='Case' Operation2='Collect'
  2.  
  3. IQueryable<Map.League> v = from ul in userLeagues
  4. select new Map.League
  5. {
  6. id = ul.LeagueID,
  7. seasons =
  8. inc.Seasons ? (from ss in ul.Standings
  9. where ss.LeagueID == ul.LeagueID
  10. select new Map.Season
  11. {
  12. seasonId = ss.Season.SeasonId,
  13. seasonName = ss.Season.SeasonName
  14. }).ToList() : null,
  15. };
  16.  
  17. seasons = (from ss in ul.Standings
  18. where ss.LeagueID == ul.LeagueID
  19. select new Map.Season
  20. {
  21. seasonId = ss.Season.SeasonId,
  22. seasonName = ss.Season.SeasonName
  23. }).Distinct(),
  24.  
  25. from ul in userLeagues
  26. select new Map.League
  27. {
  28. id = ul.LeagueID,
  29. seasons = from ss in ul.Standings
  30. where inc.Seasons // here
  31. && ss.LeagueID == ul.LeagueID
  32. select new Map.Season
  33. {
  34. seasonId = ss.Season.SeasonId,
  35. seasonName = ss.Season.SeasonName
  36. })
  37. }
Add Comment
Please, Sign In to add comment