public Artist GetArtistById(int id) { using (var context = new ChinookEntities()) { var result = context.ExecuteStoreQuery<Artist>("SELECT ArtistId, Name FROM Artist WHERE Artist.ArtistId=@id", new SqlParameter { ParameterName = "@id", Value = id }); return result.FirstOrDefault(); } }
public IEnumerable<Song> GetSongsByArtist(string name) { const string query = @"SELECT Album.Title as AlbumName, Track.Name as SongName, Artist.Name as ArtistName FROM Artist INNER JOIN Album ON Album.ArtistId = Artist.ArtistId INNER JOIN Track ON Track.AlbumId = Album.AlbumId WHERE Artist.Name=@name"; using (var context = new ChinookEntities()) { var result = context.ExecuteStoreQuery<Song>(query, new SqlParameter { ParameterName = "@name", Value = name }); return result.ToList(); } }