LinQ Join

Join

var list = from s in db.mm_ShopMas
                       join p in db.mm_SpaceMas on s.TradeId equals p.SpaceId
                       join t in db.mm_TradeMas on s.TradeId equals t.TradeId
                       where s.IsStop == false
                       select new { s.ShopId,s.ShopName,p.SpaceName,t.TradeName};

执行结果：