EF 做联合，怎么给关联的表加条件

Question

A表
ID,NAME,BID
B表
ID,NAME,STATE

  var leftJoinSql = from a in db.A
                              join b in db.B on a.ID equals b.ID into bb
                              from bbb in bb.DefaultIfEmpty()
                              select new
                              {
                                   aname= a.NAME,
                                   bname = bbb==null?"":bbb.NAME
                              };

我想加个过滤条件，只关联B表STATE=0的字段

Answer 1

var leftJoinSql = from a in db.A
join b in db.B.where(s=>s.state==0) on a.ID equals b.ID into bb
from bbb in bb.DefaultIfEmpty()
select new
{
aname= a.NAME,
bname = bbb==null?"":bbb.NAME
};