EFW many to many query

Hello,

need some help working a linq query,
need to retreive sites for specific employee, and can't seem to get it right

Code:

---

from ES in lCom.DB.EmpSites.Where(x=>x.EmpID==SelectedEmployee.EmpID).ToList()
                                    join S in lCom.DB.Sites on ES.SiteID equals S.SiteID
                                    select (x=>Site);

---

also, Sites for a specific manager and specific employee

Thanks in advance for any help :wave::wave:

Sql Script

Code:

---


create table Employees
(EmpID int identity(1,1)primary key,EmpCode nvarchar(10) not null unique )

create table Sites (SiteID int identity(1,1) primary key,SiteCode nvarchar(10), SiteName varchar(20))

create table EmpSites
( EmpSiteID int identity(1,1),
EmpID int not null foreign key references Employees(EmpID),
SiteID int not null foreign key references Sites(SiteID),
primary key (EmpID,SiteID)
)
go

-- Managers --
create table Managers (ManID int identity(1,1) primary key, FirstName nvarchar(25),LastName nvarchar(25),
LoginName nvarchar(12) not null,LoginPwd nvarchar(12) not null,Authority text)
go
-- Managers Sites --
create table ManSites
(ManSiteID int identity(1,1),
ManID int not null foreign key references Managers(ManID),
SiteID int not null foreign key references Sites(SiteID), constraint PK__ManSite primary key (ManID,SiteID)
)
go

---