private static void LazyLoading()
{
using (var db = new CompanyContext())
{
var department = db.Departments;
Console.WriteLine("\r\n\r\n");
foreach (var dept in department)
{
Console.WriteLine("{0}", dept.DepartmentName);
foreach (var ci in dept.Employees)
Console.WriteLine(" {0} checked in at {1}", ci.EmployeeId, ci.Name);
}
}
}
private static void ExplicitLoading()
{
using (var db = new CompanyContext())
{
var department = db.Departments;
Console.WriteLine("\r\n\r\n");
foreach (var dept in department)
{
Console.WriteLine("{0}", dept.DepartmentName);
db.Entry(dept).Collection(x => x.Employees).Load();
foreach (var ci in dept.Employees)
Console.WriteLine(" {0} checked in at {1}", ci.EmployeeId, ci.Name);
}
}
}
private static void eagerlyLoading()
{
using (var db = new CompanyContext())
{
var q = from c in db.Departments
.Include("Employees")
select c;
Console.WriteLine(q.ToString());
Console.WriteLine("\r\n\r\n");
foreach (var dept in q)
{
Console.WriteLine("{0}", dept.DepartmentName);
foreach (var ci in dept.Employees)
Console.WriteLine(" {0} checked in at {1}", ci.EmployeeId, ci.Name);
}
}
}
