hi.. please help me convert this to linq
SELECT dbo.tblPersonnel.empCode, dbo.tblPersonnel.areaCode, dbo.tblPersonnel.branhCode, dbo.tblPersonnel.regionCode
FROM dbo.tblPersonnel INNER JOIN
dbo.sg_branch ON dbo.tblPersonnel.regionCode = dbo.sg_branch.Region AND dbo.tblPersonnel.areaCode = dbo.sg_branch.Area AND
dbo.tblPersonnel.branhCode = dbo.sg_branch.BranchCode
i have here:
var Personnel = from tblpersonnel in db.tblPersonnel
join tblbranch in db.sg_branch on tblpersonnel.branhCode equals tblbranch.BranchCode
where (tblpersonnel.branhCode.Equals(tmpBranch))
orderby tblpersonnel.empFname
select tblpersonnel;
i don't know with multiple joins.. please enhance..