using System;

using System.Linq;

using System.Collections.Generic;

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

        List<Employee> employees = new List<Employee>() {

new Employee() {

FirstName = "John", LastName = "Smith", City = "Havertown", State = "PA"

    },

new Employee() {

FirstName = "Jane", LastName = "Doe", City = "Ewing", State = "NJ"

},

new Employee() {

FirstName = "Jack", LastName = "Jones",

City = "Fort Washington", State = "PA"

} };

    List<Hometown> hometowns = new List<Hometown>() {

new Hometown() {

City = "Havertown", State = "PA", CityCode = "1234"

},

new Hometown() {

City = "Ewing", State = "NJ", CityCode = "5678"

},

new Hometown() {

City = "Fort Washington", State = "PA",

CityCode = "9012"

} };

        //Composite Key

        var result = from e in employees

                     join s in hometowns

                     on new {e.City,e.State} equals new {s.City,s.State}

        select new {e.LastName,s.CityCode};

        foreach(var n in result)

        {

            Console.WriteLine(n.LastName + ", " + n.CityCode);

    }

}

public class Hometown {

public string City { get; set; } public string State { get; set; } public string CityCode { get; set; }

}

public class Employee {

public string FirstName { get; set; } public string LastName { get; set; } public string City { get; set; } public string State { get; set; }

}

}