LinqJoins 1.0.0

This library can help you to do easy Left Join/Right Join/FullJoin/NotMatchedJoin. following is an example.

using LinqJoins;

List<Data> lstData = new(){ new Data{ Id = 1, Name="Abhay"} , new Data{ Id = 2,Name="Amy"} };

List<Data> lstData2 = new(){ new Data{ Id = 1, Name="Abhay"} , new Data{ Id = 3,Name="Aavya"} , new Data{ Id = 4,Name="Amruta"} , };

Console.WriteLine("Right Join"); var output=lstData.RightJoin(lstData2,x=>x.Id,y=>y.Id,(x,y)=>new {RightId=x?.Id,RightName=x?.Name,LeftName=y?.Name,LeftId=y?.Id}); foreach (var item in output) { Console.WriteLine($"{item.RightId} - {item.RightName} - {item.LeftId} - {item.LeftName}"); }

Console.WriteLine("Left Join"); var output2 = lstData.LeftJoin(lstData2, x ⇒ x.Id, y ⇒ y.Id, (x, y) ⇒ new { RightId = x?.Id, RightName = x?.Name, LeftName = y?.Name, LeftId = y?.Id }); foreach (var item in output2) { Console.WriteLine($"{item.RightId} - {item.RightName} - {item.LeftId} - {item.LeftName}"); }

Console.WriteLine("Full Join"); var output3 = lstData.FullJoin(lstData2, x ⇒ x.Id, y ⇒ y.Id, (x, y) ⇒ new { RightId = x?.Id, RightName = x?.Name, LeftName = y?.Name, LeftId = y?.Id }); foreach (var item in output3) { Console.WriteLine($"{item.RightId} - {item.RightName} - {item.LeftId} - {item.LeftName}"); }

Console.WriteLine("Not Matched Join"); var output4 = lstData.NotMatchJoin(lstData2, x ⇒ x.Id, y ⇒ y.Id, (x, y) ⇒ new { RightId = x?.Id, RightName = x?.Name, LeftName = y?.Name, LeftId = y?.Id }); foreach (var item in output4) { Console.WriteLine($"{item.RightId} - {item.RightName} - {item.LeftId} - {item.LeftName}"); } Console.WriteLine("Hello, World!");

public class Data { public int Id { get; set; }

public string Name { get; set; }

}