public void AddWebsitesFromCsv(string rawCsv) { var websiteEntries = CsvService.ParseWebsiteCsvList(rawCsv); var hostnames = websiteEntries.Select(x => x.Hostname.ToLower()).ToList(); var doWebsitesExist = WebsiteRepository.DoWebsitesExist(hostnames); foreach (var websiteEntry in websiteEntries) { if (!doWebsitesExist[websiteEntry.Hostname.ToLower()]) { var websiteCategory = WebsiteCategoryService.GetOrCreateWebsiteCategory(websiteEntry); WebsiteRepository.Add(new WebsiteDto() { Id = WebsiteService.GetNextId(), Hostname = websiteEntry.Hostname.ToLower(), LastScan = DateTime.MinValue, Status = StatusType.NEW, CategoryId = websiteCategory.Id }); } } }