I want to join two tables and also add some where condition in EF. I couldn't make the below code work. Could you please help me? Thanks in advance.

List<TBLDATABARCODE> freights = (from f in Entity.TBLDATABARCODE 
join p in Entity.TBLORDER on new { f.VBELN, f.POSNR } equals new { VBELN = p.DOCNUM, POSNR=p.POSNR } 
where f.FreightNo == freightNo && p.CustomerCode == dealerCode && f.Status == (byte)TBLDATADB.RowStatuses.Yuklendi 
select f).ToList();

Related posts

Recent Viewed