score:0

db.ideas
 .groupjoin(
  db.ideacollaborators,
  i => i.id,
  ic => ic.idea_id,
  (x, y) => new { ideas = x, ideacollaborators = y })
 .where(gj => gj.ideas.submitter_id == "peter" | gj.ideacollaborators.firstordefault().user_id == "peter")
 .selectmany(
  x => x.ideacollaborators.defaultifempty(),
  (x, y) => new
  { x.ideas.id, x.ideas.ideastatus_id, y.user_id })
);

Related Query

More Query from same tag