例如：album，artist，genre这三个表的连接语句。。谢谢
------解决方案--------------------------------------------------------
public PagedList<Album> pageIndex(int page, int pageSize)
{
var re = from a in db.Albums
join ats in db.Artists
on a.ArtistId equals ats.Id
join g in db.Genres
on a.GenreId equals g.Id
select new Album
{
//需要什么字段，就在此查询
};
return re.ToPagedList(page, pageSize).ToList();
}