
Untitled
By: a guest on
Apr 15th, 2012 | syntax:
None | size: 0.58 KB | hits: 9 | expires: Never
public void changeSongAlbum(int songID, int oldAlbumID, int newAlbumID)
{
using (var context = new ExamEntities())
{
var query = context.Songs.Where(o => o.SongID == songID);
var newAlbum = context.Albums.FirstOrDefault(o => o.AlbumID == newAlbumID);
var oldAlbum = context.Albums.FirstOrDefault(o => o.AlbumID == oldAlbumID);
foreach (var s in query)
{
s.Album.Remove(oldAlbum);
s.Album.Add(newAlbum);
}
context.SaveChanges();
}
}