Using or operation in join query in C#
var VoucherQuery = from vH in context.VoucherHeader.Where(c => c.IsDeleted == false)
join vI in context.VoucherItem
on vH.Id equals vI.VoucherHeaderRef1
or vH.Id equals vI.VoucherHeaderRef2
select vI;
New contributor
mahdi sharifi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3