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();
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 into ald
join g in db.Genres
on a.GenreId equals g.Id into gens
select new {
ald=ald.Count(),
gens=gens.Count()
};
return re.ToPagedList(page, pageSize).ToList();
对不起哦,太着急了忘了。
artist 表中的id是album表的外键,genre表中的id是album表的外键,album表中有artistid,genreid字段分别与artist和 genre有关系