public static void Initialize(SchoolContext context)
{
//context.Database.EnsureCreated();
// Look for any students.
if (context.Players.Any())
{
return; // DB has been seeded
}
var players = new Player[]
{
new Player {
FirstMidName = "Carson", LastName = "Alexander",
ContractDate = DateTime.Parse("2016-09-01")
},
new Player {
FirstMidName = "Meredith", LastName = "Alonso",
ContractDate = DateTime.Parse("2018-09-01")
},
new Player {
FirstMidName = "Arturo", LastName = "Anand",
ContractDate = DateTime.Parse("2019-09-01")
},
new Player {
FirstMidName = "Gytis", LastName = "Barzdukas",
ContractDate = DateTime.Parse("2018-09-01")
},
new Player {
FirstMidName = "Yan", LastName = "Li",
ContractDate = DateTime.Parse("2018-09-01")
},
new Player {
FirstMidName = "Peggy", LastName = "Justice",
ContractDate = DateTime.Parse("2017-09-01")
},
new Player {
FirstMidName = "Laura", LastName = "Norman",
ContractDate = DateTime.Parse("2019-09-01")
},
new Player {
FirstMidName = "Nino", LastName = "Olivetto",
ContractDate = DateTime.Parse("2011-09-01")
}
};
context.Players.AddRange(players);
context.SaveChanges();
var coaches = new Coach[]
{
new Coach {
FirstMidName = "Kim", LastName = "Abercrombie",
HireDate = DateTime.Parse("1995-03-11")
},
new Coach {
FirstMidName = "Fadi", LastName = "Fakhouri",
HireDate = DateTime.Parse("2002-07-06")
},
new Coach {
FirstMidName = "Roger", LastName = "Harui",
HireDate = DateTime.Parse("1998-07-01")
},
new Coach {
FirstMidName = "Candace", LastName = "Kapoor",
HireDate = DateTime.Parse("2001-01-15")
},
new Coach {
FirstMidName = "Roger", LastName = "Zheng",
HireDate = DateTime.Parse("2004-02-12")
}
};
context.Coaches.AddRange(coaches);
context.SaveChanges();
var departments = new Department[]
{
new Department {
Name = "English", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = coaches.Single(i => i.LastName == "Abercrombie").ID
},
new Department {
Name = "Mathematics", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = coaches.Single(i => i.LastName == "Fakhouri").ID
},
new Department {
Name = "Engineering", Budget = 350000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = coaches.Single(i => i.LastName == "Harui").ID
},
new Department {
Name = "Economics", Budget = 100000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = coaches.Single(i => i.LastName == "Kapoor").ID
}
};
context.Departments.AddRange(departments);
context.SaveChanges();
var teams = new Team[]
{
new Team {
TeamID = 1050, Title = "Chemistry", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Engineering").DepartmentID
},
new Team {
TeamID = 4022, Title = "Microeconomics", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID
},
new Team {
TeamID = 4041, Title = "Macroeconomics", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "Economics").DepartmentID
},
new Team {
TeamID = 1045, Title = "Calculus", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID
},
new Team {
TeamID = 3141, Title = "Trigonometry", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "Mathematics").DepartmentID
},
new Team {
TeamID = 2021, Title = "Composition", Credits = 3,
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID
},
new Team {
TeamID = 2042, Title = "Literature", Credits = 4,
DepartmentID = departments.Single(s => s.Name == "English").DepartmentID
},
};
context.Teams.AddRange(teams);
context.SaveChanges();
var officeAssignments = new OfficeAssignment[]
{
new OfficeAssignment {
CoachID = coaches.Single(i => i.LastName == "Fakhouri").ID,
Location = "Smith 17"
},
new OfficeAssignment {
CoachID = coaches.Single(i => i.LastName == "Harui").ID,
Location = "Gowan 27"
},
new OfficeAssignment {
CoachID = coaches.Single(i => i.LastName == "Kapoor").ID,
Location = "Thompson 304"
},
};
context.OfficeAssignments.AddRange(officeAssignments);
context.SaveChanges();
var teamCoaches = new TeamAssignment[]
{
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID,
CoachID = coaches.Single(i => i.LastName == "Kapoor").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID,
CoachID = coaches.Single(i => i.LastName == "Harui").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Microeconomics").TeamID,
CoachID = coaches.Single(i => i.LastName == "Zheng").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Macroeconomics").TeamID,
CoachID = coaches.Single(i => i.LastName == "Zheng").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Calculus").TeamID,
CoachID = coaches.Single(i => i.LastName == "Fakhouri").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Trigonometry").TeamID,
CoachID = coaches.Single(i => i.LastName == "Harui").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Composition").TeamID,
CoachID = coaches.Single(i => i.LastName == "Abercrombie").ID
},
new TeamAssignment {
TeamID = teams.Single(c => c.Title == "Literature").TeamID,
CoachID = coaches.Single(i => i.LastName == "Abercrombie").ID
},
};
context.TeamAssignments.AddRange(teamCoaches);
context.SaveChanges();
var contracts = new Contract[]
{
new Contract {
PlayerID = players.Single(s => s.LastName == "Alexander").ID,
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID,
Grade = Grade.A
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alexander").ID,
TeamID = teams.Single(c => c.Title == "Microeconomics").TeamID,
Grade = Grade.C
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alexander").ID,
TeamID = teams.Single(c => c.Title == "Macroeconomics").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alonso").ID,
TeamID = teams.Single(c => c.Title == "Calculus").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alonso").ID,
TeamID = teams.Single(c => c.Title == "Trigonometry").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Alonso").ID,
TeamID = teams.Single(c => c.Title == "Composition").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Anand").ID,
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Anand").ID,
TeamID = teams.Single(c => c.Title == "Microeconomics").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Barzdukas").ID,
TeamID = teams.Single(c => c.Title == "Chemistry").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Li").ID,
TeamID = teams.Single(c => c.Title == "Composition").TeamID,
Grade = Grade.B
},
new Contract {
PlayerID = players.Single(s => s.LastName == "Justice").ID,
TeamID = teams.Single(c => c.Title == "Literature").TeamID,
Grade = Grade.B
}
};
foreach (Contract e in contracts)
{
var contractInDataBase = context.Contracts.Where(
s =>
s.Player.ID == e.PlayerID &&
s.Team.TeamID == e.TeamID).SingleOrDefault();
if (contractInDataBase == null)
{
context.Contracts.Add(e);
}
}
context.SaveChanges();
}
public static void Initialize(SchoolContext context)
{
//context.Database.EnsureCreated();
// Look for any Athletes.
if (context.Athletes.Any())
{
return; // DB has been seeded
}
var Athletes = new Athlete[]
{
new Athlete {
FirstName = "Carson", LastName = "Alexander", Gender = Gender.Male, Dob = DateTime.Parse("1995-05-30"), Weight = 140, Height = 50
},
new Athlete {
FirstName = "Meredith", LastName = "Alonso", Gender = Gender.Male, Dob = DateTime.Parse("1992-07-5"), Weight = 160, Height = 60
},
new Athlete {
FirstName = "Arturo", LastName = "Anand", Gender = Gender.Male, Dob = DateTime.Parse("1993-02-15"), Weight = 165, Height = 55
},
new Athlete {
FirstName = "Gytis", LastName = "JELLISON", Gender = Gender.Female, Dob = DateTime.Parse("1992-02-27"), Weight = 125, Height = 47
},
new Athlete {
FirstName = "Yan", MiddleName = "Lee", LastName = "Li", Gender = Gender.Male, Dob = DateTime.Parse("1992-08-24"), Weight = 140, Height = 73
},
new Athlete {
FirstName = "Peggy", MiddleName = "Laura", LastName = "Justice", Gender = Gender.Female, Dob = DateTime.Parse("1991-08-03"), Weight = 230, Height = 73
},
new Athlete {
FirstName = "Laura", MiddleName = "Nicole", LastName = "Norman", Gender = Gender.Female, Dob = DateTime.Parse("1993-04-03"), Weight = 135, Height = 67
},
new Athlete {
FirstName = "Tom", MiddleName = "Marvolo", LastName = "Riddle", Gender = Gender.Male, Dob = DateTime.Parse("1995-04-11"), Weight = 145, Height = 76
},
new Athlete {
FirstName = "Carl", LastName = "Gibbons", Gender = Gender.Male, Dob = DateTime.Parse("1969-05-30"), Weight = 212, Height = 70
},
new Athlete {
FirstName = "Jackson ", LastName = "Smith ", Gender = Gender.Male, Dob = DateTime.Parse("1995-05-30"), Weight = 140, Height = 50
},
new Athlete {
FirstName = "Sebastian ", LastName = "Smith ", Gender = Gender.Male, Dob = DateTime.Parse("1992-07-5"), Weight = 160, Height = 60
},
new Athlete {
FirstName = "Aiden ", LastName = "Smith ", Gender = Gender.Male, Dob = DateTime.Parse("1991-02-15"), Weight = 165, Height = 55
},
new Athlete {
FirstName = "Matthew ", LastName = "Smith ", Gender = Gender.Female, Dob = DateTime.Parse("1992-02-20"), Weight = 125, Height = 47
},
new Athlete {
FirstName = "Samuel ", MiddleName = "Colt ", LastName = "CarolsunlutzenBurhSchmity", Gender = Gender.Male, Dob = DateTime.Parse("1992-08-29"), Weight = 140, Height = 73
},
new Athlete {
FirstName = "David ", MiddleName = "Archer ", LastName = "Wheat", Gender = Gender.Female, Dob = DateTime.Parse("1998-08-03"), Weight = 230, Height = 73
},
new Athlete {
FirstName = "Joseph ", MiddleName = "Omar ", LastName = "Desk", Gender = Gender.Female, Dob = DateTime.Parse("1997-04-03"), Weight = 135, Height = 67
},
new Athlete {
FirstName = "Tom", MiddleName = "Aidan ", LastName = "Oliveoil", Gender = Gender.Male, Dob = DateTime.Parse("1995-04-11"), Weight = 145, Height = 76
},
new Athlete {
FirstName = "Carter ", LastName = "Gibbons", Gender = Gender.Male, Dob = DateTime.Parse("1969-05-30"), Weight = 212, Height = 70
},
new Athlete {
FirstName = "Harper", LastName = "WhiteHouse", Gender = Gender.Male, Dob = DateTime.Parse("1995-05-30"), Weight = 140, Height = 50
},
new Athlete {
FirstName = "Meredith", LastName = "Ammoury", Gender = Gender.Male, Dob = DateTime.Parse("1992-07-5"), Weight = 160, Height = 60
},
new Athlete {
FirstName = "Evelyn", LastName = "Swartzburg", Gender = Gender.Male, Dob = DateTime.Parse("1993-02-13"), Weight = 165, Height = 55
},
new Athlete {
FirstName = "Abigail", LastName = "Disndy", Gender = Gender.Female, Dob = DateTime.Parse("1992-02-17"), Weight = 125, Height = 47
},
new Athlete {
FirstName = "Emily", MiddleName = "Ememin", LastName = "Li", Gender = Gender.Male, Dob = DateTime.Parse("1992-08-21"), Weight = 140, Height = 73
},
new Athlete {
FirstName = "Elizabeth", LastName = "Kalifia", Gender = Gender.Female, Dob = DateTime.Parse("1991-08-03"), Weight = 230, Height = 73
},
new Athlete {
FirstName = "Mila", LastName = "Prettyman", Gender = Gender.Female, Dob = DateTime.Parse("1993-04-23"), Weight = 135, Height = 67
},
new Athlete {
FirstName = "Ella", LastName = "Larson", Gender = Gender.Male, Dob = DateTime.Parse("1995-04-22"), Weight = 145, Height = 76
},
new Athlete {
FirstName = "Avery", LastName = "Thayne", Gender = Gender.Male, Dob = DateTime.Parse("1969-05-02"), Weight = 212, Height = 70
},
new Athlete {
FirstName = "Riley", LastName = "Ocean", Gender = Gender.Male, Dob = DateTime.Parse("1995-05-03"), Weight = 140, Height = 50
},
new Athlete {
FirstName = "Nora", LastName = "Excalaber", Gender = Gender.Male, Dob = DateTime.Parse("1992-07-15"), Weight = 160, Height = 60
},
new Athlete {
FirstName = "Eleanor", LastName = "Ansley", Gender = Gender.Male, Dob = DateTime.Parse("1993-02-15"), Weight = 165, Height = 55
},
new Athlete {
FirstName = "Hannah", LastName = "Barzee", Gender = Gender.Female, Dob = DateTime.Parse("1992-02-26"), Weight = 125, Height = 47
},
new Athlete {
FirstName = "Mason ", MiddleName = "Bryson ", LastName = "Li", Gender = Gender.Male, Dob = DateTime.Parse("1992-08-14"), Weight = 167, Height = 72
},
new Athlete {
FirstName = "Damian ", MiddleName = "Sawyer ", LastName = "Jenson", Gender = Gender.Female, Dob = DateTime.Parse("1991-08-05"), Weight = 213, Height = 73
},
new Athlete {
FirstName = "Silas ", MiddleName = "Nicole", LastName = "Raia", Gender = Gender.Female, Dob = DateTime.Parse("1993-04-03"), Weight = 189, Height = 78
},
new Athlete {
FirstName = "Chase ", MiddleName = "Declan ", LastName = "Riddle", Gender = Gender.Male, Dob = DateTime.Parse("1995-04-11"), Weight = 202, Height = 76
},
new Athlete {
FirstName = "Carl ", LastName = "Gibbons", Gender = Gender.Male, Dob = DateTime.Parse("1969-05-30"), Weight = 200, Height = 70
}
};
foreach (Athlete s in Athletes)
{
context.Athletes.Add(s);
}
context.SaveChanges();
var Coachs = new Coach[]
{
new Coach {
FirstName = "Kim", MiddleName = "Amber", LastName = "Abercrombie", HireDate = DateTime.Parse("1995-03-11")
},
new Coach {
FirstName = "Fadi", MiddleName = "Aliku", LastName = "Fakhouri", HireDate = DateTime.Parse("2002-07-06")
},
new Coach {
FirstName = "Tim", LastName = "Thayne", HireDate = DateTime.Parse("1998-07-01")
},
new Coach {
FirstName = "Candace", LastName = "Kapoor", HireDate = DateTime.Parse("2001-01-15")
},
new Coach {
FirstName = "Roger", LastName = "Zheng", HireDate = DateTime.Parse("2004-02-12")
}
};
foreach (Coach i in Coachs)
{
context.Coaches.Add(i);
}
context.SaveChanges();
var Fields = new Field[]
{
new Field {
Name = "Running", Budget = 357000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = Coachs.Single(i => i.LastName == "Thayne").ID
},
new Field {
Name = "Throwing", Budget = 0909000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = Coachs.Single(i => i.LastName == "Fakhouri").ID
},
new Field {
Name = "Jumping", Budget = 250000,
StartDate = DateTime.Parse("2007-09-01"),
CoachID = Coachs.Single(i => i.LastName == "Thayne").ID
}
};
foreach (Field d in Fields)
{
context.Fields.Add(d);
}
context.SaveChanges();
var Events = new Event[]
{
new Event {
EventID = 1001, Title = "100 Meters", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 1002, Title = "200 Meters", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 1003, Title = "400 Meters", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 1004, Title = "1500 Meters", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 1005, Title = "3000 Meters", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 1006, Title = "400 Meters", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 1007, Title = "100 Meter Hurdles", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 1008, Title = "400 Meters Hurdles", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 1009, Title = "4X100 Meter Relay", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 1010, Title = "4X400 Meters Relay", FieldID = Fields.Single(s => s.Name == "Running").FieldID
},
new Event {
EventID = 2001, Title = "High Jump", FieldID = Fields.Single(s => s.Name == "Jumping").FieldID
},
new Event {
EventID = 2002, Title = "Pole Vault", FieldID = Fields.Single(s => s.Name == "Jumping").FieldID
},
new Event {
EventID = 2003, Title = "Triple Jump", FieldID = Fields.Single(s => s.Name == "Jumping").FieldID
},
new Event {
EventID = 3001, Title = "Discus Throw", FieldID = Fields.Single(s => s.Name == "Throwing").FieldID
},
new Event {
EventID = 3002, Title = "Hammer Throw", FieldID = Fields.Single(s => s.Name == "Throwing").FieldID
},
new Event {
EventID = 3003, Title = "Shot Put", FieldID = Fields.Single(s => s.Name == "Throwing").FieldID
},
new Event {
EventID = 3004, Title = "Javelin Throw", FieldID = Fields.Single(s => s.Name == "Throwing").FieldID
}
};
foreach (Event c in Events)
{
context.Events.Add(c);
}
context.SaveChanges();
var EventCoach = new EventAssignment[]
{
new EventAssignment {
EventID = Events.Single(c => c.Title == "100 Meters").EventID,
CoachID = Coachs.Single(i => i.LastName == "Kapoor").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "200 Meters").EventID,
CoachID = Coachs.Single(i => i.LastName == "Kapoor").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "400 Meters").EventID,
CoachID = Coachs.Single(i => i.LastName == "Kapoor").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "1500 Meters").EventID,
CoachID = Coachs.Single(i => i.LastName == "Abercrombie").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "3000 Meters").EventID,
CoachID = Coachs.Single(i => i.LastName == "Abercrombie").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "100 Meter Hurdles").EventID,
CoachID = Coachs.Single(i => i.LastName == "Zheng").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "400 Meters Hurdles").EventID,
CoachID = Coachs.Single(i => i.LastName == "Zheng").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "4X100 Meter Relay").EventID,
CoachID = Coachs.Single(i => i.LastName == "Zheng").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "4X400 Meter Relay").EventID,
CoachID = Coachs.Single(i => i.LastName == "Zheng").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "High Jump").EventID,
CoachID = Coachs.Single(i => i.LastName == "Fakhouri").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "Pole Vault").EventID,
CoachID = Coachs.Single(i => i.LastName == "Fakhouri").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "Triple Jump").EventID,
CoachID = Coachs.Single(i => i.LastName == "Fakhouri").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "Discus Throw").EventID,
CoachID = Coachs.Single(i => i.LastName == "Thayne").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "Hammer Throw").EventID,
CoachID = Coachs.Single(i => i.LastName == "Thayne").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "Shot Put").EventID,
CoachID = Coachs.Single(i => i.LastName == "Thayne").ID
},
new EventAssignment {
EventID = Events.Single(c => c.Title == "Javelin Throw").EventID,
CoachID = Coachs.Single(i => i.LastName == "Thayne").ID
}
};
foreach (EventAssignment ci in EventCoach)
{
context.EventAssignments.Add(ci);
}
context.SaveChanges();
var trials = new Trial[]
{
//first
new Trial {
AthleteID = 35, EventID = 1001, Place = Place.First
},
new Trial {
AthleteID = 35, EventID = 1002, Place = Place.First
},
new Trial {
AthleteID = 35, EventID = 1003, Place = Place.First
},
new Trial {
AthleteID = 33, EventID = 1004, Place = Place.First
},
new Trial {
AthleteID = 5, EventID = 1005, Place = Place.First
},
new Trial {
AthleteID = 24, EventID = 1006, Place = Place.First
},
new Trial {
AthleteID = 13, EventID = 1007, Place = Place.First
},
new Trial {
AthleteID = 23, EventID = 1008, Place = Place.First
},
new Trial {
AthleteID = 14, EventID = 1009, Place = Place.First
},
new Trial {
AthleteID = 13, EventID = 1010, Place = Place.First
},
new Trial {
AthleteID = 10, EventID = 2001, Place = Place.First
},
new Trial {
AthleteID = 31, EventID = 2002, Place = Place.First
},
new Trial {
AthleteID = 27, EventID = 2003, Place = Place.First
},
new Trial {
AthleteID = 9, EventID = 3001, Place = Place.First
},
new Trial {
AthleteID = 5, EventID = 3002, Place = Place.First
},
new Trial {
AthleteID = 7, EventID = 3003, Place = Place.First
},
new Trial {
AthleteID = 16, EventID = 3004, Place = Place.First
},
new Trial {
AthleteID = 35, EventID = 1001, Place = Place.Second
},
new Trial {
AthleteID = 35, EventID = 1002, Place = Place.Second
},
new Trial {
AthleteID = 35, EventID = 1003, Place = Place.Second
},
new Trial {
AthleteID = 35, EventID = 1004, Place = Place.Second
},
new Trial {
AthleteID = 35, EventID = 1005, Place = Place.Second
},
new Trial {
AthleteID = 24, EventID = 1006, Place = Place.Second
},
new Trial {
AthleteID = 8, EventID = 1007, Place = Place.Second
},
new Trial {
AthleteID = 33, EventID = 1008, Place = Place.Second
},
new Trial {
AthleteID = 12, EventID = 1009, Place = Place.Second
},
new Trial {
AthleteID = 10, EventID = 1010, Place = Place.Second
},
new Trial {
AthleteID = 11, EventID = 2001, Place = Place.Second
},
new Trial {
AthleteID = 12, EventID = 2002, Place = Place.Second
},
new Trial {
AthleteID = 13, EventID = 2003, Place = Place.Second
},
new Trial {
AthleteID = 14, EventID = 3001, Place = Place.Second
},
new Trial {
AthleteID = 15, EventID = 3002, Place = Place.Second
},
new Trial {
AthleteID = 16, EventID = 3003, Place = Place.Second
},
new Trial {
AthleteID = 16, EventID = 3004, Place = Place.Second
},
new Trial {
AthleteID = 35, EventID = 1001, Place = Place.Third
},
new Trial {
AthleteID = 35, EventID = 1002, Place = Place.Third
},
new Trial {
AthleteID = 35, EventID = 1003, Place = Place.Third
},
new Trial {
AthleteID = 35, EventID = 1004, Place = Place.Third
},
new Trial {
AthleteID = 35, EventID = 1005, Place = Place.Third
},
new Trial {
AthleteID = 24, EventID = 1006, Place = Place.Third
},
new Trial {
AthleteID = 27, EventID = 1007, Place = Place.Third
},
new Trial {
AthleteID = 33, EventID = 1008, Place = Place.Third
},
new Trial {
AthleteID = 23, EventID = 1009, Place = Place.Third
},
new Trial {
AthleteID = 10, EventID = 1010, Place = Place.Third
},
new Trial {
AthleteID = 11, EventID = 2001, Place = Place.Third
},
new Trial {
AthleteID = 12, EventID = 2002, Place = Place.Third
},
new Trial {
AthleteID = 13, EventID = 2003, Place = Place.Third
},
new Trial {
AthleteID = 14, EventID = 3001, Place = Place.Third
},
new Trial {
AthleteID = 15, EventID = 3002, Place = Place.Third
},
new Trial {
AthleteID = 16, EventID = 3003, Place = Place.Third
},
new Trial {
AthleteID = 16, EventID = 3004, Place = Place.Third
},
new Trial {
AthleteID = 35, EventID = 1001
},
new Trial {
AthleteID = 35, EventID = 1002
},
new Trial {
AthleteID = 35, EventID = 1003
},
new Trial {
AthleteID = 35, EventID = 1004
},
new Trial {
AthleteID = 35, EventID = 1005
},
new Trial {
AthleteID = 24, EventID = 1006
},
new Trial {
AthleteID = 25, EventID = 1007
},
new Trial {
AthleteID = 33, EventID = 1008
},
new Trial {
AthleteID = 25, EventID = 1009
},
new Trial {
AthleteID = 10, EventID = 1010
},
new Trial {
AthleteID = 11, EventID = 2001
},
new Trial {
AthleteID = 12, EventID = 2002
},
new Trial {
AthleteID = 13, EventID = 2003
},
new Trial {
AthleteID = 14, EventID = 3001
},
new Trial {
AthleteID = 15, EventID = 3002
},
new Trial {
AthleteID = 16, EventID = 3003
},
new Trial {
AthleteID = 16, EventID = 3004
}
};
foreach (Trial e in trials)
{
var enrollmentInDataBase = context.Trials.Where(
s =>
s.Athlete.ID == e.AthleteID &&
s.Event.EventID == e.EventID).SingleOrDefault();
if (enrollmentInDataBase == null)
{
context.Trials.Add(e);
}
}
context.SaveChanges();
}
