using System;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public static void Main()

    {

        /* 

            Consider below properties Employees and Departments and get list of employees in Hyderabad and "DotNet" department using joins.

        */

        var empInfo = (from emp in Employees

                       join dep in Departments 

                       on new {emp.FirstName,emp.LastName} equals new {dep.FirstName,dep.LastName}

                       where emp.Location == "Hyderabad" && dep.DepartmentName == "DotNet"

                      select new

                       {

                           emp.FirstName, 

                           emp.LastName,

                           emp.Location,

                           dep.DepartmentName

                       }).ToList(); 

        foreach(var item in empInfo)

        {

             Console.WriteLine(item);

        }

        /// select emp.FirstName, emp.LastName,emp.Location,dep.DepartmentName from Employees  as emp

        /// inner join Departments as dep on emp.FirstName = dep.FirstName and 

        //emp.LastName = dep.LastName where emp.Location = "Hyderabad" && dep.DepartmentName = "DotNet" 

    }

    public static List<Employee> Employees

    {

        get

        {

            return  new List<Employee>() 

            {

                new Employee() { FirstName = "Anil", LastName = "Vemula", Location = "Hyderabad"},

                new Employee() { FirstName = "Kedarnath", LastName = "Kulakarni", Location = "Banglore"},

                new Employee() { FirstName = "Prasad", LastName = "Aripaka", Location = "Hyderabad"}                                                                  

            };

        }

    }

    public static List<Department> Departments

    {

        get

        {

            return  new List<Department>() 

            {

                new Department() { FirstName = "Anil", LastName = "Vemula", DepartmentName = "DBA"},

                new Department() { FirstName = "Kedarnath", LastName = "Kulakarni", DepartmentName = "DotNet"},

                new Department() { FirstName = "Prasad", LastName = "Aripaka", DepartmentName = "DotNet"}                                                                 

            };

        }       

    }

    public class Employee

    {   

        public string FirstName { get; set; }

        public string LastName {get; set; }

        public string Location { get; set; }

    }

    public class Department

    {   

        public string FirstName { get; set; }

        public string LastName {get; set; }

        public string DepartmentName { get; set; }

    }

}