Hello,
need some help working a linq query,
need to retreive sites for specific employee, and can't seem to get it right
also, Sites for a specific manager and specific employeeCode: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);
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





Reply With Quote
