private List<Album> GetArtistAlbumCollection(int userId)
{
var artistAlbumRepository = new SqlArtistAlbumRepository(ConnectionString);
var albumRepository = new SqlAlbumRepository(ConnectionString);
var userAlbums = artistAlbumRepository.GetArtistAlbumsByArtistId(userId);
var albums = userAlbums.Select(userAlbum => albumRepository.Album.FirstOrDefault(x => x.AlbumId == userAlbum.AlbumId)).ToList();
return albums;
}
