static void Main()
{
var context = new SoftUniEntities();
var employees = context.Employees
.Where(e => e.Department.Name == "Research and Development")
.OrderBy(e => e.Salary)
.ThenByDescending(e => e.FirstName)
.Select(e => new
{
e.FirstName,
e.LastName,
Department = e.Department.Name,
e.Salary
}
);
foreach (var employee in employees)
{
Console.WriteLine("{0} {1}, {2}, {3}",
employee.FirstName,
employee.LastName,
employee.Department,
employee.Salary);
}
}
static void Main()
{
var context = new SoftUniEntities();
var employeeNames = context.Employees
.Where(e => e.Salary > 50000)
.Select(e => e.FirstName);
foreach (var employeeFirstName in employeeNames)
{
Console.WriteLine(employeeFirstName);
}
}
static void Main()
{
var context = new SoftUniEntities();
var project = context.Projects.Find(2);
var projectEmployees = project.Employees;
foreach (var projectEmployee in projectEmployees)
{
projectEmployee.Projects.Remove(project);
}
context.Projects.Remove(project);
context.SaveChanges();
}
static void Main()
{
var context = new SoftUniEntities();
var address = new Address()
{
AddressText = "Vitoshka 15",
TownID = 4
};
Employee employee = context.Employees.FirstOrDefault(e => e.LastName == "Nakov");
employee.Address = address;
context.SaveChanges();
}
