private static void SelectEmployeesUsingOptimization()
{
using (var context = new TelerikAcademyEntities())
{
Console.WriteLine("Employees:");
var employees =
from employee in context.Employees
join address in context.Addresses
on employee.AddressID equals address.AddressID
join town in context.Towns
on address.TownID equals town.TownID
where town.Name == "Sofia"
select employee;
foreach (var employee in employees)
{
Console.WriteLine(
"Name: {0} {1}\nAddress: {2}\nTown: {3}",
employee.FirstName,
employee.LastName,
employee.Address.AddressText,
employee.Address.Town.Name);
}
}
}
private static void SelectEmployeesUsingToList()
{
using (var context = new TelerikAcademyEntities())
{
Console.WriteLine("Employees:");
var employees = context.Employees.ToList()
.Select(e => new
{
FirstName = e.FirstName,
LastName = e.LastName,
Address = e.Address.AddressText,
TownName = e.Address.Town.Name
})
.ToList()
.Where(e => e.TownName == "Sofia")
.ToList();
foreach (var employee in employees)
{
Console.WriteLine(
"Name: {0} {1}\nAddress: {2}\nTown: {3}",
employee.FirstName,
employee.LastName,
employee.Address,
employee.TownName);
}
}
}
private static void SelectEmployeesNoInclude()
{
using (var context = new TelerikAcademyEntities())
{
Console.WriteLine("Employees:");
foreach (var employee in context.Employees)
{
Console.WriteLine(
"Name: {0} {1}\nDepartment: {2}\nTown: {3}",
employee.FirstName,
employee.LastName,
employee.Department.Name,
employee.Address.Town.Name);
}
}
}