Example #1
0
 public static void PrintEmployeInfoFast()
 {
     using (TelerikAcademyEntities dbContext = new TelerikAcademyEntities())
     {
         foreach (var employe in dbContext.Employees.Include("Department").Include("Address").Include("Address.Town"))
         {
             Console.WriteLine("Employe name: {0}", employe.FirstName);
             Console.WriteLine("Employe department name: {0}", employe.Department.Name);
             Console.WriteLine("Employe town name: {0}", employe.Address.Town.Name);
         }
     }
 }
Example #2
0
        public static void FastSelect()
        {
            using (TelerikAcademyEntities dbContext = new TelerikAcademyEntities())
            {
                List<Employee> sofiaEmployes = (from town in dbContext.Employees
                                                where town.Address.Town.Name == "Sofia"
                                                select town).ToList();

                foreach (var item in sofiaEmployes)
                {
                    Console.WriteLine(item.FirstName);
                }
            }
        }
Example #3
0
        public static void SlowSelect()
        {
            using (TelerikAcademyEntities dbContext = new TelerikAcademyEntities())
            {
                List<Employee> allEmplpyes = (from emp in dbContext.Employees select emp).ToList();
                List<Address> allAddreses = (from address in allEmplpyes select address.Address).ToList();
                List<Town> sofiaTowns = (from town in allAddreses select town.Town).ToList().Where(x => x.Name == "Sofia").ToList();

                foreach (var town in sofiaTowns)
                {
                    Console.WriteLine(town.Name);
                }
            }
        }