code_junkie

How to create a join in an expression tree for LINQ

Nov 13th, 2011
149
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. IQueryable<Data.Task> query = ctx.DataContext.Tasks;
  2.  
  3. if (criteria.Number > 0)
  4. query = query.Where(row => row.Number == criteria.Number);
  5.  
  6. if (criteria.CustomerId != Guid.Empty)
  7. query = query.Where(row => row.Project.CustomerId == criteria.CustomerId);
  8.  
  9. if (criteria.ProjectId != Guid.Empty)
  10. query = query.Where(row => row.ProjectId == criteria.ProjectId);
  11.  
  12. var data = query.Select(row => TaskInfo.FetchTaskInfo(row));
  13.  
  14. this.AddRange(data);
  15.  
  16. from t in Tasks
  17. join l in Labels on t.TaskId equals l.SourceId
  18. where l.Name == "accounting"
  19. select t
  20.  
  21. Tasks.Join(Labels.Where(l => l.Name == "accounting"), t => t.TaskId, l => l.SourceId, (t, l) => t)
  22.  
  23. from t in Tasks
  24. join l in Labels on t.TaskId equals l.SourceId
  25. where l.Name == "accounting"
  26. select t
  27.  
  28. Tasks.Join(Labels, t => t.TaskId, l => l.SourceId, (t, l) => new { t, l })
  29. .Where(z => z.l.Name == "accounting")
  30. .Select(z => z.t)
  31.  
  32. from t in Tasks
  33. join l in (from x in Labels where x.Name == "accounting")
  34. on t.TaskId equals l.SourceId
  35. select t
Add Comment
Please, Sign In to add comment