Tuesday, June 7, 2016

LINQ - Perform Inner Join C#

This post show you how to do different Inner joins in C#
1) Simple inner join that join two elements using single key
class Employee
    {
        public string FirstName { get; set; }
        public string LastName { get; set; }
    }

    class EmployeeAddress
    {
        public string Address { get; set; }
        public Employee employee { get; set; }
    }
    class Program
    {
        /// <summary>
        /// Simple inner join.
        /// </summary>
        public static void InnerJoinExample()
        {
            Employee john = new Employee { FirstName = "John", LastName = "Clinton" };
            Employee serry = new Employee { FirstName = "Serry", LastName = "Bond" };


            EmployeeAddress johnAddress = new EmployeeAddress { Address = "1, abc, NJ-07027", employee = john };
            EmployeeAddress serryAddress = new EmployeeAddress { Address = "2, xyz, NJ-08110", employee = serry };


            // Create two lists.
            List<Employee> employees = new List<Employee> { john, serry };
            List<EmployeeAddress> employeeAddresses = new List<EmployeeAddress> { johnAddress, serryAddress };


            var query = from employee in employees
                        join employeeAddress in employeeAddresses on employee equals employeeAddress.employee
                        select new { EmployeeFirstName = employee.FirstName, EmployeeLastName = employee.LastName, EmployeeAddress = employeeAddress.Address };

            foreach (var item in query)
            {
                Console.WriteLine("Employee Name: {0} {1}  Address: {2} \n", item.EmployeeFirstName, item.EmployeeLastName, item.EmployeeAddress);
            }

        }

        static void Main(string[] args)
        {
            InnerJoinExample();
        }
        
    }

No comments:

Post a Comment