'Multiple column EF core Join with Repository pattern

Hi I am new to EF Core repository pattern and trying to join 2 tables. I am looking for a way to include multiple columns in join method. below is how my code looks like -

 var Data = await _addRemoveCasRepository.GetAll().Join(_addRemoveVendorCasRepository.GetAll(),
                  arc => arc.casId,
                  arv => arv.casId, 
                     (arc, arv) => new { arc, arv }) 
                     .Select(s => new AddRemoveCas
                     {
                            provName = s.arc.provName,
                            taxId = s.arc.taxId,
                            casId = s.arc.casId,
                            billAddrLine1 = s.arc.billAddrLine1,
                            billAddrLine2 = s.arc.billAddrLine2,
                            billAddrCity = s.arc.billAddrCity,
                            billAddrSt = s.arc.billAddrSt,
                            billAddrZip = s.arc.billAddrZip,
                            billAddrZipPlus = s.arc.billAddrZipPlus,

                     }).ToListAsyncSafe();

could someone please help me add more columns in the join query? for example I want to add below columns - arc => arc.casSuffix, arv =>arv.casSuffix

I have tried adding them in the query but I get this error -
Error CS1501 No overload for method 'Join' takes 6 arguments

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Multiple column EF core Join with Repository pattern

Sources

Related Questions