//public void AddMovieToDb(Movie movie)
//{
// var entities = new MovieDbEntities();
// if (entities.Movies.Where(o => o.ImdbId.Equals(movie.ImdbId)).ToList().Count() == 0)
// {
// entities.AddToMovies(movie);
// entities.SaveChanges();
// }
// else
// {
// //Already exists
// Console.WriteLine(@"Exists: {0}", movie.ImdbId);
// }
//}
#endregion
public void RemoveMovie(string imdbId)
{
_entities.DeleteObjects(_entities.MovieGenres.Where(o => o.Movie.ImdbId == imdbId));
_entities.DeleteObjects(_entities.MovieCountries.Where(o => o.Movie.ImdbId == imdbId));
_entities.DeleteObjects(_entities.MovieKeywords.Where(o => o.Movie.ImdbId == imdbId));
_entities.DeleteObjects(_entities.MovieLanguages.Where(o => o.Movie.ImdbId == imdbId));
_entities.DeleteObjects(_entities.MoviePersonalNotes.Where(o => o.Movie.ImdbId == imdbId));
_entities.DeleteObjects(_entities.MovieUserLists.Where(o => o.Movie.ImdbId == imdbId));
_entities.DeleteObjects(_entities.Movies.Where(o => o.ImdbId == imdbId));
_entities.SaveChanges();
}