private void LoadData()
{
using (var context = new Chapter3Context())
{
// add new test data
Response.Write("Adding Test Data<br />");
Response.Write("=========\n<br />");
var assoc1 = new Associate { Name = "Janis Roberts" };
var assoc2 = new Associate { Name = "Kevin Hodges" };
var assoc3 = new Associate { Name = "Bill Jordan" };
var salary1 = new AssociateSalary
{
Salary = 39500M,
SalaryDate = DateTime.Parse("8/4/09")
};
var salary2 = new AssociateSalary
{
Salary = 41900M,
SalaryDate = DateTime.Parse("2/5/10")
};
var salary3 = new AssociateSalary
{
Salary = 33500M,
SalaryDate = DateTime.Parse("10/08/09")
};
assoc1.AssociateSalaries.Add(salary1);
assoc2.AssociateSalaries.Add(salary2);
assoc3.AssociateSalaries.Add(salary3);
context.Associates.Add(assoc1);
context.Associates.Add(assoc2);
context.Associates.Add(assoc3);
context.SaveChanges();
}
}
private void Cleanup()
{
using (var context = new Chapter3Context())
{
// delete previous test data
Response.Write("Cleaning Up Previous Test Data<br />");
Response.Write("=========<br />");
context.Database.ExecuteSqlCommand("delete from AssociateSalary");
context.Database.ExecuteSqlCommand("delete from Associate");
}
}
private void RunSingleOrDefaultExampe()
{
using (var context = new Chapter3Context())
{
Response.Write("\n\nSingleOrDefault Call<br />");
Response.Write("=========<br />");
var associate = context.Associates.Include(x => x.AssociateSalaries).OrderBy(x => x.Name).FirstOrDefault(y => y.Name == "Kevin Hodges");
Response.Write(string.Format("Here are the salaries for Associate {0}:<br />", associate.Name));
foreach (var salaryInfo in associate.AssociateSalaries)
{
Response.Write(string.Format("\t{0}<br />", salaryInfo.Salary));
}
}
}
//private void RunForEachExample()
//{
// using (var context = new Chapter3Context())
// {
// Response.Write("ForEach Call<br />");
// Response.Write("=========<br />");
// context.Associates.Include(x => x.AssociateSalaries).ForEachAsync(x =>
// {
// Response.Write(string.Format("Here are the salaries for Associate {0}:<br />", x.Name));
// foreach (var salary in x.AssociateSalaries)
// {
// Response.Write(string.Format("\t{0}<br />", salary.Salary));
// }
// });
// }
//}
private void RunToListExampe()
{
using (var context = new Chapter3Context())
{
Response.Write("\n\nRunToList Call<br />");
Response.Write("=========<br />");
var associates = context.Associates.Include(x => x.AssociateSalaries).OrderBy(x => x.Name);
foreach (var associate in associates)
{
Response.Write(string.Format("Here are the salaries for Associate {0}:<br />", associate.Name));
foreach (var salaryInfo in associate.AssociateSalaries)
{
Response.Write(string.Format("\t{0}<br />", salaryInfo.Salary));
}
}
}
}
