public IEnumerable<Song> GetSongsByArtist(string name)
 {
     using (var context = new ChinookEntities())
     {
         var result = context.GetSongsByArtist(name);
         var songs = (from item in result.ToList()
                      select new Song
                                 {
                                     SongName = item.SongName,
                                     AlbumName = item.AlbumName,
                                     ArtistName = item.ArtistName
                                 }).ToList();
         return songs;
     }
 }