实体框架查询错误

本文关键字：错误 查询 框架 实体 | 更新日期: 2023-09-27 18:06:54

我得到这个错误:

实体或复杂类型"Model"。不能在LINQ到实体查询中构造成员。

与我的代码:

public List<Members> getTeamMembers(String tem_reference)
{
        var query = from c in cecbContext.Projects
                    join b in cecbContext.TeamMembers on c.proj_team equals b.team_reference
                    join d in cecbContext.Members on b.mem_reference equals d.mem_reference
                    where c.proj_reference == tem_reference
                    select new Members
                    {
                        mem_reference = d.mem_reference
                    };
    return query.ToList<Members>();
}

实体框架查询错误

我相信您遇到了问题，因为您正在尝试投影映射实体，这个答案会告诉您更多信息:https://stackoverflow.com/a/5325861/2208058

我认为这可能对你有用:

var query = from c in cecbContext.Projects
                join b in cecbContext.TeamMembers on c.proj_team equals b.team_reference
                join d in cecbContext.Members on b.mem_reference equals d.mem_reference
                where c.proj_reference == tem_reference
                select d.mem_reference;
return query.Select(ref => new Members { mem_reference = d.mem_reference  }).ToList();
相关文章：