I need to figure how the write the following using linq to entities. I have a table that references itself, and the syntax is over my head!
Here is the SQL of exactly what I need to run
from projects p
join projectReferences pr on p.projectGuid=pr.projectGuid
join projectContent pc on pr.referenceProjectID=pc.projectID
where p.projectID = 1234
The table projectReferences here is what is confusing me, it's not part of my EF model, since there is simply a navigation property.