sql server 2008 - How to use OR in join while using Entity Framework -
can 1 convert following sql statement entity framework c# or vb.net me?
sql statement:
select t1.*, t2.* tblwistransacs t1 inner join tblwcbtransacs t2 on t1.ticketno = t2.ticketno or t1.ticketno = t2.customernumber
var result = (from t1 in dbcontext.tblwistransacs join t2 in dbcontext.tblwcbtransacs on 1 equals 1 (t1.ticketno == t2.ticketno || t1.ticketno == t2.customernumber) select new { t1, t2 }).tolist();
Comments
Post a Comment