private static void InsertAndUpdateWithDecimals(
decimal insertValue, decimal insertExpected, decimal updateValue, decimal updateExpected)
{
ExtendedSqlAzureExecutionStrategy.ExecuteNew(
() =>
{
using (new TransactionScope())
{
using (var context = new ArubaContext())
{
// Insert
var allTypes = context.AllTypes.Add(CreateArubaAllTypes(insertValue));
context.SaveChanges();
ValidateSavedValues(context, allTypes, insertExpected);
// Update
UpdateArubaAllTypes(allTypes, updateValue);
context.SaveChanges();
ValidateSavedValues(context, allTypes, updateExpected);
}
}
});
}
private void InitializeAndPersistPeople(ArubaContext context)
{
var grandFather = new ArubaPerson
{
Name = "GrandFather",
Children = new List<ArubaPerson>(),
};
var mother = new ArubaPerson
{
Name = "Mother",
Children = new List<ArubaPerson>(),
Parents = new List<ArubaPerson> { grandFather },
};
grandFather.Children.Add(mother);
var father = new ArubaPerson
{
Name = "Father",
Children = new List<ArubaPerson>(),
};
mother.Partner = father;
var child = new ArubaPerson
{
Name = "Child",
Parents = new List<ArubaPerson> { mother, father }
};
mother.Children.Add(child);
father.Children.Add(child);
var childOfSingleMother = new ArubaPerson
{
Name = "Child",
};
var singleMother = new ArubaPerson
{
Name = "Single Mother",
Children = new List<ArubaPerson> { childOfSingleMother },
};
childOfSingleMother.Parents = new List<ArubaPerson> { singleMother };
var childOfDivorcedParents = new ArubaPerson
{
Name = "Child",
};
var divorcedFather = new ArubaPerson
{
Name = "Divorced Father",
Children = new List<ArubaPerson> { childOfDivorcedParents },
};
var divorcedMother = new ArubaPerson
{
Name = "Divorced Mother",
Children = new List<ArubaPerson> { childOfDivorcedParents },
};
childOfDivorcedParents.Parents = new List<ArubaPerson> { divorcedFather, divorcedMother };
var bachelor = new ArubaPerson
{
Name = "Bachelor",
};
context.People.Add(bachelor);
context.People.Add(divorcedFather);
context.People.Add(divorcedMother);
context.People.Add(singleMother);
context.People.Add(grandFather);
context.SaveChanges();
}
public void Seed(ArubaContext context)
{
var allTypes = InitializeAllTypes();
var bugs = InitializeBugs();
var configs = InitializeConfigs();
var failures = InitializeFailures();
var owners = InitializeOwners();
var runs = InitializeRuns();
var tasks = InitializeTasks();
InitializeAndPersistPeople(context);
for (var i = 0; i < EntitiesCount; i++)
{
bugs[i].Failure = failures[i % 4];
failures[i % 4].Bugs.Add(bugs[i]);
}
for (var i = 0; i < EntitiesCount; i++)
{
for (var j = 0; j < i % 3; j++)
{
configs[i].Failures.Add(failures[(i + j) % EntitiesCount]);
}
}
for (var i = 0; i < EntitiesCount; i++)
{
for (var j = 0; j < i % 2; j++)
{
failures[i].Configs.Add(configs[(i + j) % EntitiesCount]);
}
}
for (var i = 0; i < EntitiesCount; i++)
{
owners[i].OwnedRun = runs[i];
for (var j = 0; j < 5; j++)
{
owners[i].Bugs.Add(bugs[(i + j) % EntitiesCount]);
}
}
for (var i = 0; i < EntitiesCount; i++)
{
runs[i].RunOwner = owners[i];
for (var j = 0; j < 3; j++)
{
runs[i].Tasks.Add(tasks[(i + j) % EntitiesCount]);
}
}
for (int i = 0; i < EntitiesCount; i++)
{
context.AllTypes.Add(allTypes[i]);
context.Bugs.Add(bugs[i]);
context.Configs.Add(configs[i]);
context.Failures.Add(failures[i]);
context.Owners.Add(owners[i]);
context.Runs.Add(runs[i]);
context.Tasks.Add(tasks[i]);
}
context.SaveChanges();
}
private static void InsertAndUpdateWithDecimals(
decimal insertValue, decimal insertExpected, decimal updateValue, decimal updateExpected)
{
using (var context = new ArubaContext())
{
// Insert
var allTypes = context.AllTypes.Add(CreateArubaAllTypes(insertValue));
context.SaveChanges();
ValidateSavedValues(context, allTypes, insertExpected);
// Update
UpdateArubaAllTypes(allTypes, updateValue);
context.SaveChanges();
ValidateSavedValues(context, allTypes, updateExpected);
}
}
private void InitializeAndPersistPeople(ArubaContext context)
{
var grandFather = new ArubaPerson
{
Name = "GrandFather",
Children = new List <ArubaPerson>(),
};
var mother = new ArubaPerson
{
Name = "Mother",
Children = new List <ArubaPerson>(),
Parents = new List <ArubaPerson> {
grandFather
},
};
grandFather.Children.Add(mother);
var father = new ArubaPerson
{
Name = "Father",
Children = new List <ArubaPerson>(),
};
mother.Partner = father;
var child = new ArubaPerson
{
Name = "Child",
Parents = new List <ArubaPerson> {
mother, father
}
};
mother.Children.Add(child);
father.Children.Add(child);
var childOfSingleMother = new ArubaPerson
{
Name = "Child",
};
var singleMother = new ArubaPerson
{
Name = "Single Mother",
Children = new List <ArubaPerson> {
childOfSingleMother
},
};
childOfSingleMother.Parents = new List <ArubaPerson> {
singleMother
};
var childOfDivorcedParents = new ArubaPerson
{
Name = "Child",
};
var divorcedFather = new ArubaPerson
{
Name = "Divorced Father",
Children = new List <ArubaPerson> {
childOfDivorcedParents
},
};
var divorcedMother = new ArubaPerson
{
Name = "Divorced Mother",
Children = new List <ArubaPerson> {
childOfDivorcedParents
},
};
childOfDivorcedParents.Parents = new List <ArubaPerson> {
divorcedFather, divorcedMother
};
var bachelor = new ArubaPerson
{
Name = "Bachelor",
};
context.People.Add(bachelor);
context.People.Add(divorcedFather);
context.People.Add(divorcedMother);
context.People.Add(singleMother);
context.People.Add(grandFather);
context.SaveChanges();
}
public void Seed(ArubaContext context)
{
var allTypes = InitializeAllTypes();
var bugs = InitializeBugs();
var configs = InitializeConfigs();
var failures = InitializeFailures();
var owners = InitializeOwners();
var runs = InitializeRuns();
var tasks = InitializeTasks();
InitializeAndPersistPeople(context);
for (var i = 0; i < EntitiesCount; i++)
{
bugs[i].Failure = failures[i % 4];
failures[i % 4].Bugs.Add(bugs[i]);
}
for (var i = 0; i < EntitiesCount; i++)
{
for (var j = 0; j < i % 3; j++)
{
configs[i].Failures.Add(failures[(i + j) % EntitiesCount]);
}
}
for (var i = 0; i < EntitiesCount; i++)
{
for (var j = 0; j < i % 2; j++)
{
failures[i].Configs.Add(configs[(i + j) % EntitiesCount]);
}
}
for (var i = 0; i < EntitiesCount; i++)
{
owners[i].OwnedRun = runs[i];
for (var j = 0; j < 5; j++)
{
owners[i].Bugs.Add(bugs[(i + j) % EntitiesCount]);
}
}
for (var i = 0; i < EntitiesCount; i++)
{
runs[i].RunOwner = owners[i];
for (var j = 0; j < 3; j++)
{
runs[i].Tasks.Add(tasks[(i + j) % EntitiesCount]);
}
}
for (int i = 0; i < EntitiesCount; i++)
{
context.AllTypes.Add(allTypes[i]);
context.Bugs.Add(bugs[i]);
context.Configs.Add(configs[i]);
context.Failures.Add(failures[i]);
context.Owners.Add(owners[i]);
context.Runs.Add(runs[i]);
context.Tasks.Add(tasks[i]);
}
context.SaveChanges();
}
