private static void ImportTitles(string filepath, MovieRepository repo) { var reader = File.OpenText(filepath + "movie_titles.csv"); repo.DeleteGenres(); //repo.DeleteAll(); var titlesimported = 0; int testlimit = 0; while (!reader.EndOfStream && testlimit < Int32.MaxValue) { string line = reader.ReadLine(); var items = line.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); int year, id; if (Int32.TryParse(items[0], out id) && Int32.TryParse(items[1], out year) && !string.IsNullOrEmpty(items[2])) { Movie m = new Movie() { Id = Int32.Parse(items[0]), Year = Int32.Parse(items[1]), Title = items[2] }; OMDBItem o = repo.GetOMDBData(m.Title); if (o != null && o.imdbID != null) { m.IMDBId = o.imdbID; m.PosterUrl = "http://img.omdbapi.com/?i=" + m.IMDBId + "&h=200&apikey=7e6ca2d5"; repo.DeleteById(m); repo.Add(m); repo.AddGenresForMovie(m.Id, o.Genre); titlesimported++; } testlimit++; } } Console.WriteLine(titlesimported + " titles imported"); }