var list = from l in context.EmployeeList 实体
from b in context.EmployeeBasicInfo
where l.Guid == b.Guid && ((l.TerminationDate.HasValue && l.TerminationDate.Value>DateTime.Now) || !l.TerminationDate.HasValue)
orderby l.EmployeeID ascending
select new DCEmployeeForIntranet()
{
AreaNumber=b.CompanyPhoneArea,
BizGroup=l.BizGroupName,
Department=l.FinanceDepartmentName,
Division=l.DivisionName,
Email=b.Email,
EmployeeID=l.EmployeeID,
Extsion=b.CompanyPhoneExt,
FirstName=l.FirstName,
LastName=l.LastName,
MiddleName=l.MiddleName,
NameInAvo=l.AchievoName,
NationalNumber=b.CompanyPhoneNational,
NativeName=l.NativeName,
Office=l.OfficeName,
OfficePhone=b.CompanyPhoneNumber,
ReportTo=l.ReportTo
};
linq to entity(两个entity的连接查询)
最新推荐文章于 2021-09-12 22:19:58 发布