public static void InitializeBuildings(IServiceProvider serviceProvider)
{
using (var context = new PeoplePro2Context(
serviceProvider.GetRequiredService <
DbContextOptions <PeoplePro2Context> >()))
{
// Look for any buildings.
if (context.Building.Any())
{
return; // DB has been seeded
}
context.Building.AddRange(
new Building
{
Name = "Peach Building"
},
new Building
{
Name = "Tangerine Building"
},
new Building
{
Name = "Mango Building"
}
);
context.SaveChanges();
}
}
public static void InitializeEmployees(IServiceProvider serviceProvider)
{
using (var context = new PeoplePro2Context(
serviceProvider.GetRequiredService <
DbContextOptions <PeoplePro2Context> >()))
{
// Look for any buildings.
if (context.Employee.Any())
{
return; // DB has been seeded
}
context.Employee.AddRange(
new Employee
{
FirstName = "Shannon",
DepartmentId = context.Department.Skip(0).FirstOrDefault().DepartmentId
},
new Employee
{
FirstName = "Marge",
DepartmentId = context.Department.Skip(2).FirstOrDefault().DepartmentId
},
new Employee
{
FirstName = "Jim",
DepartmentId = context.Department.Skip(4).FirstOrDefault().DepartmentId
},
new Employee
{
FirstName = "Karen",
DepartmentId = context.Department.Skip(1).FirstOrDefault().DepartmentId
},
new Employee
{
FirstName = "Pam",
DepartmentId = context.Department.Skip(2).FirstOrDefault().DepartmentId
},
new Employee
{
FirstName = "Michael",
DepartmentId = context.Department.Skip(1).FirstOrDefault().DepartmentId
},
new Employee
{
FirstName = "Dwight",
DepartmentId = context.Department.Skip(3).FirstOrDefault().DepartmentId
}
);
context.SaveChanges();
}
}
public static void InitializeDepartments(IServiceProvider serviceProvider)
{
using (var context = new PeoplePro2Context(
serviceProvider.GetRequiredService <
DbContextOptions <PeoplePro2Context> >()))
{
// Look for any buildings.
if (context.Department.Any())
{
return; // DB has been seeded
}
context.Department.AddRange(
new Department
{
Name = "Tech Services",
BuildingId = context.Building.Skip(0).FirstOrDefault().BuildingId
},
new Department
{
Name = "Cafeteria",
BuildingId = context.Building.Skip(1).FirstOrDefault().BuildingId
},
new Department
{
Name = "Human Resources",
BuildingId = context.Building.Skip(2).FirstOrDefault().BuildingId
},
new Department
{
Name = "Marketing",
BuildingId = context.Building.Skip(1).FirstOrDefault().BuildingId
},
new Department
{
Name = "Billing",
BuildingId = context.Building.Skip(2).FirstOrDefault().BuildingId
}
);
context.SaveChanges();
}
}
