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); } } }