private static void EmployeesFromSofiaOptimized()
{
using (var db = new TelerikAcademyDb())
{
db.Employees.Count();
Stopwatch sw = new Stopwatch();
sw.Start();
var employeesFromSofia = db.Employees.Where(emp => emp.Address.Town.Name == "Sofia");
sw.Stop();
Console.WriteLine("Employees from Sofia: " + employeesFromSofia.Count());
Console.WriteLine("Time elapsed: " + sw.Elapsed);
}
}
private static void PrintEmployeesWithInclude()
{
using (var db = new TelerikAcademyDb())
{
db.Employees.Count();
Stopwatch sw = new Stopwatch();
sw.Start();
foreach (var employee in db.Employees.Include("Department").Include("Address"))
{
Console.WriteLine("Name: {0}; Dep: {1}; Town: {2}",
employee.FirstName, employee.Department.Name, employee.Address.Town.Name);
}
sw.Stop();
Console.WriteLine("Time elapsed: " + sw.Elapsed);
}
}
private static void EmployeesInvokingToListOnEachQuery()
{
using (var db = new TelerikAcademyDb())
{
db.Employees.Count();
Stopwatch sw = new Stopwatch();
sw.Start();
var employees = db.Employees.ToList();
var addresses = employees.Select(emp => emp.Address).ToList();
var towns = addresses.Select(adr => adr.Town).ToList();
var sofia = towns.Where(town => town.Name == "Sofia").ToList();
Console.WriteLine("Employees from Sofia: " + sofia.Count);
sw.Stop();
Console.WriteLine("Time elapsed: " + sw.Elapsed);
}
}
