Comments by Member 11540691 (Top 1 by date)

how to write this query in linq using left outer join
please help me

select a.EventID,a.PrizeId,b.PrizeName,b.PrizeValue,c.FightID,c.Winnerid,c.WinnerName
from tblUserprize a
join tblPrizeDetails b on a.PrizeId=b.PrizeId
left outer join tblWinnersList c on a.EventID=c.EventID and a.PrizeId=c.PrizeId and c.FightID = 1534
where a.EventID = 1320