SQL Server Inner Join

Join's ON method accepts a simple Object equality expression and infers the actual relationship from EF metadata:

There is also an option to specify the relationship manually:

Any number of entities can be joined: