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