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(); }