I am having hard time figuring out how to reproduce following SQL in LINQ
SELECT State.Name, City.Name, COUNT(Person.PersonId)
FROM State INNER JOIN City ON State.StateId=City.StateId
INNER JOIN Person Person.CityId=City.CityId
GROUP BY State.Name, City.Name
I have few quires similar to this on with HAVING, SUM and so on.
Can some one help me with LINQ expression for this sample?
Thanks,
Shimon.