public void AddBandAlbumSong(Guid idBand, Guid?idAlbum, Guid idSong) { if (!db.Bands.Any(b => b.IdBand == idBand)) { throw new Exception("Band id not found"); } if (idAlbum != null) { if (!db.Albums.Any(a => a.IdAlbum == idAlbum)) { throw new Exception("Album id not found"); } } if (!db.Songs.Any(s => s.IdSong == idSong)) { throw new Exception("Song id not found"); } if (db.BandAlbumSongs.Any(bas => bas.IdBand == idBand && bas.IdSong == idSong)) { throw new Exception("BandAlbumSong link already exists"); } BandAlbumSong newBandAlbumSong = new BandAlbumSong() { IdBand = idBand, IdAlbum = idAlbum, IdSong = idSong }; db.BandAlbumSongs.InsertOnSubmit(newBandAlbumSong); db.SubmitChanges(); }
private void detach_BandAlbumSongs(BandAlbumSong entity) { this.SendPropertyChanging(); entity.Band = null; }
private void attach_BandAlbumSongs(BandAlbumSong entity) { this.SendPropertyChanging(); entity.Band = this; }
partial void DeleteBandAlbumSong(BandAlbumSong instance);
partial void UpdateBandAlbumSong(BandAlbumSong instance);
partial void InsertBandAlbumSong(BandAlbumSong instance);