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; } }