linq to entity(两个entity的连接查询)

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