/// <summary> /// Populate DB with retailers. /// </summary> /// <param name="context"> /// The context. /// </param> /// <param name="fileStorage"> /// The file storage. /// </param> public static void Populate(ShopAnyWareSql context, IFileStorage fileStorage) { var path = fileStorage.MapPath("~/App_Data/retailers.xls"); var retailersExcel = ExcelHelper.LoadRetailersFromExcelFile(path); var retailers = retailersExcel.Select(r => new Retailer(r.Url)).ToList(); var retailers2 = retailers.Where(r => string.IsNullOrWhiteSpace(r.Url) == false).ToList(); retailers2.ForEach(r => context.Retailers.Add(r)); context.SaveChanges(); }