using
System;
using
System.Linq;
using
System.Collections.Generic;
public
class
Employee {
public
int
emp_id
{
get
;
set
;
}
public
string
emp_name
{
get
;
set
;
}
public
string
emp_lang
{
get
;
set
;
}
public
int
dpt_id
{
get
;
set
;
}
}
public
class
Department {
public
int
dpt_id
{
get
;
set
;
}
public
string
emp_dept
{
get
;
set
;
}
}
class
GFG {
static
public
void
Main()
{
List<Employee> emp =
new
List<Employee>() {
new
Employee() { emp_id = 101, emp_name =
"Amit"
,
emp_lang =
"Java"
, dpt_id = 1 },
new
Employee() { emp_id = 102, emp_name =
"Mohit"
,
emp_lang =
"C#"
, dpt_id = 2 },
new
Employee() { emp_id = 103, emp_name =
"Sona"
,
emp_lang =
"Java"
, dpt_id = 1 },
new
Employee() { emp_id = 104, emp_name =
"Lana"
,
emp_lang =
"C++"
, dpt_id = 3 },
new
Employee() { emp_id = 105, emp_name =
"Roma"
,
emp_lang =
"C#"
, dpt_id = 2 },
};
List<Department> Dpt =
new
List<Department>() {
new
Department() { dpt_id = 1, emp_dept =
"Designing"
},
new
Department() { dpt_id = 2, emp_dept =
"Development"
},
new
Department() { dpt_id = 3, emp_dept =
"JE"
},
};
var
res =
from
first
in
emp
from
second
in
Dpt
select
new
{
Employee_name = first.emp_name,
Department_name = second.emp_dept
};
foreach
(
var
val
in
res)
{
Console.WriteLine(
" Employee Name: {0} || Department Name: {1}"
,
val.Employee_name, val.Department_name);
}
}
}