private static void Cleanup()
{
using (var context = new Recipe11Context())
{
context.Database.ExecuteSqlCommand("delete from chapter5.contractor");
context.Database.ExecuteSqlCommand("delete from chapter5.project");
context.Database.ExecuteSqlCommand("delete from chapter5.manager");
}
}
private static void RunExample()
{
using (var context = new Recipe11Context())
{
var man1 = new Manager {
Name = "Jill Stevens"
};
var proj = new Project {
Name = "City Riverfront Park", Manager = man1
};
var con1 = new Contractor {
Name = "Robert Alvert", Project = proj
};
var con2 = new Contractor {
Name = "Alan Jones", Project = proj
};
var con3 = new Contractor {
Name = "Nancy Roberts", Project = proj
};
context.Projects.Add(proj);
context.SaveChanges();
}
using (var context = new Recipe11Context())
{
var project = context.Projects.Include("Manager").First();
if (context.Entry(project).Reference(x => x.Manager).IsLoaded)
{
Console.WriteLine("Manager entity is loaded.");
}
else
{
Console.WriteLine("Manager entity is NOT loaded.");
}
if (context.Entry(project).Collection(x => x.Contractors).IsLoaded)
{
Console.WriteLine("Contractors are loaded.");
}
else
{
Console.WriteLine("Contractors are NOT loaded.");
}
Console.WriteLine("Calling project.Contractors.Load()...");
context.Entry(project).Collection(x => x.Contractors).Load();
if (context.Entry(project).Collection(x => x.Contractors).IsLoaded)
{
Console.WriteLine("Contractors are now loaded.");
}
else
{
Console.WriteLine("Contractors failed to load.");
}
}
Console.WriteLine("Press <enter> to continue...");
Console.ReadLine();
}