Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Apr 15th, 2012  |  syntax: None  |  size: 0.58 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
This paste has a previous version, view the difference. Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.  public void changeSongAlbum(int songID, int oldAlbumID, int newAlbumID)
  2.     {
  3.         using (var context = new ExamEntities())
  4.         {
  5.             var query = context.Songs.Where(o => o.SongID == songID);
  6.             var newAlbum = context.Albums.FirstOrDefault(o => o.AlbumID == newAlbumID);
  7.             var oldAlbum = context.Albums.FirstOrDefault(o => o.AlbumID == oldAlbumID);
  8.             foreach (var s in query)
  9.             {
  10.                 s.Album.Remove(oldAlbum);
  11.                 s.Album.Add(newAlbum);
  12.             }
  13.             context.SaveChanges();
  14.         }
  15.     }