Hi
Now when i try to do a left outer join with other repo,
The GetAllIncluding doesn't work
if i don't have the join, it works like a champ?
Do you have any idea? Thanks
var query = (from c in _clientRepository.GetAllIncluding(co => co.Counterparty, cc => cc.ClientContact)
join ct in _companyTypeRepository.GetAll() on c.Type_Id equals ct.Id into allType
from c1 in allType.DefaultIfEmpty()
join bn in _businessNatureRepository.GetAll() on c.Nature_Id equals bn.Id into allNature
from c2 in allNature.DefaultIfEmpty()
join pm in _clientContactRepository.GetAll() on c.PurchaseManager_Id equals pm.Id into allPMgr
from c3 in allPMgr.DefaultIfEmpty()
join pp in _clientContactRepository.GetAll() on c.PurchasePerson_Id equals pp.Id into allPPerson
from c4 in allPPerson.DefaultIfEmpty()
join cp in _userRepository.GetAll() on c.ContactPerson_Id equals cp.Id into allContactPerson
from c5 in allContactPerson.DefaultIfEmpty()
select c).ToList();
seems like if i want to include 2 different collection list
i should use from c in _clientRepository.GetAllIncluding(client => client.Counterparty , bb =>bb.ContactPerson)
What if i also want to include counterparty ? Use &&?
How about the Service layer and the DTO ?
can i have some example ?