public static void AddPeopleFromMovie(this IMDB movie)
{
List <string> peopleAlreadyInDB =
(from person in Context.People select person.FirstName + " " + person.LastName).ToList();
List <string> people = movie.Cast.ToList();
people.AddRange(movie.Directors.ToList());
people.AddRange(movie.Writers.ToList());
people = people.Distinct().ToList();
List <string> peopleToAdd =
people.Where(person => !peopleAlreadyInDB.Contains(person.ToString(CultureInfo.InvariantCulture))).
ToList();
//add the people
foreach (string person in peopleToAdd)
{
Tuple <string, string> personName = person.SplitNameToFirstAndRemainingAsLast();
Context.AddToPeople(new Person
{
FirstName = personName.Item1,
LastName = personName.Item2
});
}
}
