private static void Case1(EmpDbContext context) { Department department = new Department(); Employee employee = new Employee(); context.EMP.Add(employee); context.DEPT.Add(department); }
static void Main(string[] args) { EmpDbContext context = new EmpDbContext(); //Case1(context);\ //var displayAllEmpInAsc = context.EMP.Select(e => e).OrderBy(e => e.EName).ToList(); //foreach(var e in displayAllEmpInAsc) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}",e.Id,e.EName,e.Designation,e.MGR,e.HireDate,e.Salary,e.Commision,e.DeptId); //} //var displayEmpNameInLower = context.EMP.Select(e => e.EName.ToLower()).ToList(); //foreach(var e in displayEmpNameInLower) //{ // Console.WriteLine("{0}",e.ToLower()); //} //var displayNameSalaryCommision = context.EMP.Select(e => new //{ // name = e.EName, // salary = e.Salary, // comm = e.Commision //}).ToList(); //foreach(var e in displayNameSalaryCommision) //{ // Console.WriteLine("{0}, {1}, {2}",e.name,e.salary,e.comm); //} //var displaySpecificEmployee = context.EMP.Where(e => e.DeptId == 10).ToList(); //foreach (var e in displaySpecificEmployee) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", e.Id, // e.EName, e.Designation, e.MGR, e.HireDate, e.Salary, e.Commision, e.DeptId); //} //var displayEmpCommNull = context.EMP.Where(e => e.Commision == null).ToList(); //foreach (var e in displayEmpCommNull) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", e.Id, // e.EName, e.Designation, e.MGR, e.HireDate, e.Salary, e.Commision, e.DeptId); //} //var displayNameSalaryAnnsal = context.EMP.Select(e => new //{ // name = e.EName, // salary = e.Salary, // annualSalary = e.Salary * 12 + (e.Commision ?? 0) * 12 //}).ToList(); //foreach (var e in displayNameSalaryAnnsal) //{ // Console.WriteLine("{0}, {1}, {2}",e.name,e.salary,e.annualSalary); //} //var displayDeptEmployee = context.EMP.Where(e => e.DeptId == 20 || e.DeptId == 10).ToList(); //foreach (var e in displayDeptEmployee) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", e.Id, // e.EName, e.Designation, e.MGR, e.HireDate, e.Salary, e.Commision, e.DeptId); //} //var displayEmployeeScott = context.EMP.Where(e => e.EName == "SCOTT").ToList(); //foreach (var e in displayEmployeeScott) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", e.Id, // e.EName, e.Designation, e.MGR, e.HireDate, e.Salary, e.Commision, e.DeptId); //} //var displayTop3EarningEmployee = context.EMP.OrderByDescending(e => e.Salary * 12 + (e.Commision ?? 0) * 12).Take(3) // .ToList(); //foreach (var e in displayTop3EarningEmployee) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", e.Id, // e.EName, e.Designation, e.MGR, e.HireDate, e.Salary, e.Commision, e.DeptId); //} //var displayYearsOfWorking = context.EMP.Select(e => new //{ // id = e.Id, // name = e.EName, // desi = e.Designation, // mgr = e.MGR, // hiredate = e.HireDate, // salary = e.Salary, // comm = e.Commision, // deptNo = e.DeptId, // workingYears = DateTime.Today.Year - e.HireDate.Year //}).ToList(); //foreach (var e in displayYearsOfWorking) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}", e.id, // e.name, e.desi, e.mgr, e.hiredate, e.salary, e.comm, e.deptNo, e.workingYears); //} //var displayEmployeeContainS = context.EMP.Where(e => e.EName.Contains("s".ToUpper())).ToList(); //foreach (var e in displayEmployeeContainS) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", e.Id, // e.EName, e.Designation, e.MGR, e.HireDate, e.Salary, e.Commision, e.DeptId); //} //var displayEmployeesStartWithA = context.EMP.Where(e => e.EName.StartsWith("a".ToUpper())).ToList(); //foreach (var e in displayEmployeesStartWithA) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", e.Id, // e.EName, e.Designation, e.MGR, e.HireDate, e.Salary, e.Commision, e.DeptId); //} //var displayEmployeeEndWithN = context.EMP.Where(e => e.EName.EndsWith("n".ToUpper())).ToList(); //foreach (var e in displayEmployeeEndWithN) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", e.Id, // e.EName, e.Designation, e.MGR, e.HireDate, e.Salary, e.Commision, e.DeptId); //} //var displayDepartmentINAscanding = context.EMP.OrderBy(n => n.DeptId).ToList(); //foreach (var e in displayDepartmentINAscanding) //{ // Console.WriteLine("{0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}", e.Id, // e.EName, e.Designation, e.MGR, e.HireDate, e.Salary, e.Commision, e.DeptId); //} //var displayUniqueDepartment = context.EMP.Select(e => new { num = e.DeptId }) // .Distinct().OrderBy(e => e.num); //foreach (var e in displayUniqueDepartment) //{ // Console.WriteLine(e.num); //} //var displayDateFormat = context.EMP.Select(e => new //{ // date = e.HireDate //}).ToList(); //foreach (var e in displayDateFormat) //{ // Console.WriteLine(e.date); //} //var numberOFEmployees = context.EMP.ToList().Count(); //Console.WriteLine(numberOFEmployees); //var displayNoEmployeesInDept = context.EMP.Where(e => e.DeptId == 10).ToList().Count(); //Console.WriteLine(displayNoEmployeesInDept); //var sumOfTotalSalary = context.EMP.ToList().Sum(e => e.Salary); //Console.WriteLine(sumOfTotalSalary); //var displayEmployeeNameDeptName = (from emp in context.EMP // join dept in context.DEPT // on emp.DeptId equals dept.Id // orderby emp.DeptId // select new // { emp.EName, dept.DName }).ToList(); //foreach (var detail in displayEmployeeNameDeptName) //{ // Console.WriteLine(detail.EName + "," + detail.DName); //} //var diplayAllDepartments = (from dept in context.DEPT // join emp in context.EMP // on dept.Id equals emp.DeptId // select new { dept.DName, emp.EName }).ToList(); //foreach (var detail in diplayAllDepartments) //{ // Console.WriteLine(detail.DName + "," + detail.EName); //} var displayEmpNameBossName = (from emp in context.EMP let Boss = emp.EName let Emp = emp.EName let BossId = emp.Id let EmpId = emp.MGR where BossId == EmpId select new { Boss, Emp }).ToList(); foreach (var detail in displayEmpNameBossName) { Console.WriteLine(detail.Boss + "," + detail.Emp); } }