linq多表链接问题
以下是一个表中的数据,其中灰色的“复核”按钮数据在另一张表中,怎样调用
------解决方案--------------------
var q =  
   from c in db.A  
   join o in db.B on c.AID  
   equals o.ID into g  
   select new  
   {  
       c.Name,  
       g.Count()  
   };  
var q =  
   from e in db.Employees  
   join o in db.Books on e.EmployeeID  equals o.EmployeeID  into b  
   from x in b.DefaultIfEmpty()  
   select new  
   {  
       e.ID,  
       e.Name,  
       o.BookName  
   };
------解决方案--------------------
var query = from card in DBContext.Cards join c in DBContext.Check on card.ID equals c.CardID select new {ID=card.ID,Name=card.Name,IsCheck=c.IsCheck};