EntityFramework代码首先，是否可以映射这个

Question

是否有可能将其映射到一个实体？

select x,y,z, (select count(*) from othertable where tableid=table.id) as othertablecount
from table t

我想将其映射到一个如下所示的类：

public class Stuff
{
    public string x { get; set; }
    public string y { get; set; }
    public string z { get; set; }
    public int count { get; set; }
}

Answer 1

不，您应该将其正确映射为集合并使用投影进行查询：

class Stuff
{
   ...
   public virtual ICollection<OtherStuff> { get; set; }
}

var stuffWithCount = from stuff in myContext.Stuff
                     select new
                            {
                                stuff.x, ...
                                count = stuff.OtherStuff.Count()
                            };