private static void ImportData(SpDataContext spContext, bool clear)
{
if (clear)
{
//delete all items.
while (spContext.List <Department>().Take(100).DeleteAll())
{
spContext.SaveChanges();
}
while (spContext.List <Employee>().Take(100).DeleteAll())
{
spContext.SaveChanges();
}
}
//var dep = spContext.List<Department>().GetEntries().First().Entity;
//dep.Title = "Warner Brothers";
var department = spContext.List <Department>().AddOrUpdate(new Department()
{
Title = "Warner Brothers",
ShortName = "WB"
}, 1, true);
spContext.SaveChanges();
//department = spContext.List<Department>().AddOrUpdate(dep);
//spContext.SaveChanges();
var manager = spContext.List <Employee>().AddOrUpdate(new Employee()
{
FirstName = "Emma",
LastName = "Stone",
Phone = "8-1111-999",
Email = "*****@*****.**",
Position = EmployeePosition.Manager | EmployeePosition.Specialist
}, 1, true);
// save lookups
spContext.SaveChanges();
var specialist = new Employee()
{
FirstName = "Will",
LastName = "Smith",
Phone = "7-1143-222",
Email = "*****@*****.**",
Position = EmployeePosition.Specialist
};
specialist.DepartmentLookup.SetEntity(department.Entity);
specialist.ManagerLookup.SetEntities(new[] { manager.Entity });
var entry = spContext.List <Employee>().AddOrUpdate(specialist, 2, true, true);
spContext.SaveChanges();
}
private static void ImportData(SpDataContext spContext, bool clear)
{
if (clear)
{
//delete all items.
while (spContext.List <Department>().Take(100).DeleteAll())
{
spContext.SaveChanges();
}
while (spContext.List <Employee>().Take(100).DeleteAll())
{
spContext.SaveChanges();
}
}
spContext.List <Department>().AddOrUpdate(new Department()
{
Title = "Warner Brothers"
}, 1);
spContext.List <Employee>().AddOrUpdate(new Employee()
{
FirstName = "Emma",
LastName = "Stone",
Phone = "11-1111-111",
Email = "*****@*****.**",
Position = EmployeePosition.Manager
}, 1);
var specialist = new Employee()
{
FirstName = "Will",
LastName = "Smith",
Phone = "11-1143-222",
Email = "*****@*****.**",
Position = EmployeePosition.Specialist,
DepartmentId = 1
};
specialist.Manager.EntityId = 1;
//specialist.Department.EntityId = 1;
spContext.List <Employee>().AddOrUpdate(specialist, 2);
spContext.SaveChanges();
}
