इनर जॉइन केवल उन रिकॉर्ड या पंक्तियों को लौटाता है जो दोनों तालिकाओं से मेल खाते हैं या मौजूद हैं। हम नीचे दिखाए गए शर्तों के आधार पर कई तालिकाओं में शामिल होने के लिए भी आवेदन कर सकते हैं। यदि हमें कई शर्तों पर शामिल होने के लिए आवेदन करने की आवश्यकता है तो अनाम प्रकारों का उपयोग करें।
नीचे दिए गए उदाहरण में हमने 2 तरीके लिखे हैं जिनका उपयोग लिंक में शामिल होने के लिए किया जा सकता है यहां विभाग और कर्मचारी शामिल हो गए हैं
उदाहरण
class Program{
static void Main(string[] args){
var result =
Employee.GetAllEmployees().Join(Department.GetAllDepartments(),
e => e.DepartmentID,
d => d.ID, (employee, department) => new{
EmployeeName = employee.Name,
DepartmentName = department.Name
});
foreach (var employee in result){
Console.WriteLine(employee.EmployeeName + "\t" +
employee.DepartmentName);
}
var result1 = from e in Employee.GetAllEmployees()
join d in Department.GetAllDepartments()
on e.DepartmentID equals d.ID
select new{
EmployeeName = e.Name,
DepartmentName = d.Name
};
foreach (var employee in result1){
Console.WriteLine(employee.EmployeeName + "\t" +
employee.DepartmentName);
}
Console.ReadLine();
}
}
public class Employee{
public int ID { get; set; }
public string Name { get; set; }
public int DepartmentID { get; set; }
public static List<Employee> GetAllEmployees(){
return new List<Employee>(){
new Employee { ID = 1, Name = "A", DepartmentID = 1 },
new Employee { ID = 2, Name = "B", DepartmentID = 2 },
new Employee { ID = 3, Name = "B", DepartmentID = 1 },
new Employee { ID = 4, Name = "V", DepartmentID = 1 },
new Employee { ID = 5, Name = "F", DepartmentID = 2 },
new Employee { ID = 6, Name = "R", DepartmentID = 2 },
new Employee { ID = 7, Name = "TT", DepartmentID = 1 },
new Employee { ID = 8, Name = "YY", DepartmentID = 1 },
new Employee { ID = 9, Name = "WW", DepartmentID = 2 },
new Employee { ID = 10, Name = "QQ"}
};
}
}
public class Department{
public int ID { get; set; }
public string Name { get; set; }
public static List<Department> GetAllDepartments(){
return new List<Department>(){
new Department { ID = 1, Name = "IT"},
new Department { ID = 2, Name = "HR"},
new Department { ID = 3, Name = "Contract"},
};
}
} आउटपुट
A IT B HR B IT V IT F HR R HR TT IT YY IT WW HR A IT B HR B IT V IT F HR R HR TT IT YY IT WW HR