Join two list using lambda expression

 List<Employee> employees = new List<Employee>()
            {
                new Employee(){ id="1", name= "Vivek"},
                 new Employee(){ id="2", name= "Chanthu"}
            };

            List<Address> address = new List<Address>()
            {
                new Address(){ Empid="1", Addres= "Eleyodu"},
                new Address(){ Empid="2", Addres= "Edakkadom"}
            };

            var query = employees.Join(
                address,
                emp => emp.id,
                adrs => adrs.Empid,
                (emp, adrs) => new { EmployeeName = emp, EmployeAddress = adrs })
                .Where(EmployeeAndAddress => EmployeeAndAddress.EmployeeName.id == EmployeeAndAddress.EmployeAddress.Empid).ToList();

            foreach (var item in query)
            {
                Console.WriteLine("Employee Name:{0},Address:{1}", item.EmployeeName.name, item.EmployeAddress.Addres);
            }

class Employee
        {
            public string id;
            public string name;
            public string department;
        }
        class Address
        {
            public string Empid;
            public string Addres;
        }

Advertisements