public async Task <IEnumerable <Album> > GetAlbumsByGenre(Guid genreId) { IQueryable <Album> query = _context.Set <Album>(); var result = query.Where(album => album.GenreId == genreId); return(await result.ToListAsync()); }
public async Task <Album> GetAlbumAsync(Guid albumId) { IQueryable <Album> query = _context.Set <Album>(); //// Build Query var result = query.Include(a => a.Track) .Where(a => a.Id == albumId); //// execute query and return the result return(await result.FirstOrDefaultAsync()); }
public async Task <IEnumerable <Album> > GetAlbumsByArtistAsync(Guid artistId) { IQueryable <Album> query = _context.Set <Album>(); var result = query.Where(a => a.ArtistId == artistId); return(await result.ToListAsync()); }