public void DeleteDepartment(int departmentId) { using (Training2020DbContext context = new Training2020DbContext()) { var department = context.Departments.Where(d => d.DepartmentId == departmentId).FirstOrDefault(); if (department != null) { context.Departments.Remove(department); context.SaveChanges(); } } }
public void ListDepartments() { using (Training2020DbContext context = new Training2020DbContext()) { var departments = context.Departments; foreach (var department in departments) { Console.WriteLine(department.DepartmentId + " | " + department.Name); } } }
public void List() { using (Training2020DbContext context = new Training2020DbContext()) { var employees = context.Employees.Where(d => d.Name.StartsWith("S")); foreach (var employee in employees) { Console.WriteLine(employee.AutoId + " | " + employee.Name + " | " + employee.Location); } } }
public void AddDepartment(string departmentName) { using (Training2020DbContext context = new Training2020DbContext()) { Department department = new Department() { Name = departmentName }; context.Departments.Add(department); context.SaveChanges(); } }
public void UpdateDepartment(int departmentId, string newDepartmentName) { using (Training2020DbContext context = new Training2020DbContext()) { //var department = context.Departments.Find(departmentId); var department = context.Departments.Where(d => d.DepartmentId == departmentId).FirstOrDefault(); if (department != null) { department.Name = newDepartmentName; context.Entry(department).State = Microsoft.EntityFrameworkCore.EntityState.Modified; context.SaveChanges(); } } }
public void ListWithJoins() { using (Training2020DbContext context = new Training2020DbContext()) { var data = from employee in context.Employees join department in context.Departments on employee.DepartmentId equals department.DepartmentId select new { EmpId = employee.EmpId, EmployeeName = employee.Name, DepartmentName = department.Name }; foreach (var item in data) { Console.WriteLine(item.EmpId + " | " + item.EmployeeName + " | " + item.DepartmentName); } } }