コード例 #1
0
        public void GetDepartmentDetails(int deptid)
        {
            try
            {
                db = new TestEFEntities();
                var dept = (from d in db.Departments
                            where d.DeptId == deptid
                            select d).FirstOrDefault();

                Console.WriteLine("Department Name : " + dept.DeptName + " Department Head Id " + dept.EmployeeReference.EntityKey.EntityKeyValues.First().Value);
                //Console.WriteLine("Department Name : " + dept.DeptName + " Department Head Id ");// + dept.Employee.Empid);
            }
            catch (Exception)
            {
                Console.Write("Err");
            }
        }
コード例 #2
0
        public void GetDepartmentDetails()
        {
            try
            {
                db = new TestEFEntities();
                var dept = from d in db.Departments
                           select d;

                foreach (var dd in dept)
                {
                    Console.WriteLine("Department Name : " + dd.DeptName + " Department Head Id " + dd.EmployeeReference.EntityKey.EntityKeyValues.First().Value);
                }
                //Console.WriteLine("Department Name : " + dd.DeptName + " Department Head Id ");// + dd.Employee.Empid);
            }
            catch (Exception)
            {
                Console.Write("Err");
            }
        }