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