Inner join query in EF6

entity-framework-6 linq

Question


I want assistance with an MVC application query.

I made the following SQL query:

SELECT Projects.ID, Projects.ProjectName, Employees.ID
FROM Projects INNER JOIN (Employees INNER JOIN ProjectEmployees ON Employees.ID = ProjectEmployees.EmployeeId) ON Projects.ID = ProjectEmployees.ProjectId
WHERE (((Employees.ID)=2));

It should seem as follows: Access Querydesigner

How can I reconstruct it for my MVC application using maybe LinQ or another format?

Thanks, Carsten

1
0
4/3/2020 8:33:12 AM

Accepted Answer

ZZZ_tmp
1
4/5/2020 1:31:37 PM

Popular Answer

ZZZ_tmp


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow