LINQ JOIN

    class Department
    {
        //Auto-implemnted propeties
        public int Id { get; set; }
        public string Name { get; set; }
        public override string ToString()
        {
            return string.Format("{0}", Name);
        }
    }
    class Employee
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public string Title { get; set; }
        public int departmentId { get; set; }
        public override string ToString()
        {
            return string.Format("{0} {1}", Name, Title);
        }
    }
    class CorporateData
    {
        public static Department[] departments =
        {
            //Object initializers let you assign values to any accessible fields or properties of an object without having to exlicitly invoke a constructor
             new Department(){ Name = "FMS",Id = 1},
             new Department(){ Name = "MFE",Id =2},
             new Department(){ Name = "BI",Id = 3},
             new Department(){Name = "Detego",Id = 4}
        };
        public static Employee[] employees =
        {
            new Employee () {Id = 1,Name = "PerryDe",Title = "Test Leader",departmentId = 1},
            new Employee () {Id = 2,Name = "Steven Qi",Title = "SDE",departmentId = 1},
            new Employee () {Id = 3,Name = "Guo Hu",Title = "SDE",departmentId = 1},
            new Employee () {Id = 4,Name = "Shan Huo",Title = "SDE",departmentId = 2},
            new Employee () {Id = 5,Name = "Ming Hao",Title = "SDET",departmentId = 3},
            new Employee () {Id = 6,Name = "Xiao Yao",Title = "SDET",departmentId = 3}
        };

    }
    class Program
    {
        static void Main(string[] args)
        {
            IEnumerable<Department> departments = CorporateData.departments;
            Console.WriteLine("Department Name：");
            Print(departments);

            Console.WriteLine();
            IEnumerable<Employee> employees = CorporateData.employees;
            Console.WriteLine("Employee name and title：");
            Print(employees);

            Console.WriteLine();
            Console.WriteLine("Query employee informations using LINQ Join");

            var DepartmentEmployeeInfo = from employee in employees
                                         join department in departments on employee.departmentId equals department.Id
                                         select new
                                         {
                                             employeeName = employee.Name,
                                             employeeTitle = employee.Title,
                                             departmentName = department.Name
                                         };
            foreach (var employee in DepartmentEmployeeInfo)
            {
                Console.WriteLine("{0} {1} {2}", employee.employeeName, employee.employeeTitle, employee.departmentName);
            }
                                         
        }
        public static void Print<T>(IEnumerable<T> item)
        {
            foreach (T t in item)
            {
                Console.WriteLine(t);
            }
        }
    }