static void Main()
{
var telerikAcademyDb = new TelerikAcademyEntities();
using (telerikAcademyDb)
{
var employees = telerikAcademyDb.Employees;
var timer = new Stopwatch();
timer.Restart();
Slow(employees);
Console.WriteLine("Elapsed time {0}", timer.Elapsed);
//Fast(employees);
timer.Restart();
Fast(employees);
Console.WriteLine("Elapsed time {0}", timer.Elapsed);
timer.Stop();
}
}
static void Main()
{
using (var db = new TelerikAcademyEntities())
{
long time1 = 0;
long time2 = 0;
var sw = new Stopwatch();
sw.Start();
var firstWay = db.Employees.ToList().Select(e => e.Address).ToList().Select(e => e.Town).ToList().Where(e => e.Name == "Sofia");
time1 = sw.ElapsedMilliseconds;
sw.Restart();
var secondWay = db.Employees.Where(e => e.Address.Town.Name == "Sofia").ToList();
time2 = sw.ElapsedMilliseconds;
Console.WriteLine("Outcome:");
Console.WriteLine("First way made 969 queries and took {0} miliseconds", time1);
Console.WriteLine("Second way made only 1 queries and took {0} miliseconds", time2);
}
}
