在音乐商店项目中,进行Album唱片集、Genre流派的多表查询,实现GenreId的内联接,查询基于多表查询的,AlbumId大于100的所有唱片集。 唱片集Album,歌手Artist和流派Genre的类定义如下: public class Album { public int AlbumId { get; set; } public int GenreId { get; set; } public int ArtistId { get; set; } public string Title { get; set; } public decimal Price { get; set; } public string AlbumArtUrl { get; set; } public virtual Genre Genre { get; set; } public virtual Artist Artist { get; set; } } public class Artist { public int ArtistId { get; set; } public string Name { get; set; } } public class Genre { public int GenreId { get; set; } public string Name { get; set; } public string Description { get; set; } public List Albums { get; set; } } 请根据题目要求,实现题中查询功能: var albumInnerGerne = db.Set () .Join(db.Set< >(), x => x.Genre.GenreId, c => c.GenreId, ) .Where( );