public static void Seed(TennisBackendDbContext db) { Console.WriteLine("DbSeeder::Seed"); var person = new Person { Firstname = "Hansi", Lastname = "Huber", Age = 66 }; var person1 = new Person { Firstname = "Susi", Lastname = "Maier", Age = 23 }; var person2 = new Person { Firstname = "Fritzi", Lastname = "Hofer", Age = 33 }; db.Persons.Add(person); db.Persons.Add(person1); db.Persons.Add(person2); db.Bookings.Add(new Booking { DayOfWeek = 2, Week = 22, Hour = 9, Person = person }); db.Bookings.Add(new Booking { DayOfWeek = 3, Week = 22, Hour = 11, Person = person1 }); db.Bookings.Add(new Booking { DayOfWeek = 5, Week = 22, Hour = 12, Person = person }); db.Bookings.Add(new Booking { DayOfWeek = 6, Week = 22, Hour = 13, Person = person1 }); db.Bookings.Add(new Booking { DayOfWeek = 6, Week = 22, Hour = 14, Person = person2 }); db.Bookings.Add(new Booking { DayOfWeek = 2, Week = 23, Hour = 10, Person = person }); db.SaveChanges(); }
public static void Clear(TennisBackendDbContext db) { Console.WriteLine("DbSeeder::Clear"); db.Database.ExecuteSqlRaw("DELETE FROM Persons"); db.Database.ExecuteSqlRaw("DELETE FROM Bookings"); }