I'm trying to convert a SQL statement to LINQ. I've converted a few but I can't figure out this one.
SELECT name FROM people p
INNER JOIN careers c on p.SSN = c.SSN
WHERE p.City = "new york" AND c.occupation = "engineer"
I'm trying to convert a SQL statement to LINQ. I've converted a few but I can't figure out this one.
SELECT name FROM people p
INNER JOIN careers c on p.SSN = c.SSN
WHERE p.City = "new york" AND c.occupation = "engineer"