private void AddProducersOfMovie(ICollection <int> selectedProducerIds, int movieId) { var collectionToAdd = new List <MovieProducers>(); foreach (var producerId in selectedProducerIds.Distinct().ToList()) { //check if person exists and relation doesn't if (DbContext.People.Any(p => p.Id == producerId) && !DbContext.MovieProducers.Any(ma => ma.PersonId == producerId && ma.MovieId == movieId)) { var item = new MovieProducers() { PersonId = producerId, MovieId = movieId }; collectionToAdd.Add(item); } } DbContext.MovieProducers.AddRange(collectionToAdd); DbContext.SaveChanges(); }
public void Add(MovieProducer movieProducer) { MovieProducers.Add(movieProducer); }