Querying an Entity Data Model - Entity Framework 6 Recipes - page 58

private static async Task Cleanup()
{
using (var context = new EFRecipesEntities())
{
// delete previous test data
// execute raw sql statement asynchronoulsy
Console.WriteLine("Cleaning Up Previous Test Data");
Console.WriteLine("=========\n");
await context.Database.ExecuteSqlCommandAsync("delete from chapter3.AssociateSalary");
await context.Database.ExecuteSqlCommandAsync("delete from chapter3.Associate");
await Task.Delay(5000);
}
}
private static async Task LoadData()
{
using (var context = new EFRecipesEntities())
{
// add new test data
Console.WriteLine("Adding Test Data");
Console.WriteLine("=========\n");
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);
// update datastore asynchronoulsy
await context.SaveChangesAsync();
await Task.Delay(5000);
}
}