用EF多表查询时间，怎么让他返回list类型

[qq_24071847]

代码是这样的 List<RailwayProject.Entities.DataAnalyze> list = from a in db.TestData
join b in db.TestObject on a.object_id equals b.object_id
join Organization1 in db.Organization on a.org_id equals Organization1.OrgId
join Organization2 in db.Organization on Organization1.ParentId equals Organization2.org_id
join Organization3 in db.Organization on Organization2.ParentId equals Organization3.org_id
join Organization4 in db.Organization on Organization3.ParentId equals Organization4.org_id
join indexResult in db.IndexResult on a.data_id equals indexResult.data_id
select new RailwayProject.Entities.DataAnalyze
{
a.data_id
};
然后提示错误 1 无法使用集合初始值初始化类型“RailwayProject.Entities.DataAnalyze”，原因是它未实现“System.Collections.IEnumerable” 这样的错误，不知道怎么转...

[exception92]

ToList() 一下。

[l2999019]

List<RailwayProject.Entities.DataAnalyze> list = from a in db.TestData 前面这段改成 var list = from a in db.TestData 后面改成 select new { a.data_id }; 然后用list.tolist()一下

[神棍]

2楼正解，ToList后才会查询。

[蝶恋花雨]

public class DataAnalyze
{
public int OrgId{get;set;}
//取出你的想要的字段或者怎么处理
}
List<RailwayProject.Entities.DataAnalyze> list =( from a in db.TestData select new RailwayProject.Entities.DataAnalyze
{
OrgId= a.org_id,
ParentId=a.ParentId
//依次往下写。 
}).ToList<RailwayProject.Entities.DataAnalyze>();