Entity Framework query to select

Question

table users: SSN, student name: SSN, school

I want to get all the SSNs for people who are not students. How to write this with entity infrastructure?

Answer 1

var ssnList = Context.Peoples .Where( p => !Context.Students .Any(s => s.SSN == p.SSN)) .Select( p => p.SSN).ToList();