Linq where in clause

Question

I have hierarchy wherein a Department contains Teams and Teams contain Delegates. What I'm trying to do is get a list of Delegates that exist under a given Department. I tried doing it this way:

var teams = from tms in db.Teams where tms.DepartmentID == DepartmentID select tms; var TeamDelegates = from tds in db.J_TeamDelegates where tds.TeamID in teams.TeamID //error here select tds;

But the teams collection doesn't allow you to refer to a particular property as if it were a collection. What I'm trying to say is "Select all the Delegates with TeamIDs in the teams collection."

gzaxx · Accepted Answer · 2013-02-20 17:50:12Z

7

var TeamDelegates = from tds in db.J_TeamDelegates where teams.Any(x => x.TeamID == tds.TeamID) select tds;

answered Feb 20, 2013 at 17:50

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Timothy Shields Over a year ago

Although this directly answers the question, I think it's worth noting that the way I expressed it (with two SelectMany calls) is much more straightforward.

gunr2171 · Accepted Answer · 2013-02-20 17:59:11Z

I think you can use a join here.

var TeamDelegates = from tms in db.Teams where tms.DepartmentID == DepartmentID join tds in db.J_TeamDelegates on tms.TeamID equals tds.TeamID select tds;

cuongle · Accepted Answer · 2013-02-20 18:02:14Z

 var TeamDelegates = db.Teams .Where(tms => tms.DepartmentID == DepartmentID) .SelectMany(tms => db.J_TeamDelegates .Where(tds => tds.TeamID == tms.TeamID))

Timothy Shields · Accepted Answer · 2013-02-20 18:06:20Z

var delegates = db.Departments .Where(department => department.ID == 123) .SelectMany(department => department.Teams) .SelectMany(team => team.Delegates);

Collectives™ on Stack Overflow

Linq where in clause

4 Answers 4

1 Comment

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Related