This post show you how to do different Inner joins in C#
1) Simple inner join that join two elements using single key
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