I am struggling to write this below sql query in c# linq functionality
Select * from dbo.lockerData l join dbo.User u on l.Bid= u.Bid and ((l.pid =u.pid) or (u.pid=0)) where u.code=‘123’
The above is my sql logic how to write this in linq
I know how to write linq without that or condition