How do I combine 2 lists into one in linq?

New Bee

7y1.1kLINQ

Hi there, was just wondering how I would able to combine 2 lists together so columns in list one are combined with columns in list 2. In the example below both list have ClientID and FiscalYear.

Lists 1:
ClientID | FiscalYear | TotalCars
1 19-20 100
1 20-21 230
2 19-20 50
List 2:
Client ID | FiscalYear | NumOfShops
1 19-20 5
1 20-21 6
2 19-20 4
Is there a way to combine both of those list into 1 so that the data is like:
ClientID | FiscalYear | TotalCars | NumOfShops
1 19-20 100 5
1 20-21 230 6
2 19-20 50 4

Thanks!

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhawna Tuteja6y ago
You have to use Join concept of LINQ
Priyanka K S6y ago
var combinedTables = from e in List1
join d in List2 on e.ClientID equals d.ClientID && e.FiscalYear equals d.List2
select new {e.deptno, e.TotalCars , e.FiscalYear ,d.NumOfShops };
Ashutosh Gupta6y ago
1. var newlist = from item1 in list1
2. where list2.Any(s => s.ClientID == item1.ClientID)
select new (item1.ClientID, item1.FiscalYear, item1.TotalCars, list2.First(s => s.ClientID == item1.ClientID).NumberOfShops);
Check this out.

Dhara Patel6y ago

Hi, Without join use below code :

Mario Scheeren7y ago

Something like this maybe ?

var combinedList =
from a in List1
join b in List2 on a.ClientID = b.ClientID && a.FiscalYear = b.FiscalYear
select new
{
a.ClientID,
a.FiscalYear,
a.TotalCars,
b.NumberOfShops
}