public RiderAccountService(TT_ProjectContext context) { _context = context; }
static void Main(string[] args) { using (var db = new TT_ProjectContext()) { //var newRace1 = new Race //{ // RaceName = "Superstock", // NumberOfLaps = 4, // NumberOfPitStops = 1 //}; //db.Races.Add(newRace1); //db.SaveChanges(); //var newRace2 = new Race //{ // RaceName = "Supersport", // NumberOfLaps = 4, // NumberOfPitStops = 1 //}; //db.Races.Add(newRace2); //db.SaveChanges(); //var newRace3 = new Race //{ // RaceName = "Lightweight", // NumberOfLaps = 4, // NumberOfPitStops = 1 //}; //db.Races.Add(newRace3); //db.SaveChanges(); //var newRace4 = new Race //{ // RaceName = "TT Zero", // NumberOfLaps = 1, // NumberOfPitStops = 0 //}; //db.Races.Add(newRace4); //db.SaveChanges(); //var newRace5 = new Race //{ // RaceName = "SENIOR - Superbike", // NumberOfLaps = 6, // NumberOfPitStops = 2 //}; //db.Races.Add(newRace5); //db.SaveChanges(); //var newRider = new RiderAccount //{ // Email = "*****@*****.**", // Passwrd = "password", // FirstName = "Breesha", // LastName = "Foxton", // DateOfBirth = "24/06/1998", // Nationality = "Manx", // Experience = "no rider experience" //}; //db.RiderAccounts.Add(newRider); //db.SaveChanges(); //var newBike = new Bike //{ // RiderId = 1, // BikeMake = "Norton", // BikeSponsor = "Norton" //}; //db.Bikes.Add(newBike); //db.SaveChanges(); //var newEntry = new Entry //{ // RiderId = 1, // RaceId = 1 //}; //db.Entries.Add(newEntry); //db.SaveChanges(); //var newRider = new RiderAccount //{ // Email = "*****@*****.**", // Passwrd = "password", // FirstName = "Dean", // LastName = "Harrison", // DateOfBirth = "01/05/1985", // Nationality = "English", // Experience = "SENIOR - Superbike winner 2019" //}; //db.RiderAccounts.Add(newRider); //db.SaveChanges(); //var newRider2 = new RiderAccount //{ // Email = "*****@*****.**", // Passwrd = "password3", // FirstName = "Michael", // LastName = "Dunlop", // DateOfBirth = "01/06/1985", // Nationality = "Irish", // Experience = "SENIOR - Superbike winner 2018" //}; //db.RiderAccounts.Add(newRider2); //db.SaveChanges(); //var newRider3 = new RiderAccount //{ // Email = "*****@*****.**", // Passwrd = "password4", // FirstName = "Peter", // LastName = "Hickman", // DateOfBirth = "01/07/1980", // Nationality = "English", // Experience = "SENIOR - Superbike second place 2019, Supersport winner 2019" //}; //db.RiderAccounts.Add(newRider3); //db.SaveChanges(); //var deleteRider = //from ra in db.RiderAccounts //where ra.Email == "Robert" //|| ra.Email == "steve" //|| ra.RiderId == 38 //select ra; //db.RiderAccounts.RemoveRange(deleteRider); //db.SaveChanges(); //var newRider = new RiderAccount //{ // Email = "*****@*****.**", // Passwrd = "password", // FirstName = "Anne", // LastName = "Loft", // DateOfBirth = "01/05/1985", // Nationality = "English", // Experience = "No known experience" //}; //db.RiderAccounts.Add(newRider); //db.SaveChanges(); //var newRider10 = new RiderAccount //{ // Email = "*****@*****.**", // Passwrd = "password", // FirstName = "Andy", // LastName = "Loft", // DateOfBirth = "01/05/1985", // Nationality = "English", // Experience = "Mechanic - limited racing experience" //}; //db.RiderAccounts.Add(newRider10); //db.SaveChanges(); } }