using System.Collections.Generic;
public static void Main()
List<Dept> newdept=new List<Dept>
new Dept{ID=1,DeptName="HR"},
new Dept{ID=2,DeptName="Account"},
new Dept{ID=3,DeptName="Eng"},
new Dept{ID=4,DeptName="Testing"},
new Dept{ID=5,DeptName="Houseskip"},
List<Employee> newemp=new List<Employee>
new Employee{ID=1,Name="Pinaki",DEPTID=1},
new Employee{ID=2,Name="Rajat",DEPTID=1},
new Employee{ID=3,Name="Loni",DEPTID=2},
new Employee{ID=4,Name="Mona",DEPTID=5},
new Employee{ID=5,Name="Bapi",DEPTID=4},
new Employee{ID=6,Name="Rintu",DEPTID=3},
new Employee{ID=7,Name="Bunty",DEPTID=4},
new Employee{ID=8,Name="Testemp"},
List<Salary> newsalary=new List<Salary>
new Salary{EmpID=1,Amount=50000},
new Salary{EmpID=2,Amount=55000},
new Salary{EmpID=3,Amount=10000},
new Salary{EmpID=4,Amount=60000},
new Salary{EmpID=5,Amount=20000},
new Salary{EmpID=6,Amount=30000},
new Salary{EmpID=7,Amount=40000},
var innerjoin=from e in newemp
join d in newdept on e.DEPTID equals d.ID
join s in newsalary on e.ID equals s.EmpID
foreach(var emp in innerjoin)
Console.WriteLine($"Empname:{emp.Empname},Deptname:{emp.Deptname},Salary:{emp.Salary}");
public string Name{get;set;}
public int DEPTID{get;set;}
public string DeptName{get;set;}
public int EmpID{get;set;}
public int Amount{get;set;}