public IQueryable<Team> loadSearchData(TeamQuery team)
{
//知道DepID
if (DepID> 0)
{
temp = temp.Where<Team>(u => u.DepID== DepID);
}
if(MatchID>0){
//linq写法为
// from s in departmentwhere s.MatchID==MatchID
// from t in Team where t.DepID==s.DepID
// select t
//这儿如何写？依据MatchID查询department，依据查询出来的department表的DepID来查询得到Team表
temp = temp.Where<Team>(u=> 如何写 ）
}
}
第二问：
依据MatchID查询department，依据查询出来的department表的DepID来查询得到Team表，依据查询出来的Team表的TeamID来查询Player
//linq写法为
// from s in departmentwhere s.MatchID==MatchID
// from t in Team where t.DepID==s.DepID
// from p in Player where p.TeamID==t.TeamID
// select p
//这儿如何写？
temp = temp.Where<Player>(u=> 如何写 ）
}
}
