public Artist GetArtistById(int id)
{
using (var context = new ChinookEntities())
{
context.Artists.MergeOption = MergeOption.NoTracking;
return GetArtistByIdQuery.Invoke(context, id).FirstOrDefault();
}
}
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 Artist GetArtistById(int id)
{
using (var context = new ChinookEntities())
{
var result = context.GetArtistById(id);
var items = from item in result
select new Artist
{
ArtistId = item.ArtistId,
Name = item.Name
};
return items.FirstOrDefault();
}
}
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;
}
}
public Artist GetArtistById(int id)
{
using (var context = new ChinookEntities())
{
var query = from artist in context.Artists
where artist.ArtistId == id
select new Artist
{
ArtistId = artist.ArtistId,
Name = artist.Name
};
((ObjectQuery)query).MergeOption = MergeOption.NoTracking;
return query.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();
}
}
public IEnumerable<Song> GetSongsByArtist(string name)
{
using (var context = new ChinookEntities())
{
var query = from track in context.Tracks
where track.Album.Artist.Name == name
select new Song
{
AlbumName = track.Album.Title,
ArtistName = track.Album.Artist.Name,
SongName = track.Name
};
((ObjectQuery)query).MergeOption = MergeOption.NoTracking;
return query.ToList();
}
}
public IEnumerable<Song> GetSongsByArtist(string name)
{
using (var context = new ChinookEntities())
{
context.Tracks.MergeOption = MergeOption.NoTracking;
return GetSongsByArtistQuery.Invoke(context, name).ToList();
}
}
