0
votes

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"

Is it throwing an error, or ??? Is "name" found in both tables? - Isolated
EF core doesn't want to return a single column using SQL raw, have to do it in LINQ. I have no idea why. - ShawnL