public async static Task Seed(this CarParkContext context) { await context.Database.EnsureDeletedAsync(); await context.Database.EnsureCreatedAsync(); context.Rates.Add(new RateEntity { Name = "Early Bird", Type = RateType.Flat, RateDay = RateDay.Weekday, EntryMin = DateTime.ParseExact("06:00:00 AM", "h:mm:ss tt", CultureInfo.InvariantCulture), EntryMax = DateTime.ParseExact("09:00:00 AM", "h:mm:ss tt", CultureInfo.InvariantCulture), ExitMin = DateTime.ParseExact("03:30:00 PM", "h:mm:ss tt", CultureInfo.InvariantCulture), ExitMax = DateTime.ParseExact("11:30:00 PM", "h:mm:ss tt", CultureInfo.InvariantCulture), Price = 13 }); context.Rates.Add(new RateEntity { Name = "Night Rate", Type = RateType.Flat, RateDay = RateDay.Weekday, EntryMin = DateTime.ParseExact("06:00:00 PM", "h:mm:ss tt", CultureInfo.InvariantCulture), EntryMax = DateTime.ParseExact("11:59:00 PM", "h:mm:ss tt", CultureInfo.InvariantCulture), ExitMin = DateTime.ParseExact("03:30:00 PM", "h:mm:ss tt", CultureInfo.InvariantCulture).AddDays(1), ExitMax = DateTime.ParseExact("11:30:00 PM", "h:mm:ss tt", CultureInfo.InvariantCulture).AddDays(1), Price = 6.5 }); context.Rates.Add(new RateEntity { Name = "Weekend Rate", Type = RateType.Flat, RateDay = RateDay.Weekend, EntryMin = DateTime.ParseExact("12:00:00 AM", "h:mm:ss tt", CultureInfo.InvariantCulture), ExitMax = DateTime.ParseExact("12:00:00 AM", "h:mm:ss tt", CultureInfo.InvariantCulture), Price = 10 }); context.HourlyRates.Add(new HourlyRateEntity { Name = "Standard Rate", DurationMin = 0, DurationMax = 1, IsHourly = true, Price = 5 }); context.HourlyRates.Add(new HourlyRateEntity { Name = "Standard Rate", DurationMin = 1, DurationMax = 2, IsHourly = true, Price = 10 }); context.HourlyRates.Add(new HourlyRateEntity { Name = "Standard Rate", DurationMin = 2, DurationMax = 3, IsHourly = true, Price = 15 }); context.HourlyRates.Add(new HourlyRateEntity { Name = "Standard Rate", DurationMin = 3, DurationMax = int.MaxValue, IsDaily = true, Price = 20 }); await context.SaveChangesAsync(); }