public async Task ImportPerson(IFormFile file) { using (var reader = new StreamReader(file.OpenReadStream())) using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture)) { var records = csv.GetRecords <PersonCsv>().Select(Person.ParseFromCsv).ToList(); _context.AddRange(records); await _context.SaveChangesAsync(); } }
private void SeedSampleData(PersonContext context) { var people = new List <Person> { new Person { FirstName = "James", LastName = "Jamie", BirthDate = DateTime.Parse("5/3/1960"), Children = 5, Height = 5.4M, Weight = 250M }, new Person { FirstName = "Tony", LastName = "Tonia", BirthDate = DateTime.Parse("7/3/1961"), Children = 3, Height = 4.4M, Weight = 150M }, new Person { FirstName = "Bandy", LastName = "Momin", BirthDate = DateTime.Parse("8/3/1970"), Children = 1, Height = 5.4M, Weight = 250M }, new Person { FirstName = "Tannie", LastName = "Tanner", BirthDate = DateTime.Parse("2/3/1950"), Children = 0, Height = 6.4M, Weight = 350M }, new Person { FirstName = "Cromie", LastName = "Crammer", BirthDate = DateTime.Parse("9/3/1953"), Children = 15, Height = 6.2M, Weight = 120M }, new Person { FirstName = "Xorie", LastName = "Zera", BirthDate = DateTime.Parse("10/3/1974"), Children = 2, Height = 5.9M, Weight = 175M } }; context.AddRange(people); context.SaveChanges(); }