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
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