Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IQueryable<Data.Task> query = ctx.DataContext.Tasks;
- if (criteria.Number > 0)
- query = query.Where(row => row.Number == criteria.Number);
- if (criteria.CustomerId != Guid.Empty)
- query = query.Where(row => row.Project.CustomerId == criteria.CustomerId);
- if (criteria.ProjectId != Guid.Empty)
- query = query.Where(row => row.ProjectId == criteria.ProjectId);
- var data = query.Select(row => TaskInfo.FetchTaskInfo(row));
- this.AddRange(data);
- from t in Tasks
- join l in Labels on t.TaskId equals l.SourceId
- where l.Name == "accounting"
- select t
- Tasks.Join(Labels.Where(l => l.Name == "accounting"), t => t.TaskId, l => l.SourceId, (t, l) => t)
- from t in Tasks
- join l in Labels on t.TaskId equals l.SourceId
- where l.Name == "accounting"
- select t
- Tasks.Join(Labels, t => t.TaskId, l => l.SourceId, (t, l) => new { t, l })
- .Where(z => z.l.Name == "accounting")
- .Select(z => z.t)
- from t in Tasks
- join l in (from x in Labels where x.Name == "accounting")
- on t.TaskId equals l.SourceId
- select t
Add Comment
Please, Sign In to add comment