8,497
社区成员
发帖
与我相关
我的任务
分享
AdventureWorksEntities1 awe = new AdventureWorksEntities1();
List<Employee> listEmployers = new List<Employee>();
var employers = from employer in awe.Employee
select new Employee{ContactID=employer.ContactID,BirthDate=employer.BirthDate,
CurrentFlag=employer.CurrentFlag,Employee1=employer.Employee1,Employee2=employer.Employee2,
EmployeeID=employer.EmployeeID,Gender=employer.Gender,HireDate=employer.HireDate,
LoginID=employer.LoginID,MaritalStatus=employer.MaritalStatus,ModifiedDate=employer.ModifiedDate,
NationalIDNumber=employer.NationalIDNumber,rowguid=employer.rowguid,SalariedFlag=employer.SalariedFlag,
SickLeaveHours=employer.SickLeaveHours,Title=employer.Title,VacationHours=employer.VacationHours};
foreach (var emp in employers)//这报LINQ to Entities 查询中无法构造实体或复杂类型
{
listEmployers.Add(emp);
}
AdventureWorksEntities1 awe = new AdventureWorksEntities1();
List<Employee> listEmployers = new List<Employee>();
var employers = from employer in awe.Employee
select new Employee{BirthDate=employer.BirthDate};
listEmployers = employers.ToList<Employee>();