EF/LINQ how do I query a junction table
===

and thanks for any help.

Using EntityFramework/LINQ, I need help with the following.

The database has a table of People with an identity column of PersonId.  There is also a Skills table with an identity column of SkillId.  These two are connected via a third table PeopleSkills that has its own identity column PeopleSkillsId, a foreign column referencing PersonId and a foreign column referencing SkillId.

The method that I am trying to write is passed a parameter of type List<int> that contains any number of skills that we are looking for.  The method should return a List<People> who are linked to all of the skills in the input parameter list.

A future task is to return anyone who matches 3 out of 4 skills (for example).  If there's a way to handle both now, that would be even better.

And again, thank you.

Steve